When representing a 1:1 relationship in a relational database design,________.
A)the key of each table must be placed as foreign keys into the other
B)the key of either table may be placed as a foreign key into the other
C)the key of both tables must be the same
D)the intersection table gets the key from both relations
E)B and C

Question

Quizplus · Accepted Answer

In a 1:1 relationship, either table's key can be placed as a foreign key into the other table. Only one foreign key is needed to establish the relationship. Option A is incorrect because both tables do not have to have foreign keys pointing to each other. Option C and D are incorrect because in a 1:1 relationship, both tables have their own unique keys. Option E is incorrect because only option B is the correct answer.

When Representing a 1:1 Relationship in a Relational Database Design,________