If a 1:M relationship is optional 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 a 1:M relationship is optional on both sides, then it means that one record in the '1' table can be related to multiple records in the 'M' table, but it doesn't have to be mandatory to have a match. Similarly, a record in the 'M' table can be related to only one record in the '1' table or none at all. In this scenario, the resulting foreign key in the 'M' table can have null values because not every record in the 'M' table needs to have a match in the '1' table. Therefore, option A is correct.

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