Which of the following is NOT a good candidate for a 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 key field for a Customer table? A)Last Name B)Customer Number C)Employee Identification Number D)Customer ID
Brand: Quizplus
Rating: 4.8 (31 reviews)

Question

Quizplus · Accepted Answer

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

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