Finally, for each question, identify the specific tables and attributes that are needed to answer...

Question

Finally, for each question, identify the specific tables and attributes that are needed to answer your questions. Use Lab Exhibit 2-1A for guidance on what tables and attributes are available. For example, to answer the question about state sales, you would need the [Customer_St] attribute that is located in the [Customer] master table as well as the [Sales_Order_Quantity_Sold] attribute in the [Sales] table. If you had access to store or distribution center location data, you may also look for a [State] field there, as well.

Neha · Accepted Answer

Question 1
1) Which product was sold the most?
Tables – FGIProduct, Sales_Subset
Attributes – Product_Code, Sales_Order_Quantity
2) Which product was sold least on which date?
Tables – FGIProduct, Sales_Subset
Attributes – Product_Code, Sales_Order_Quantity,

Finally, for each question, identify the specific tables and attributes that are needed to answer your questions. Use Lab Exhibit 2-1A for guidance on what tables and attributes are available. For...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment