Keys in a relational database
Part 2 — candidate, primary, alternate and foreign keys, referential integrity and composite keys.
In this lesson you will
- Identify candidate, primary and alternate keys in a relation
- Identify foreign keys and explain referential integrity
- Choose a suitable key, including a composite key, and justify it