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 sansidered an alternate key.

Question

Quizplus · Accepted Answer

In database terminology, a candidate key is a column, or set of columns, that can uniquely identify a row in a table. When one candidate key is chosen as the primary key, the other candidate keys are considered alternate keys.

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