InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are Recursive Relationships? |
|
Answer» Recursive RELATIONSHIPS occur when there is a relationship between an entity and itself. These relationships are complex and would require more complex approaches of mapping the data to a schema. Consider an instance where a doctor is marked as a care provider in the health care database. Now if the doctor himself falls sick, he NEEDS to go to another doctor as a patient which results in recursive relationships. To accommodate this, we add a foreign key to the health CENTRE’s NUMBER in EVERY patient’s record. Care needs to be taken for ensuring that the recursion has an exit path in such entity relations. |
|