If a 1:M relationship is mandatory on both sides,which of the following is true?
A)The resulting foreign key can have null (empty)values
B)The resulting foreign key cannot have null (empty)values
C)The resulting foreign key must have null (empty)values
D)No foreign key is created as a result of mapping such a relationship

Question

Quizplus · Accepted Answer

If the 1:M relationship is mandatory on both sides, then the resulting foreign key cannot have null (empty) values. This ensures that every record in the child table has a corresponding record in the parent table, and vice versa, with no missing or orphaned records.

If a 1:M Relationship Is Mandatory on Both Sides,which of the Following