1
SQLIntermediate#normalization
SQLIntermediate#keys
What is a candidate key and a super key?
A super key is any set of columns that uniquely identifies a row. A candidate key is a minimal super key; one candidate key is chosen as the primary key and the rest are alternate keys.
Example
In employees(emp_id, email, name): {emp_id}, {email} are candidate keys.
{emp_id, name} is a super key but not minimal.