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

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: