September 2007
Intermediate to advanced
600 pages
20h 21m
English
The type of relationship discussed up to this point is called a one-to-many relationship. This kind of relationship allows an association between a single row in one table and multiple rows in another table. In the example, a single row in the movie list table can be associated with many rows in the expenses table. The one-to-many relationship is the most common type of relationship in a relational database.
Two other types of relational database relationships exist: one-to-one and many-to-many.
The one-to-one relationship allows a single row in one table to be associated with no more than one row in another table. This type of relationship is used infrequently. In practice, if you run into a situation in which ...
Read now
Unlock full access