In this hands-on lab scenario, you are a data engineer for Awesome Company. In the past, you have set up a system whereby users can upload crowdsourced weather information. Now your data analysis team has requested a star schema be designed for evaluating this information. Performing the actions of this hands-on lab will help you become familiar with designing fact and dimension tables for data analysis.
Successfully complete this lab by achieving the following learning objectives:
- Create a Fact Table
- Create a fact table to hold all weather event updates.
- Create Dimension Tables
- Create dimension tables for upload dates, locations, and users.
- Create Table Constraints
- Create constraints between the fact table and dimension tables in order to create the desired star schema structure.