Many to many Relationship Cardinality in DBMS
Many to many Relationship Cardinality
On this page, we will learn about Many to Many Relationship Cardinality in DBMS.
Many to many Relationship Cardinality in DBMS
Cardinality tells how many times the entity of an entity set participates in a relationship
There are four different types of cardinalities one to one, many to one, one to many, many to many.he will discuss how many to many cardinality how is observed.
Many-to-many cardinality
- Here more than one instance of an entity is associated with more than one instance of another entity then it is called many to many relationships
- In this cardinality, entities in all entity sets can take participate any number of times in the relationship cardinality is many to many.
Example for many to many cardinality
- In the Real world assume that a student can take more than one course and the single course can be taken by any number of students this relationship will be many to many relationship
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