Many to many Relationship Cardinality in DBMS

April 13, 2021

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

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