Recursive Relationship in DBMS

Understanding recursive relationship in DBMS

In this blog we will try to understand how recursive relationship works in DBMS.

recursive

Recursive  Relationship in DBMS

  • A relationship represents the association between two are more entities
  • The relationship also shows the different entity sets that are participating in a relationship, these relationships very much useful analyzing the design process of the system

We have observed unary, binary n-ary, recursive, ternary relationships in a database design schema. Here  we will discuss how  recursive relationship exists

Types of Relationships in DBMS recursive

Recursive relationship

  • Relationship between two entities of the same type is called recursive relationship,
  • A Recursive relationship is nothing but, simply an entity is having a relationship with self

Example of recursive Relationship

  • The person who is a supervisor for many other employees also come under employees category
  • Student can be a class monitor and handle other students but a person who is working as a class leader is itself a student of the class and hence a class monitor has a recursive relationship of entity student 

Prime Course Trailer

Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others

Checkout list of all the video courses in PrepInsta Prime Subscription

Checkout list of all the video courses in PrepInsta Prime Subscription