Lab2-1 Part 3 (see link for part 2)

https://www.chegg.com/homework-help/questions-and-answers/lab-2-1-part-2-see-link-part-1-https-wwwcheggcom-homework-help-questions-answers-lab-2-1-p-q84513477

After a few days, Rachel, an IT worker, responds to your request. She gives you the following tables and attributes:

LAB EXHIBIT 2-1B

Table Summary: Two tables appear. In each table, row 1 is a header row and spans all columns.

Sales_Subset Table Attribute Description of Attribute Sales_Order_ID (PK) Unique identifier for each sales order Sales_Order_Date The date of the sales order, regardless of the date the order is entered Sales_Employee_ID (FK) Unique identifier (from Employee_Listing table) for person who created the record Sales_Order_Quantity_Sold Sales order line quantity Product_Sale_Price Sales order line price per unit

Table Summary: Summary

FGI_Product Table Attribute Description of Attribute Product_Code (PK) Unique identifier for each product Product_Description Product description (plain English) to indicate the name or other identifying characteristics of the product Product_Sale_Price Price per unit of the associated product

You may notice that while there are a few attributes that may be useful in your sales analysis, the list may be incomplete and be missing several values. This is normal with data requests.

1. Q4.Take a moment and identify any attributes that you are missing from your original request that would be necessary to answer the question How many products were sold in each state?

2. Q5.Evaluate your original questions and responses. Can you still answer the original questions that you identified in step 1?

3. Q6.Is there another question you could answer from the data Rachel provided?