To represent a one-to-many relationship in a relational database design,________.
A)the key of the child is placed as a foreign key into the parent
B)the key of the parent is placed as a foreign key into the child
C)an intersection table must be created
D)the key of the table on the "many" side is placed in the table on the "one" side

Question

Quizplus · Accepted Answer

In a one-to-many relationship, the foreign key of the parent table is placed in the child table. This allows for multiple records in the child table to correspond to a single record in the parent table. An intersection table is used in a many-to-many relationship, not a one-to-many relationship. Placing the key of the table on the "many" side in the table on the "one" side would also not be the correct approach.

To Represent a One-To-Many Relationship in a Relational Database Design,________