Question

Which of the following is not true of recursive relationships?

a. When the recursive relationship is N:M, an intersection table is created.

b. Recursive relationships can be 1:1, 1:N, or N:M relationships.

c. The rows of a single table can play two different roles.

d. Even when the relationship is 1:N, a new table must be defined to represent the relationship.

e. The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table.

Answer 1

Recursive relationships are relationships where a table is related to itself. A new table is not always necessary in a 1:N recursive relationship.

Step-by-step explanation:

Recursive relationships are relationships where a table is related to itself. In the case of a recursive relationship, the rows of a single table can play two different roles. This means that a row in the table can be related to another row in the same table.

Given the options provided, the statement that is not true of recursive relationships is d. Even when the relationship is 1:N, a new table must be defined to represent the relationship. In a recursive relationship, a new table is not always necessary, as the relationship can be represented within the same table.

Therefore, the correct answer is d.