Create a Database with Tables

For this assignment, you'll be creating a simple database with two tables from Python

Directions:

After importing the data integration module create a database called weather_tracking

In the database, create another table called Location

The table should have the columns county (primary key)(text), state (text)

In the database, create a table called Precipitation

The table should have the columns: location (foreign key to county in Location table), date (text), precipitation (float), precip_type(text)

Output the database information in the console with your program (table names and column names)

We'll be using this database in the next two assignment.

Submit your working code for grading.

This assignment is worth 10 points