Case 17-1 Robert, the manager of a small-scale software firm, uses Microsoft Access 2016 to store employee details. He maintains the database and updates it as the details change. Robert retrieves the stored details as and when required using Access.
The only field that uniquely identifies each employee in the database is the Employee ID field. The Employee ID field is the _____.
A)foreign key
B)encrypted key
C)primary key
D)concatenated key

Question

Case 17-1 Robert, the manager of a small-scale software firm, uses Microsoft Access 2016 to store employee details. He maintains the database and updates it as the details change. Robert retrieves the stored details as and when required using Access. ​
The only field that uniquely identifies each employee in the database is the Employee ID field. The Employee ID field is the _____.
A)foreign key
B)encrypted key
C)primary key
D)concatenated key

Quizplus · Accepted Answer

The Employee ID field uniquely identifies each employee in the database, making it the primary key. A primary key is a unique identifier for each record in a database table.

Case 17-1 Robert, the Manager of a Small-Scale Software Firm