|<
<
14
>
>|
Primary key
Natural primary key
A
natural
primary key is a key that occurs in the data.
Examples:
Employee.SSN:
SSNs are unique. Usable as a PK assuming every employee has one.
TwitterAccount.handle:
Guaranteed unique by Twitter.
Facebook.name
:
NOT unique, so not a candidate key.
|<
<
14
>
>|