Given a database with the following fields: - Item_Name - First_Name - Item_Price - Customer_ID Which of the following is the best primary key?

The correct answer is D. Customer_ID. A primary key must uniquely identify each record in the database. Among the given fields, Customer_ID is the best choice because it is most likely to be unique for each customer, ensuring there are no duplicate records. The other fields, such as Item_Name, First_Name, or…

Data Concepts and Environments

Question

Given a database with the following fields:

Item_Name
First_Name
Item_Price
Customer_ID

Which of the following is the best primary key?

Options

AItem_Name
BFirst_Name
CItem_Price
DCustomer_ID

How the community answered

(31 responses)

A
6% (2)
B
3% (1)
C
3% (1)
D
87% (27)

Explanation

A primary key must uniquely identify each record in the database. Among the given fields, Customer_ID is the best choice because it is most likely to be unique for each customer, ensuring there are no duplicate records. The other fields, such as Item_Name, First_Name, or Item_Price, are not guaranteed to be unique and, therefore, are not suitable as primary keys.

Topics

#Primary Key#Database Design#Data Modeling#Relational Databases

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice