If a 1:M relationship is optional on both sides, which of the following is true?
ID: 3661434 • Letter: I
Question
If a 1:M relationship is optional on both sides, which of the following is true?
The resulting foreign key can have null (empty) values
The resulting foreign key cannot have null (empty) values
The resulting foreign key must have null (empty) values
No foreign key is created as a result of mapping such a relationship
The resulting foreign key can have null (empty) values
The resulting foreign key cannot have null (empty) values
The resulting foreign key must have null (empty) values
No foreign key is created as a result of mapping such a relationship
Explanation / Answer
If a 1:M relationship is optional on both sides, which of the following is true?
Answer:
The resulting foreign key can have null (empty) values
Reason:
The minimum cardinality of the Offering entity table in the relationship is optional
(may be or can be 0) in 1:M relationship. So the foreign key should allow NULL values
in the foreign key.