Can you explain what is meant by a recursive relationship? Give a real-life example.
This article does a nice job of discussing recursive relationships.
Basically, a recursive relationship is one where an entity is related to a similar entity. For instance, the entity might be PERSON. An attribute of the entity might be MOTHER, which is a PERSON itself. A recursive relationship has been defined because one row in the PERSON table refers to another row in the same PERSON table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.