Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The star schema of a data warehouse for sales is given below: time time_key day day_of_the_week month quarter year branch branch_key branch_name branch_type Star
The star schema of a data warehouse for sales is given below: time time_key day day_of_the_week month quarter year branch branch_key branch_name branch_type Star Schema Sales Fact Table time_key item_key branch_key location_key dollars_sold unit_sold item item_key item_name brand type supplier_type location location_key street city province_or_street country Star schema of a data warehouse for sales. Answer the following question: I To Do: 1. Which are the dimension tables? (4 points) 2. Identify the Primary Keys in the dimension tables (3 points) 3. Which is the fact table? (3 points) 4. Identify the Composite PK and the Foreign keys in the fact table (5 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Based on the provided star schema of a data warehouse for sales lets address each of the questions 1 Which are the dimension tables In a star schema d...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