An easy-to-follow tutorial covering the whole gamut of RDBMS keys: primary keys, candidate keys, superkeys, alternate keys, foreign keys, surrogate keys, natural keys, simple keys, composite keys, compound keys, and intelligent keys. Featuring lots of examples and a focus on the design process.
0:00 Introduction
0:53 Primary Keys
3:29 Candidate Keys
6:09 Superkeys
7:57 Alternate Keys
8:49 Foreign Keys
10:39 Surrogate vs. Natural Keys
16:55 Composite vs. Simple Keys
18:02 Compound Keys
19:01 Intelligent Keys