Question: Star Schema Based on the Sales table given in the previous, answer the following questions: Sales Person Sandy Ally Sandy William William Sandy Ally William

Star Schema Based on the Sales table given in the previous, answer the following questions: Sales Person Sandy Ally Sandy William William Sandy Ally William Joshua Joshua Product T-Shirt Raincoat T-Shirt Pants Pants Pants Raincoat Raincoat T-Shirt Pants Size L M L XL L Sales_Quantity 100 20 50 15 Colour Red Red Yellow Beige Black Black Pink 40 L 50 L 60 S 50 L Green Blue Grey 35 M 150 1 What makes Sales a fact table? Explain your answer. 2 What are the dimensions of Sales? 3 Draw ERD of the star schema for Sales fact table and its associated dimension tables. 4. Implement the ERD and insert the sample data. 5. Modify the SQL queries in the previous lab, Q2 to Q5 and run them on the star schema for Sales. Show the results of each query
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
