Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.
A) CustomerNumber
B) LastName
C) CustomerID
D) IdentificationNumber

Question

Quizplus · Accepted Answer

CustomerNumber, CustomerID, and IdentificationNumber are all unique identifiers that can serve as primary keys because they are likely to be unique for each customer. LastName is not suitable as it may not be unique.

Which of the Following Are Good Candidates for a Primary