A relationship between two entities of a similar entity type is called a recursive relationship. Here the same entity type participates more than once in a relationship type with a different role for each instance. In other words, a relationship has always been between occurrences in two different entities.

What is a recursive relationship given an example?

When there is a relationship between two entities of the same type, it is known as a recursive relationship. This means that the relationship is between different instances of the same entity type. Some examples of recursive relationship can be shown as follows − An employee can supervise multiple employees.

What is recursive key in database?

The key of a table which acts as a primary key of some another table. The recursive foreign key is the key which refers back to the same table i.e. the foreign key is in the same table. So Parent and child table is the same.