An "Inventory Type" entity has the following attributes: part name, supplier number, part number, purchase date, quantity on hand, and cost. Which attribute is the best primary key for the Inventory Type entity?

Question

Quizplus · Accepted Answer

The part number is the best primary key because it uniquely identifies each inventory item, whereas other attributes like cost, quantity, supplier ID, and purchase date may not be unique.

An "Inventory Type" Entity Has the Following Attributes: Part Name