N-ary Relationship in DBMS

N-ary Relationship in DBMS


In this article, we will learn about n-ary 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 n-ary relationship exists.

n-ary Relationship

N-ary relationship

When a large number of entity sets  are participating in a relationship,  then such type of relationship is  called an n-ary relationship

Example of n-ary Relationship

In the real world, a patient goes to a doctor  and doctor prescribes the medicine and diagnosis  to the patient, four entities Doctor, patient and medicine, diagnostics  are involved in the relationship “prescribes” 

Read about other Types of Relationships in DBMS: