Which is most suitable to serve as the primary key for employee records in a database.

Question

Question 32 options:

The employee's gender

The employee's last name

The employee's unique identification number

The employee's start date

Answer 1

The most suitable option to serve as the primary key for employee records in a database is the employee's unique identification number.

A primary key must be unique for each record, cannot be null, and should remain constant over time. The employee's unique identification number meets these criteria, whereas the other options (gender, last name, and start date) may not uniquely identify an employee and could change (e.g., if an employee changes their last name).