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.
This was first published in January 2007