Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

Question

Quizplus · Accepted Answer

In a database, a candidate key is a column, or set of columns, that can uniquely identify any database record without referring to any other data. When one candidate key is chosen as the primary key, the others are considered alternate keys.

Social Security Number and Employee ID Are Candidate Keys for a Table