Keys

Candidate Key

A Candidate Key is a minimal set of attributes that can uniquely identify an entity. There can be multiple candidate keys for an entity.

Primary Key

The Primary Key is one of the candidate keys chosen to uniquely identify records in a table. It must be unique and not null.

Composite Key

A Composite Key is a candidate key composed of two or more attributes that together uniquely identify an entity.