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

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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

ISE Data Analytics For Accounting

ISBN: 9781265094454

3rd Edition

Authors: Ryan A. Teeter, Vernon Richardson, Katie L. Terrell

Question Posted: