Build data with the combined data sources we will be able to view each state’s laws regarding recreational use and each state’s legal classification.
Perform ETL on the data. Make sure to plan and document the following:
- The sources of data that you will extract from.
- The type of transformation needed for this data (cleaning, joining, filtering, aggregating, etc).
- The type of final production database to load the data into (relational or non-relational).
- The final tables or collections that will be used in the production database.
You will be required to submit a final technical report with the above information and steps required to reproduce your ETL process.
You should include an ERD showing your final database table structures and relationships (having relationships between tables is optional but may make sense for your data analysis).
To make ERD, use tool: http://www.quickdatabasediagrams.com.