An entity may have one or more choices for the primary
key. Collectively these are known as candidate
keys. One is selected as the primary
key. Those not selected are known as
secondary keys. For example, an employee has an employee number, a National Insurance (NI) number and an email address.
read more >>