Entity keys
- A candidate key is a minimal set of attributes of the
entity type that uniquely identifies an entity.
- An entity set has one or more candidate keys.
Primary key
- One of the candidate keys is selected to be the primary key.
This is the major unique identifier of entities within the entity set.
- In a relational database, one entity refers to another using the
primary key's value.
|