Ternary Relationship in DBMS

Ternary Relationship in DBMS

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

Ternary Relationships in DBMS

Ternary relationship

When there are exactly three entity sets participating in a relationship then such type of relationship is called ternary relationship

Example of Ternary Relationship

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

Read about other Types of Relationships in DBMS: