When assigning foreign keys in a 1:1 association:
A) The primary key of each table should be embedded as a foreign key in the related table
B) The primary key on the (0,1) side of the relation should be embedded as the foreign key on the (1,1) side.
C) The primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,1) side.
D) None of the above is true

Question

Quizplus · Accepted Answer

In a 1:1 association, one record in each table is associated with one record in the other table. Therefore, the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,1) side. This ensures that each record on the (0,1) side references one and only one record on the (1,1) side.

When Assigning Foreign Keys in a 1:1 Association