A one-to-many relationship exists between entities when the maximum cardinality of one entity is __________ and the maximum cardinality for the other entity in that relationship is __________.
A)1; 1
B)1; N
C)M; N
D)M; M

Question

Quizplus · Accepted Answer

In a one-to-many relationship, the maximum cardinality of the "one" entity is 1, and the maximum cardinality of the "many" entity is N (meaning there can be many instances of the "many" entity associated with each instance of the "one" entity). Choice A is incorrect because both entities would have a maximum cardinality of 1, indicating a one-to-one relationship. Choice C is an incorrect opposite definition for a many-to-many relationship, where both entities can have multiple instances associated with each other. Choice D is also incorrect because it describes a many-to-many relationship, where both entities can have multiple instances associated with each other.

A One-To-Many Relationship Exists Between Entities When the Maximum Cardinality