Why recursive relationships are not good

Question

Why recursive relationships are not good? How do you solve them?

Answer 1

Recursive relationships are an interesting and further complex concept than the relationships you have considered in the previous chapters, like a one-to-one, one-to-many, and many more. A recursive relationship happens when there is a relationship among an entity and itself. For illustration, a one-to-many recursive relationship happens when an employee is the manager of other workers. The employee entity is associated to itself, and there is a one-to-many relationship between one employee (the manager) and many other employees (those people who report to the manager). Due to the more complex nature of these relationships, we will require slightly more complex methods of mapping to them to a schema and displaying them within a stylesheet.