Many to One Relationship Cardinality in DBMS
Many to One Relationship Cardinality
On this page, we will learn about the Many to One Relationship Cardinality in DBMS.
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
Prime Course Trailer
Related Banners
Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription
Get over 200+ course One Subscription
Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others
Login/Signup to comment