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 ratio 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 Relationship Cardinality ratio in DBMS

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

Checkout list of all the video courses in PrepInsta Prime Subscription

Checkout list of all the video courses in PrepInsta Prime Subscription