Binary Relationship in DBMS

Binary Relationship in DBMS


In this article, we will learn about the 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.

Binary Relationships in Entity Relationship Diagram in DBMS

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

Read about other Types of Relationships in DBMS: