When assigning foreign keys in a 1:M 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,M) 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,M) side
D)none of the above is true

Question

Quizplus · Accepted Answer

In a 1:M association, the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,M) side. This is because the (1,1) side represents the one entity that associates with multiple entities on the (0,M) side. Therefore, the primary key from the (1,1) side is used as a foreign key in the related table on the (0,M) side to establish this relationship.

When Assigning Foreign Keys in a 1:M Association