Question

Which of the following data would not be a good candidate as a primary key?

A. Order number in a Customer Order table
B. Vehicle Identification Number (VIN) in an Auto Dealership vehicle table
C. Last name in a Customer table
D. Social security number in an Employee table
E. Student number in a Student table

Answer 1

The Last name in a Customer table would not be a good candidate as a primary key.

Step-by-step explanation:

A primary key is a unique identifier for each record in a database table. It should be a field or combination of fields that is unique and does not contain any null values. Among the options given, the data that would not be a good candidate as a primary key is Last name in a Customer table. This is because there can be multiple customers with the same last name, making it unable to uniquely identify each record. The other options, such as Order number, Vehicle Identification Number (VIN), Social security number, and Student number are all good candidates for primary keys as they are unique and can uniquely identify each record in their respective tables.