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
ISE Data Analytics For Accounting
ISBN: 9781265094454
3rd Edition
Authors: Ryan A. Teeter, Vernon Richardson, Katie L. Terrell
Question Posted: