Project: Public Data Queries¶
In the final project for the class you will build a schema using the public dataset you picked in the Using Public Data project and write queries to show interesting things.
Import Your Dataset¶
Most of the data that is available is given in spreadsheet form. Import your data into MySQL using the table data import wizard. Use the process you learned in the Working with Real Data and the Keys in Real Data labs to build your schema in SQL.
Remember, your schema should meet the criteria:
You must have at least three tables
You must have at least two foreign key constraints
Write two queries that show something interesting in your data. For each query also write a description of what the query shows and why you did it.
Export Your Data¶
You can use either MySQL or Jupyter notebook. If you use MySQL export your data as an SQL dump file. If you use Jupyter export the sqlite file.
The SQL dump of your data.
A document with your queries and descriptions.