The star schema of a data warehouse for sales is given below: time time_key day day_of_the_week...

  

Transcribed Image Text:

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) 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)

Answer rating: 100% (QA)

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... View the full answer