One to One Relationship Cardinality in DBMS

One to One Relationship Cardinality

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

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

One to One Cardinality ratio

One to One cardinality

  • When a single instance of an entity is associated with a single instance of another entity, then it is called as one to one cardinality
  • Here each entity of the entity set participate only once in the relationship

Example for one to one cardinality

Assume that the only male can be married to only one female and one female can be married to only one male, this  can be viewed as one to one  cardinality.

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