Which of the following pieces of data would most likely be stored (rather than derived via a query) in a relational database based on the REA model and implemented in Microsoft Access?
A) The number of different inventory items purchased from a vendor during a month.
B) An individual customer's accounts receivable balance on a specific date.
C) The quantity on hand of a particular inventory item on a specific date.
D) Actual unit selling price of an inventory item on a specific sale.
E) The balance of the company's checking account on a specific date.

Question

Quizplus · Accepted Answer

The actual unit selling price of an inventory item on a specific sale is a piece of data that is typically stored in a database because it is a specific historical fact that is recorded at the time of the transaction. Other options involve data that can be derived or calculated from other stored data.

Which of the Following Pieces of Data Would Most Likely