Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Identify the Questions One of Slinte's first priorities is to identify its areas of success as well as areas of potential improvement.

image text in transcribed

Part 1: Identify the Questions One of Slinte's first priorities is to identify its areas of success as well as areas of potential improvement. Your manager has asked you to focus specifically on sales data at this point. This includes data related to sales orders, products, and customers. Q1. Q2. Q3. Given that you are new and trying to get a grasp on Slinte's operations, list three questions related to sales that would help you begin your analysis. For example, how many products were sold in each state? Now hypothesize the answers to each of the questions. Remember, your answers don't have to be correct at this point. They will help you understand what type of data you are looking for. For example: 500 in Missouri, 6,000 in Pennsylvania, 4,000 in New York, etc. 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. LAB EXHIBIT 2-1A FGI_Product Product Code: PK Product Description Product_Sale_Price 1..1 Sales_Subset Sales_Order_ID:PK Sales_Order_Date Sales_Employee_ID:FK 0..* Customer_ID:FK Product Code:FK Sales Order Quantity Sold Customer_Table 1..1 Customer_ID:PK Business_Name 0..* Customer Address Customer_City Customer_St

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: James A. Hall

8th edition

2901111972140, 1111972141, 978-1111972141

More Books

Students also viewed these Accounting questions