The following field names are part of a table for a company's inventory. Which field name could be the primary key for this table?
A)Sales Prices
B)Cost
C)Item ID
D)Vendor ID

Question

Quizplus · Accepted Answer

The primary key should be a unique identifier for each record in the table. The most likely candidate for this in an inventory table would be a specific identifier for each item, such as an Item ID. Sales Prices, Cost, and Vendor ID are all relevant fields but do not uniquely identify each record in the table.

The Following Field Names Are Part of a Table for a Company's