Database Reference
In-Depth Information
A one-to-many relationship exists between a pair of tables when a single record in the first
table can be related to many records in the second table, but a single record in the second
table can be related to only one record in the first table.
The example in following figure illustrates a typical one-to-many relationship. A single re-
cord in the Department table can be linked to one or more records in the Faculty table, but
a single record in the Faculty table is related to only one record in the Department table.
Department ID is a foreign key in the Faculty table ( more detail in chapter 4).
