Week 1 (May 13 – May 19)

Wednesday, May 15 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 1
Topics	Introductions Review syllabus Introduction to Data Modeling Relational Model Components Installing the MySQL software
Required Readings	Course Syllabus Oppel: Chapter 1 Oppel Chapter 2
Required Recordings	Tutorial Video: Tips on Playing My YouTube Videos
Other Resources	Oppel Chapter 1 Slides Oppel Chapter 2 Slides
Class Discussion Prep	Introduce Yourself Our first activity during class will be introducing ourselves. I plan to go through the class in alphabetical order and ask each of you to speak to us using your headset. I am expecting each person to speak for 1 - 2 minutes. Here are the things that I would like you to share with us: Your name; The iSchool program in which you are enrolled; Your employment (this includes, full-time, part-time, university, and home care activities); Your previous experience with databases (especially relational databases); Most Important: What you would like to get out of this course. I look forward to meeting each of you during your introductions.

Sunday, May 19 (10:00 A.M. – 11:00 A.M., Blackboard Collaborate Ultra) Optional Session
Online Lab Session	On Sunday mornings from 10:00 AM till 11:00 AM, I will be holding an optional Online Lab Session in our normal Blackboard Collaborate Ultra classroom. 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. Please use a headset when joining this session.

Sunday, May 19, @ 11:55 P.M. Weekly Assignments Deadline
Computing Setup	Install MySQL Server Community Edition and MySQL Workbench Description: Please follow the appropriate tutorial video below to install MySQL Server Community Edition and MySQL Workbench on your computer. Tutorial Video: Install MySQL on Windows 10 Tutorial Video: Install MySQL on macOS Load Murach 2e Data Description: Please follow the appropriate tutorial video below to load the files associated with the Murach 2e text book on your computer and to generate the databases that we will be using during the course. Tutorial Video: Load Murach 2e Data on Windows 10 Tutorial Video: Load Murach 2e Data on macOS Murach 2e files AP Database EERD My Guitar Shop Database EERD

Sunday, May 19, @ 11:55 P.M.
Weekly Assignments Deadline

Computing Setup

Install MySQL Server Community Edition and MySQL Workbench
Description: Please follow the appropriate tutorial video below to install MySQL Server Community Edition and MySQL Workbench on your computer.
- Tutorial Video: Install MySQL on Windows 10
- Tutorial Video: Install MySQL on macOS
Load Murach 2e Data
Description: Please follow the appropriate tutorial video below to load the files associated with the Murach 2e text book on your computer and to generate the databases that we will be using during the course.

Weekly Course Schedule – Summer 2019