Unary or Recursive Relationship in DBMS

Updated

An entity relationship (ER) diagram, is a graphical representation of entities and their relationships to each other. ER modelling is based on two concepts:

  1. Entities, defined as tables that hold specific information (data)
  2. 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.

Comment
Next tutorial
CPP_Programmer Published 18 Sep 2020 · 1 min read
Topics:

Related tutorials

  • What is a database link in DBMS and its types

    We can define a database link to be a connection between 2 databases or two or more physical databases. Database links plays an significant role in case of…

    3 min read
  • Database Transaction Models and the CAP Theorem

    According to Brewer’s theorem (also called CAP theorem), any distributed data store (like a database) can only provide two of the following three guarantees: Consistency Availability Partition tolerance…

    3 min read
  • Some Interesting Facts About MySQL

    MySQL is a relational database management system (RDBMS) based on SQL- Structured Query Language and is free and open source.MySQL was created by MySQL AB, a Swedish company…

    2 min read
  • Normalization in DBMS: 1NF, 2NF, 3NF and BCNF

    If a table has data redundancy and is not properly normalized, then it will be difficult to handle and update the database, without facing data loss. It will…

    4 min read
  • Need for DBMS

    Database Management System (DBMS) is a system software for easy, efficient and reliable data processing and management. It can be used for: Creation of a database. Updating the…

    2 min read
  • Users in DBMS environment

    Database Management System (DBMS) is used to optimize and manage the storage and retrieval of data from databases. DBMS offers a systematic approach to manage databases and workloads…

    2 min read