Ternary Relationship in DBMS
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 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
Login/Signup to comment