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
- 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
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
Login/Signup to comment