You are given the Inventory, Sales, and Sales-Inventory tables and their associated attributes from a company’s database:

Discuss why the Inventory table does not have a “current quantity on hand” attribute and why the Sales table  not have a “Total invoice amount” attribute.

Transcribed Image Text:

Inventory Item number Item description Item list price Item cost Item beginning quantity on hand Item reorder quantity Item reorder point Sales-Inventory Invoice number Item number Quantity sold Sales price Sales Invoice number Customer number Employee number Sales order number Invoice date Invoice time Invoice sent (Y/N)