Many to One Relationship Cardinality in DBMS

April 13, 2021

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 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