The data to be loaded in the database is provided to you in three CSV files. You will use thefollowing 3 files, located in D2L (location. csv, temperature. csv, and wind. csv),for this Assignment. Open each file and familiarize yourself with the data format. Thedata in these files is interpreted as follows: location. csv: station name, latitude, longitude
wind. csv: station name, year, month, wind speed
CREATE TABLE location(
stationname varchar(50),
latitude int,
Longitude int,
PRIMARY KEY(stationname));
CREATE TABLE wind(
stationname varchar(50) ,
year int,
month varchar(50),
Windspeed int,
PRIMARY KEY(year, month),
FOREIGN KEY (stationname));
CREATE TABLE temperature(
stationname varchar(50) ,
year int,
month varchar(50),
temperture int,
FOREIGN KEY (stationname) REFERENCES location(stationname)
FOREIGN KEY (year) REFERENCES wind(year)
FOREIGN KEY (month) REFERENCES wind(month)
);