Which of the following is not true of recursive relationships?
A)When the recursive relationship is M:N,an intersection table is created.
B)The rows of a single table can play two different roles.
C)Recursive relationships can be 1:1,1:N,or M:N relationships.
D)When the relationship is 1:N,a new table must be defined to represent the relationship.

Question

Quizplus · Accepted Answer

When the recursive relationship is 1:N, a new table does not need to be defined to represent the relationship. Instead, the same table can be used with a foreign key referencing the primary key within the same table. Therefore, option D is the incorrect statement among the given options. A, B, C are true statements about recursive relationships.

Which of the Following Is Not True of Recursive Relationships