Binary Relationship in DBMS

Binary Relationship

On this page, we will learn about Binary Relationship in DBMS.
Binary Relationship in DBMS

Binary Relationship in DBMS

  • A relationship represents the association between two are more entities
  • The relationship also shows the different entity sets that are participating in a relationship, these relationships very much useful analyzing the design process of the system

We have observed unary, binary n-ary, recursive, ternary relationships in a database design schema. Here  we will discuss how binary relationship exists.

Types of Relationships in DBMS binary

Binary relationship

When there are exactly two  entity sets participating in a relationship then such type of relationship is called binary relationship

Example of binary relationship

For example, a teacher  teaches a  subject here 2  entities are teacher and subject for the   relationship  teacher teaches subject

Prime Course Trailer

Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription