When designing a database, which field would NOT belong in a table storing inventory information?
A)Cost
B)Part Number
C)Purchase Order
D)Sale Price

Question

Quizplus · Accepted Answer

Purchase order is not relevant to individual inventory items, but rather to the process of purchasing inventory as a whole. It would be more appropriate to include purchase order information in a separate table for tracking purchasing activity.

When Designing a Database, Which Field Would NOT Belong in a Table