Please login


Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

Recursive Relationship in DBMS

Recursive  Relationship in DBMS


In this article, we will learn about 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

Recursive Relationship in DBMS

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 
Read about other Types of Relationships in DBMS: