Question

Which of the following fields can be unique identifiers in an employee table? Choose all that apply.

a) Name
b) Social Security Number
c) Employee Number
d) Date of Birth
e) Department
f) Email Address

Answer 1

Unique identifiers in an employee table can include Social Security Number, Employee Number, and, in some cases, Email Address, as these are unique to each employee.

Step-by-step explanation:

In an employee table, unique identifiers are used to distinctly identify each record. The fields that can serve as unique identifiers typically contain information that is unique to each individual. Therefore, the options b) Social Security Number and c) Employee Number can act as unique identifiers. Social Security Numbers are unique to each individual in the United States, and Employee Numbers are unique identifiers assigned by an organization to its employees. f) Email Address may also be considered a unique identifier if the company ensures that each employee has a unique email address. However, fields like Name and Date of Birth may not be unique, as multiple employees could potentially share the same name or birth date, and Department certainly is not unique as it applies to many employees.