The Inventory Table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc. First, the table organizes the financial data into department, then financial account codes, item, and then sums the total amount of transactions for the code and then counts how many quantities of the items were in inventory during the period. Second, I think that this design maximizes the visual and informational presentation for the financial data. Given this design, the user of the information can readily identify what items belong to a certain department, and how many items were in to arrive at the total cost for a particular item for the period. Third, given the presentation of the total amount and quantity on hand for an item, the information user can easily calculate the effective average purchases price for an item. .
Entity Relationship Diagram
The following diagram (1-1) is entity relationship (E-R) diagram and it illustrates the existing data tables.
Recommend improvements to the data tables
The data tables, specifically the Pivot table, may be improved on by arranging the codes chronologically. This would facilitate easy...