N-ary Relationship in DBMS

N-ary Relationship in DBMS

On this page, we will learn about n-ary relationship in DBMS.
N-ary Relationship in DBMS img

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.

Entity Relationship Diagram in DBMS n ary

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” 

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