Which of the following is NOT a good candidate for a primary key field for a Customer table?
A) Last Name
B) Customer Number
C) Employee Identification Number
D) Customer ID

Name: Which of the following is NOT a good candidate for a primary key field for a Customer table? A) Last Name B) Customer Number C) Employee Identification Number D) Customer ID
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

Quizplus · Accepted Answer

Last Name is not unique and can be shared by multiple customers, making it unsuitable as a primary key.

Which of the Following Is NOT a Good Candidate for a Primary