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 means that the primary key of the table that only has one instance (the one side) should be used as a foreign key in the table that can have multiple instances (the many side). This helps to link the records in the two tables together and establish the relationship between them. Option A is incorrect because embedding the primary key of each table as a foreign key in the related table would result in a circular reference. Option B is incorrect because the primary key on the (0,M) side is not unique and could lead to data inconsistencies. Option D is incorrect because there is a correct answer.

When Assigning Foreign Keys in a 1:M Association