Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started