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

It looks like some are still having issues setting up the database for this assignment. This is an alternative method for setting up the database. 

First download this file Download download this file

. Then, do the following:

1. If you have an existing shema called loganriverodm, right click and drop it
2. Create a new schema in MySQL called loganriverodm - make sure to use UTF8 - Unicode_CI
3. Choose File, then "Open SQL Script" and 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;