Database Reference
In-Depth Information
Figure 10.9. A typical example of a one-to-many relationship
A customer can check out any number of items, so a single record in the CUSTOMERS
table can be related to one or more records in the CUSTOMER RENTALS table. A single
item,however,isassociatedwithonlyonecustomeratanygiventime,soasinglerecordin
the CUSTOMER RENTALS table is related to only one record in the CUSTOMERS table.
Figure 10.10
shows a generic example of how you create a relationship diagram for a one-
to-many relationship.
Figure 10.10. Diagramming a one-to-many relationship
