Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

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: