An entity relationship (ER) diagram, is a graphical representation of entities and their relationships to each other. ER modelling is based on two concepts:
- Entities, defined as tables that hold specific information (data)
- Relationships, defined as the associations or interactions between entities
Recursive Relationship :
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.
A relationship between two entities of similar entity type is called a recursive relationship.
Examples :
It’s a relationship with the the same entity.
- An employee can supervise multiple employees.
- A person can have many children who are also persons.
- A student can be a class monitor and handle other students.
Please write comments if you find anything incorrect. A gentle request to share this topic on your social media profile.