If a 1:M relationship is mandatory on the 1 side and optional on the M side,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

In a mandatory 1:M relationship, every record in the 1 table must have at least one related record in the M table. However, in the M table, some records may not have a related record in the 1 table. Therefore, the foreign key in the M table cannot be null as every record needs to have a reference to the 1 table.

If a 1:M Relationship Is Mandatory on the 1 Side