DATABASE MANAGEMENT SYSTEM
  • ENTITY AND ENTITY SET
  • Entity:
    • An entity is a real-world object or concept that is distinguishable from other objects.
    • In the context of a database, entities are often represented as tables. Each row in the table represents a specific instance or occurrence of the entity.
    • Example: In a university database, "Student," "Professor," and "Course" can be considered entities.
  • Entity Set:
    • An entity set is a collection of similar entities. It represents the set of all instances of a particular entity type.
    • Each entity in the set has the same set of attributes, but the actual values for these attributes may differ from one instance to another.
    • Example: The "Student" entity set includes all individual students, and each student in the set has attributes like "StudentID," "Name," and "Date_of_Birth."