Recursive relationships can have all of the following maximum cardinalities except ________.
A)1:1
B)1:N
C)N:M
D)M:M

Question

Quizplus · Accepted Answer

Recursive relationships cannot have a maximum cardinality of M:M because it would mean that a single entity can be related to multiple instances of itself, which is not possible in a relational database. It is possible for a recursive relationship to have a maximum cardinality of 1:1, 1:N, or N:M.

Recursive Relationships Can Have All of the Following Maximum Cardinalities