Week 6 (June 22 – June 28)

Tuesday, June 23 (6:30 P.M. – 9:00 P.M., Zoom) Class Session 6
Session Link	You may join the session using this link. Use 695367 as the session password. Please use a headset.
Topics	Review Chapter 7 exercise solutions Review Chapter 8 exercise solutions How to use functions How to design a database
Required Readings	Murach 3e Chapter 9 Murach 3e Chapter 10
Required Recordings	Lecture Video - Murach 3e Chapter 9 - Part 1 Lecture Video - Murach 3e Chapter 9 - Part 2 Lecture Video - Murach 3e Chapter 10
Other Resources	Murach 3e Chapter 9 Slides Murach 3e Chapter 10 Slides

Sunday, June 28 (10:00 A.M. – 11:00 A.M., Zoom) Optional Session
Session Link	You may join the session using this link. Use 448723 as the session password. Please use a headset.
Online Lab	On Sunday mornings from 10:00 AM till 11:00 AM, I will be holding an optional Online Lab Session using Zoom. Please drop by to ask a question, to discuss solutions to previous assignments, to get help with the current assignment, to discuss the final project, or just to say hello.

Sunday, June 28, @ 11:55 P.M. Weekly Assignments Deadline
Coding Assignments Due	Chapter 9 My Guitar Shop Exercises Description: Exercises 1 - 4 PLEASE NOTE: Exercises 5 through 7 are based on features that are new to MySQL and material that is new to the Murach 3e text. So, these exercises are being offered here for a “test drive”. While we will review both student and official solutions to these exercises in class, these exercises will not be counted toward your grade for this assignment. Submit to: Chapter 9 My Guitar Shop Exercises Exercises Grading rubric for MGS Chapter 9 Exercises Chapter 10 My Guitar Shop Exercises Description: Exercises 1 - 3 Submit to: Chapter 10 My Guitar Shop Exercises Exercises Tutorial: Diagramming Many-to-Many Relationships Tutorial Video: Resolving problems with MySQL Workbench that affect Exercise 10-3. Grading rubric for MGS Chapter 10 Exercises

Sunday, June 28, @ 11:55 P.M.
Weekly Assignments Deadline

Coding Assignments Due

Chapter 9 My Guitar Shop Exercises
Description: Exercises 1 - 4 PLEASE NOTE: Exercises 5 through 7 are based on features that are new to MySQL and material that is new to the Murach 3e text. So, these exercises are being offered here for a “test drive”. While we will review both student and official solutions to these exercises in class, these exercises will not be counted toward your grade for this assignment.
Submit to: Chapter 9 My Guitar Shop Exercises
- Exercises
- Grading rubric for MGS Chapter 9 Exercises
Chapter 10 My Guitar Shop Exercises
Description: Exercises 1 - 3
Submit to: Chapter 10 My Guitar Shop Exercises

Weekly Course Schedule – Summer 2020