Firstly just to mention, this whole post will use web development for reference but the principles are applicable to all software using database designs.
When designing a database for a medium to large program / system it is best to keep an open mind with regards to future additional development on the system and design the database accordingly.
First we run through some of the table relational options.
1: one to one relation
2: one to many relation
3: many to many relation