The preferred placement for a foreign key when working with a 1:1 relationship is to .
A) use the same primary key for both entities
B) create a bridge entity
C) place the foreign key in one of the entities
D) place the surrogate key in both entities

Question

Quizplus · Accepted Answer

In a 1:1 relationship, the foreign key can be placed in either of the entities. However, it is preferred to place the foreign key in the entity that is usually accessed secondarily as it can improve performance. This is because the primary key of the main entity can be used as a clustered index for faster access, whereas the secondary entity would require a non-clustered index on the foreign key for speedy access.

The Preferred Placement for a Foreign Key When Working with a 1:1