Based on the customer table below, which of the attributes do you think represents the primary key?
Customer table

A) Address
B) Name
C) Customer_Number
D) Zip

Question

Based on the customer table below, which of the attributes do you think represents the primary key?
Customer table

A) Address 
B) Name 
C) Customer_Number 
D) Zip

Quizplus · Accepted Answer

In most cases, a unique identifier such as "Customer Number" is used as a primary key in a customer table as it uniquely identifies each customer. It is less likely that "Name," "Address," or "Zip" would be used as a primary key since they may not be unique or can change over time.

Based on the Customer Table Below, Which of the Attributes