Ternary Relationship in DBMS

Ternary Relationship in DBMS

On this page, we will learn about Ternary Relationship in DBMS.
Ternary Relationship in DBMS img
  • 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.

Types of Relationships in DBMS ternary

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”

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