One to Many Relationships
Ace your homework & exams now with Quizwiz!
There are three types of relationships between tables.
They are called one to one, one to many, and many to many.
One to many relationships
This type of relationship means that one row in one table can be related to many rows in another table at the other side of the relationship, but not vice versa. The many can only happen in one direction.
If you ever get confused as to which side is the foreign key,
an easy trick to remember is that the foreign key always goes on the many side.
One to Many relationships are by far
the most common type of table relationship.
