UC Irvine Corn Futures and Weather Database Creation Schema Excel Sheet and Paper here are 3 fiels, the world file is requirment, the others are sample.Can

UC Irvine Corn Futures and Weather Database Creation Schema Excel Sheet and Paper here are 3 fiels, the world file is requirment, the others are sample.Can you send it to me 1 excel file with 2 tabs for those two requirenments Part 1:
Databases
Structured way of storing data
SQL –mySQL/SQL Server/PostgreSQL Access Excel
Tables/Columns • Unique Primary Keys • Can be linked with Foreign Keys
Structure is the Schema • Entity-Relationship Diagram (ERD)
Design a DB Schema
I want to set up a database schema for the DePaul masters program for Spring Term.
Include at least the following tables: • Classes • Students • Instructors • Rooms
At a minimum, each class should have a roster of students, which instructors are teaching and in what
rooms.
Deliverable is a set of tables with columns, data types and primary/foreign keys
Part 2:
Is there any relationship between corn futures and weather?
Corn May 2020 Future (ZCK0) Des Moines, Iowa –heart of the corn belt
Hypothesis: As temperature is colder than average, the price of corn futures goes up.
Data needs: Average daily temperature for Des Moines 2019 daily temperature for Des Moines Price of
the corn future for 2019
Create the dataset.
For the price of the future, go here: https://www.investing.com/commodities/us-corn-historical-data
For weather: https://www.weather.gov/dmx/cliplotnew
Align the dates in ascending order (oldest date at the top row)
Send me the data set
Column Name
Table Name
STUDENTS
ID
First Name
Last Name
Gender
Date of Birth
Data Type
Notes
Integer
Varchar
Varchar
Varchar
Datetime
Primary Key
Integer
Varchar
Varchar
Integer
Primary Key
Integer
Integer
Integer
Primary Key
Foreign Key linking to Student table
Foreign Key linking to Classes table
CLASSES
ID
Name
Time
Credit Hours
SPRING2020TERM
ID
Student_ID
Classes_ID
Date
Price of Corn Futures Avg Temp in Des Moines 2019 Temp in Des Moines
040620 Week 2 Lecture X
+
file:///C:/Users/boqia/Downloads/040620%20Week%202%20Lecture.pdf
21
of 29 0
+
Fit to page
ID Page view | A’ Read aloud
Schema Diagram
Albums
Albumld INT
AlbumName VARCHAR(255)
-KC Date Released DATETIME
Artistld INT
Genreld INT
Indexes
Genre
Artists
Genreld INT
Artistld INT
Genre VARCHAR(255)
Indexes
ArtistName VARCHAR(255)
Indexes

Purchase answer to see full
attachment