One to Many Relationship Cardinality in DBMS

One to Many Relationship Cardinality

On this page, we will learn about One to Many Relationship Cardinality in DBMS.
One to Many Relationship Cardinality in DBMS

One 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’ here will discuss how many to one cardinality  is observed

One to Many Relationship Cardinality in DBMS img

One-to-Many  cardinality

  • When is a single instance of an entity is associated with more than one instance of another entity then this type of relationship is called one to many relationships
  • Here entities in one entity set can take participation in  any number of times in relationships set and entities in another entity set can take participation only once in a relationship set

Example for one to many cardinalities

 For example in the Real world, many students can study in a single college but the student cannot apply to more than one college at the same time

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

Checkout list of all the video courses in PrepInsta Prime Subscription

Checkout list of all the video courses in PrepInsta Prime Subscription