If a 1:M relationship is mandatory on the M side and optional on the 1 side,and if the table resulting from the 1 side has 3 records,then the table resulting from the M side cannot have less than ________ records.
A)0
B)1
C)2
D)3

Question

Quizplus · Accepted Answer

Since the relationship is mandatory on the M side, every record in the M side table must be associated with a record in the 1 side table. However, since it's optional on the 1 side, not every record on the 1 side needs to have a corresponding record on the M side. Given there are 3 records on the 1 side, the minimum number of records on the M side to satisfy the mandatory relationship is 3, one for each record on the 1 side.

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