Many to many Relationship Cardinality in DBMS

Many to many Relationship Cardinality in DBMS

 

In this article, we will learn about 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 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
Read More About other Cardinalities :