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.