Week 6 (June 21 – June 27)

Tuesday, June 22 (6:00 P.M. – 8:00 P.M., Zoom) Class Session 6
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 27 (9:00 A.M. – 10:00 A.M., Zoom) Optional Session
Lab Session	On Sunday mornings from 9:00 AM till 10:00 AM, I will be holding an 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 27, @ 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 Instructions for 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 Instructions for 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 27, @ 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
- Instructions for 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 2021