Why is cost information stored in several relational tables?
What will be an ideal response?
Answer: Cost information is stored in several tables. Standard cost is stored as an attribute of the Inventory table because it is the same for all units of a given inventory item for a fiscal year. In contrast, the actual cost of inventory is stored in the Inventory- Order_Goods table. This reflects the fact that purchase prices can vary over time. By storing the cost of each order with the quantity purchased, the system can calculate the actual cost of ending inventory and the cost of goods sold according to any accepted inventory valuation method (LIFO, FIFO, weighted-average, or specific identification). If, on the other hand, actual cost were stored as an attribute of the Inventory table, it would necessitate using the weighted-average method because all units of a given inventory item would be assigned the same cost. In addition, cost data would be available only in this format; it would be impossible to compute alternative values for inventory because the detailed data about the cost associated with each purchase would not be stored in the database.
You might also like to view...
Provide a list and a short explanation of the four interpersonal skills in which management styles are often addressed in training
What will be an ideal response?
Q9 Networks is a leading provider of outsourced data center infrastructure such as web-servers and data storage. Use the financial information in the table to calculate Q9's maximum internal growth rate
Selected Ratios Q9 Networks Year 5 ROE 0.10% ROA 0.09% Net Profit Margin 0.27% Total Asset Turnover 0.33 Dividend Payout Rate 0% A) 0.09% B) 0.10% C) 0.13% D) 0.16% E) 0.20%