Answer to Question #295415 in Accounting for Jen

Question

You are presented with a data stream that has the following elements and values: SaleDate: 04/07/X5, SaleID: 324581, CustID: A543, Terms: Net 30, ProductID: (002743, 000378, 000732, 000762), Sold Quantity: (1, 1, 4, 12). Which of the four database requirements listed in the text would be violated if this data stream were placed in a table? If you have insufficient information to assess whether the requirement has been violated, discuss the additional data that you would need.

Answer 1

Insufficient information are provided to assess whether the requirement has been violated.

The sales price per unit is missing in the data. The user of the information can't know about the sales volume as sales quantity is given but the sales price per unit is missing to determined the sales volume.

If the sales price per unit is given then we can access the database requirements.