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...

1 answer below »





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.
Answered Same DaySep 03, 2021

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

Neha answered on Sep 06 2021
144 Votes
Question 1
1) Which product was sold the most?
Tables – FGIProduct, Sales_Subset
Attributes – Pro
duct_Code, Sales_Order_Quantity
2) Which product was sold least on which date?
Tables – FGIProduct, Sales_Subset
Attributes – Product_Code, Sales_Order_Quantity, Sales_Order_Date
3) Which city has...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here