BCA / B.Tech 4 min read

What is an Entity Set?

What is an Entity Set in DBMS?

An Entity Set is a collection of all entities of the same type that share the same properties or attributes. For example, a "Students" entity set would contain all the student entities in a university database.

Types of Entity Sets:
  • Strong Entity Set: An entity set that has its own primary key and does not depend on any other entity set for its existence. For example, a `Student` entity set with a unique `StudentID`.
  • Weak Entity Set: An entity set that does not have a sufficient number of attributes to form a primary key on its own. It depends on another "owner" entity. For example, a `Dependent` entity set might depend on an `Employee` entity set.

Entity sets are fundamental components of the Entity-Relationship (ER) model, helping to structure and organize data in a database design.