BCA / B.Tech 9 min read

What is an Entity in DBMS?

Entity in DBMS:

In a Database Management System (DBMS), an Entity is a real-world object or concept that can be distinctly identified. Data about entities is stored in the database. For example, in a university database, `Student`, `Professor`, and `Course` are all entities.

Key Points about Entities:
  • Attributes: Entities have properties or characteristics called attributes. For example, a `Student` entity might have attributes like `StudentID`, `Name`, and `Major`.
  • Entity Set: An entity set is a collection of all entities of the same type. For example, the set of all students in the university is the `Student` entity set.

Types of Entities:
  • Strong Entity: An entity that has a primary key and can exist independently. `Student` is a strong entity because it has a unique `StudentID`.
  • Weak Entity: An entity that cannot be uniquely identified by its attributes alone and depends on a relationship with another (strong) entity. For example, a `Dependent` entity might depend on an `Employee` entity.

Entities and their relationships are visualized using Entity-Relationship Diagrams (ERDs).