Data Modeling Question:

Download Job Interview Questions and Answers PDF

Why are recursive relationships are bad? How do you resolve them?

Data Modeling Interview Question
Data Modeling Interview Question

Answer:

Recursive relationships are an interesting and more complex concept than the relationships you have seen in the previous chapters, such as a one-to-one, one-to-many, and many-to-many. A recursive relationship occurs when there is a relationship between an entity and itself. For example, a one-to-many recursive relationship occurs when an employee is the manager of other employeess. The employee entity is related to itself, and there is a one-to-many relationship between one employee (the manager) and many other employees (the people who report to the manager). Because of the more complex nature of these relationships, we will need slightly more complex methods of mapping them to a schema and displaying them in a stylesheet.

Download Data Modeling Interview Questions And Answers PDF

Previous QuestionNext Question
What is third normal form?Is this statement TRUE or FALSE? all databases must be in third normal form?