Entity Set

Each entity type will have a collection of entities stored in the database Called the
entity set.
The above example shows three CAR entity instances in the entity set for CAR
Same name (CAR) used to refer to both the entity type and the entity set.
Entity set is the current state of the entities of thattype that are stored in the database.
Initial Design of Entity Types for the COMPANY Database Schema
Based on the requirements, we can identify four initial entity types in the COMPANY
database:
DEPARTMENT
PROJECT
EMPLOYEE
DEPENDENT
Their initial design is shown below.
The initial attributes shown are derived from the requirements description

0 comments