Question: Create a database file named Vaccinations.db and import the given dataset into your database. To complete this task, you may need to change the format

Create a database file named Vaccinations.db and import the given dataset into your database.
To complete this task, you may need to change the format of the CSV files to match the attributes of your
designed database. You can use a spreadsheet editor such as Microsoft Excel.
The next step is to import the spreadsheets into the database you create in SQLite Studio. To complete this task,
use the menu option Tools Import in SQLite FILE NAME DESCRIPTION
1 locations.csv Country names and the type of vaccines administered. Each line
represents the last observation in a specific country. Refer to
README.md for the details.
2 us_state_vaccinations.csv History of observations for various locations in the US.
3 vaccinations-by-age-group.csv History of observations for vaccinations of various age groups in each
country.
4 vaccinations-by-manufacturer.csv History of observations for various types of vaccines used in each
country.
5 vaccinations.csv Country-by-country data on global COVID-19 vaccinations. Each line
represents an observation date. Refer to README.md for the details.
6 country_data/Wales.csv Daily observations of vaccination in Wales.
7 country_data/Canada.csv Daily observations of vaccination in Canada.
8 country_data/United States.csv Daily observations of vaccination in the US.
9 country_data/ Denmark.csv Daily observations of vaccination in Denmark.
Table 1: List of data files

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!