Question

What feature would make the best primary key in an inventory table?

1) name
2) location
3) cost
4) number
5) supplies

Answer 1

The best primary key for an inventory table is an identifier unique to each item, such as a serial number or SKU rather than name, location, or cost.

Step-by-step explanation:

In terms of selecting the best primary key for an inventory table, the most suitable choice would typically be an identifier that is unique to each item, such as a serial number or stock keeping unit (SKU). Options like name, location, cost, and supplies may not be unique or may change over time, which could cause issues in database integrity. A primary key should be unique, consistent, and permanent. Therefore, number (if it refers to a unique identifier like a serial number or SKU) would make the best primary key.