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)
);

In the context of it jobs in the information systems field. a is responsible for database design and implementation

Write a function balancechemical to balance chemical reactions by solving a linear set of equations. the inputs arguments are: reagents: symbols of reagents in string row array products: symbols of products in string row array elements: elements in the reaction in string row array elcmpreag: elemental composition of reactants in two dimensional numeric array elcmpprdcts: elemental composition of prducts in two dimensional numeric array hint: the first part of the problem is setting up the set of linear equations that should be solve. the second part of the problem is to find the integers from the solution. one way to do this is to mulitiply the rational basis for the nullspace by increasing larger integers until both the left-and right-side integers exist. for example, for the reaction that involves reacting with to produce and : reagents=["ch4", "o2"]; products =["co2", "h2o"]; elements =["c","h", "o"] elcmpreag=[1,4,0;

Write a method that takes in an array of point2d objects, and then analyzes the dataset to find points that are close together. be sure to review the point2d api. in your method, if the distance between any pair of points is less than 10, display the distance and the (x,y)s of each point. for example, "the distance between (3,5) and (8,9) is 6.40312." the complete api for the point2d adt may be viewed at ~pf/sedgewick-wayne/algs4/documentation/point2d.html (links to an external site.)links to an external site.. try to write your program directly from the api - do not review the adt's source code.