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 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.

The expected outcome of completing this task is one database file named Vaccinations.db$,$ which must contain

all the data that is stored in the CSV files named in Table $1.$ Can you show how to create an csv file and how to enter the data in it