Many to One Relationship Cardinality in DBMS

Many to One Relationship Cardinality in DBMS

 

In this article, we will learn about the Many to One 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 one cardinality how is observed

Many to One Relationship Cardinality in DBMS

Many-to-one cardinality

When entities in one entity set can participate only once in a relationship set and entities in another entity can participate more than once in the relationship set,  then such type of cardinality is called many-to-one.

 

Example for many to one cardinality

  • In real time a student takes only one course but a single course can be taken by any number of students. so many to  one relationship is observed here
  • It means that one course can be taken by any number of students but only one course can be allotted to one student 
Read More About other Cardinalities :