Database Reference
In-Depth Information
Figure 10.4. A typical example of a one-to-one relationship
Although the fields in these tables could be combined into a single table, the database de-
signer chose to place the fields that can be viewed by anyone in the organization in the
EMPLOYEES table and the fields that can be viewed only by authorized personnel in the
COMPENSATION table. Only one record is required to store the compensation data for
a given employee, so there is a distinct one-to-one relationship between a record in the
EMPLOYEES table and a record in the COMPENSATION table.
Figure 10.5
shows a generic example of how you create a relationship diagram for a one-
to-one relationship.
