Home BCA/BTech JEE RAS RSCIT Blogs
Switch Language हिन्दी
BCA / B.Tech 10 min read

What is a Relationship Set?

Quick Summary & Key Takeaways

  • • Subject Focus: DBMS Notes in English (BCA / B.Tech Syllabus)
  • • Core Topic: What is a Relationship Set? - General Topics
  • • Overview: Relationship Set in DBMS: A Relationship Set is a collection of relationships of the same type among two or more entity sets. In an ER diagram, it is r...
  • • Key Concepts: Relationship set, One to one many to many Hindi, Participation cardinality,

Relationship Set in DBMS:

A Relationship Set is a collection of relationships of the same type among two or more entity sets. In an ER diagram, it is represented by a diamond shape. The Degree of a relationship set is the number of entity sets that participate in the relationship.

Types of Relationship Sets based on Degree:
  • Unary Relationship (Degree 1): A relationship within a single entity set. This is also called a recursive relationship. For example, an `Employee` entity set where one employee can manage another employee.
  • Binary Relationship (Degree 2): The most common type, involving a relationship between two entity sets. For example, a `Student` entity set and a `Course` entity set are related via "enrolls in."
  • Ternary Relationship (Degree 3): A relationship involving three entity sets. For example, a `Doctor` prescribes a `Medicine` for a `Patient`.

Relationships also have cardinality (one-to-one, one-to-many, many-to-many) which defines the number of entities that can be associated with another entity through the relationship set.

Frequently Asked Questions (FAQs)

Relationship Set in DBMS: A Relationship Set is a collection of relationships of the same type among two or more entity sets.
Understanding What is a Relationship Set? is fundamental to mastering DBMS Notes in English. It covers crucial concepts, solved problems, and revision points essential for academic and entrance exam success.
You can read free solved examples, detailed explanations, and key formulas for What is a Relationship Set? directly on the NotesMedia website or by downloading the NotesMedia App.

In this Chapter

What is a Relationship Set?
What is DBMS in English
What is a Database in English
Advantages and Disadvantages of DBMS in English
Data Independence in English – What is Data Independence?
BCA || DBMS(Database Management System) 2025 (Supplementary) Paper || MDSU Exam Paper
What is an Entity in DBMS?
Database Languages
What is an Entity Set?
Entity-Relationship (ER) Model
Data Models & Their Types
JOINs and Their Types
Tuples and Their Types
What is a Database Instance?
What is a Domain in DBMS?
Database Interfaces and Their Types
Data Abstraction in DBMS
Data Integrity in DBMS
What is a Database Schema?
Database Constraints
Keys in DBMS and Their Types
What is a Data Dictionary?
What is a Distributed File System?
Difference Between DBMS & Filesystem
DBMS Security
Relational Algebra
Database Recovery
Inference Rules
Dependencies and Their Types
File Organization
Distributed Database System
Normalization
BCA | DBMS 2022 Paper | MDSU Exam Paper