Which of the following is true when implementing a one-to-many relationship?
A) The file on the one end has a foreign key consisting of the primary key of the many end.
B) The file on the one end has a concatenated key of its primary key and the many end key.
C) The file on the many end has a foreign key consisting of the primary key on the one end.
D) The file on the many end has a concatenated key of its primary key and the one end key.

Question

Quizplus · Accepted Answer

In a one-to-many relationship, the file on the many end should have a foreign key consisting of the primary key on the one end. This allows for multiple records on the many end to be tied to a single record on the one end. Option A is incorrect because the foreign key should be on the many end, not the one end. Option B is incorrect because a concatenated key is not necessary for a one-to-many relationship. Option D is incorrect because the primary key on the many end should only consist of its own unique identifier, not the identifier of the record on the one end.

Which of the Following Is True When Implementing a One-To-Many