Question: Finally, for each question, identify the specific tables and fields that are needed to answer your questions. Use the data dictionary and ER Diagram provided

Finally, for each question, identify the specific tables and fields that are needed to answer your questions. Use the data dictionary and ER Diagram provided in Appendix J for guidance on what tables and attributes are available. For example, to answer the question about state sales, you would need the Customer_State 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Data Analytics Accounting Questions!