Which of the following is not true about N:M recursive relationships?
A)Both foreign keys in the intersection table refer to the same table.
B)Since it is a recursive relationship,an intersection table is not needed.
C)The foreign keys in the intersection table can't refer to the same attribute in the parent table.
D)Both B and C are correct.

Question

Quizplus · Accepted Answer

Both B and C are correct explanations for what is not true about N:M recursive relationships. An intersection table is indeed needed to resolve the many-to-many relationship, even in recursive relationships. Also, the foreign keys in the intersection table refer to the same entity but must represent different instances, hence they can refer to the same attribute in the parent table.

Which of the Following Is Not True About N:M Recursive