4. Using Structured Query Language

A PDF version of this assignment is available here Download here

.

An editable Microsoft Word version of the grading rubric is available here Download here

. Please submit an electronic copy of the rubric with the self assessment column filled out in Canvas. Please also submit a printed copy with your assignment before class begins for grading purposes.

Required data for this assignment are available here Download here.

Instructions for setting up your MySQL ODM database for this assignment are available here Download here

.

Alternative Database Setup Method

Please try the above procedure before you use this alternative. If you try the above procedure and let the MySQL LOAD DATA LOCAL INFILE task that loads the data values run for a couple of hours and it still hasn't loaded your data, your computer may not be up to the task. Use the following procedure instead.

1. Download this SQL script file Download this SQL script file
   .
2. If you have an existing schema called "loganriverodm", right click on it and drop it
3. Choose File, then "Open SQL Script" and the open the script you just downloaded. 
4. Run the script.

This new script will populate the database with all of the tables and load data. It only loads the temperature values you need for the assignment.  If you run the following query when you are done, you should have 144466 data values in your database.

SELECT COUNT(*) FROM DataValues;