We will use Covid 19 Data from https://github.com/CSSEGISandData/COVID-19, Links to an external site.

Part 1: See 3 attached files, 01-19-2021.csv, Download 01-19-2021.csv,01-19-2022.csv and Download 01-19-2022.csv and 01-19-2023.csv Download 01-19-2023.csv and design a relational database that can store all three files worth of data in a new table structure and import your data into that structure.

1. Draw an ERD for the database. 2. Using the database design language to list all the tables, relationships, and attributes, including primary and foreign key constraints. 3. Explain your design rationales.

4. Write a query to return data on the state, update date, the case incidence rate, and case fatality ratio. Group by each state and filter to the following states Indiana, Illinois, Michigan, & Ohio

Part 2:

Attached is what is known as a time series data source. (Note all the date specific columns, you do not need to import these files to successfully complete this assignment)

time_series_covid19_deaths_US.csvDownload time_series_covid19_deaths_US.csv

Part 2.a

Please re-design so that you wind up the following columns in your table and no more than 5 additional columns to link to other tables. Please show your entity relationship diagram for each of your tables and how you will store your data so that no information is lost from the original time series dataset.

UID

iso2

iso3

code3

FIPS

Admin2

Province_State

Country_Region

Lat

Long_

Combined_Key

Population

Part 2.b Link the following file into your new schema and show how it is related to what you built in 2.a

Global_data_Covid.csv Download Global_data_Covid.csv