Week 12 (July 29 – August 4)

Tuesday, July 31 (6:30 P.M. – 7:30 P.M., Our normal Blackboard Collaborate Ultra classroom) Optional Session
Online Lab Session	Every Tuesday evening, we will have an optional Online Lab Session using the Blackboard Collaborate Ultra platform. These sessions are a great opportunity to get help with your coding assignments or with your final project. Lab Sessions will take place in our normal Blackboard Collaborate Ultra classroom. Please use a headset.

Schedule Note
No class will be held on Thursday, August 2 due to Reading Day.

Thursday, August 2, @ 11:55 P.M. Additional Deadline
Coding Assignments Due	Final Project Description: Develop a small database project from start to finish. Submit to: Final Project NEWS FLASH: Yet Another Test Data Loading Script Now Available! Some students have reported the even the revised approach to test data loading scripts provided earlier in the semester will not run on their Windows 10 installation of MySQL. This script should work on all versions. It uses INSERT commands rather than LOAD commands. If your test data loading is already working, then don't worry about using this script. But, if you are stuck on test data loading, then this script is for you! Final Project Instructions Annotated Final Project Instructions This is the version that I display during the Final Project Workflow tutorial video (below). Tutorial Video: Final Project Workflow Reviews the instructions for the Final Project. Gives tips regarding the workflow, especially warnings about where your workflow can go wrong. Provides guidance on creating script to load table test data and on running that script properly. Provides tips on final checks to make to your project work before submitting it. PLEASE NOTE that this video was recorded for a different course during the Summer 2017 semester. Due to changes introduced in the latest version of MySQL Server (Version 8), there is one additional requirement that must be met by test data loading scripts. Please make sure that you play the Briefing Video below before trying to run your test data loading script. Briefing Video: Please Remember ONE NEW REQUIREMENT for Test Data Loading Scripts Test Data for Final Project Revised Sample Test Data Loading Script: This script loads test data into the my_guitar_shop database. Some students find it helpful as a model when creating their database load script for the Final Project. Tutorial Video: How to Read a Grading Rubric for a Final Assignment Grading Rubric for Final Project Tutorial Video: How to Read a Grading Feedback Form for a Final Assignment

Thursday, August 2, @ 11:55 P.M.
Additional Deadline

Coding Assignments Due

Final Project
Description: Develop a small database project from start to finish.
Submit to: Final Project
- NEWS FLASH: Yet Another Test Data Loading Script Now Available! Some students have reported the even the revised approach to test data loading scripts provided earlier in the semester will not run on their Windows 10 installation of MySQL. This script should work on all versions. It uses INSERT commands rather than LOAD commands. If your test data loading is already working, then don't worry about using this script. But, if you are stuck on test data loading, then this script is for you!
- Final Project Instructions
- Annotated Final Project Instructions This is the version that I display during the Final Project Workflow tutorial video (below).
- Tutorial Video: Final Project Workflow Reviews the instructions for the Final Project. Gives tips regarding the workflow, especially warnings about where your workflow can go wrong. Provides guidance on creating script to load table test data and on running that script properly. Provides tips on final checks to make to your project work before submitting it. PLEASE NOTE that this video was recorded for a different course during the Summer 2017 semester. Due to changes introduced in the latest version of MySQL Server (Version 8), there is one additional requirement that must be met by test data loading scripts. Please make sure that you play the Briefing Video below before trying to run your test data loading script.
- Briefing Video: Please Remember ONE NEW REQUIREMENT for Test Data Loading Scripts
- Test Data for Final Project
- Revised Sample Test Data Loading Script: This script loads test data into the my_guitar_shop database. Some students find it helpful as a model when creating their database load script for the Final Project.
- Tutorial Video: How to Read a Grading Rubric for a Final Assignment
- Grading Rubric for Final Project
- Tutorial Video: How to Read a Grading Feedback Form for a Final Assignment

Weekly Course Schedule – Summer 2018

IS 490 - DBO (Meets Thursday Evenings Online)

Week 12 (July 29 – August 4)