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