Week 1 (August 23 – August 29)

Tuesday, August 24 (6:00 P.M. – 8:00 P.M., Zoom) Class Session 1
Topics	Course Startup Review syllabus Review schedule Introductions Introduction to Data Modeling (Oppel Chapter 1) Relational Model Components (Oppel Chapter 2)
Required Readings	Course Syllabus Oppel: Chapter 1 Oppel Chapter 2
Required Recordings	Tutorial Video: Tips on Playing My YouTube Videos Lecture Video: Syllabus Review and Course Introduction
Other Resources	EZU Web Application Demo Site. Login credentials: fall2021/ephemeral ERD for EZU Logical Database Design 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 the order that participants are listed in our online session. I will 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, August 29 (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 optional 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. Please use a headset while participating.

Sunday, August 29, @ 11:55 P.M. Weekly Assignments Deadline
Computing Setup	Send a Greetings post to the Service Desk for this course Description: You can earn 10 participation points by sending a Greetings post to the Service Desk for this course within the first 2 weeks of the semester. Regardless of the points earned, getting started using the Service Desk is a best practice. Tutorial Video: How to Use the Service Desk for This Course Slides for How to Use the Service Desk for This Course Link to the Service Desk for this course Choose Your Computer Description: I recommend that you use a computer that runs Windows 10 or a recent release of macOS. While the software that we will be using for this course does run on Linux, there will be substantially less technical support available for Linux. If you are considering using a Linux computer, please consult with me beforehand. 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 3e Data Description: Please follow the appropriate tutorial video below to load the files associated with the Murach 3e text book on your computer and to generate the databases that we will be using during the course. Tutorial Video: Load Murach 3e Data on Windows 10 Tutorial Video: Load Murach 3e Data on macOS Murach 3e files AP Database EERD My Guitar Shop Database EERD

Sunday, August 29, @ 11:55 P.M.
Weekly Assignments Deadline

Computing Setup

Send a Greetings post to the Service Desk for this course
Description: You can earn 10 participation points by sending a Greetings post to the Service Desk for this course within the first 2 weeks of the semester. Regardless of the points earned, getting started using the Service Desk is a best practice.
Choose Your Computer
Description: I recommend that you use a computer that runs Windows 10 or a recent release of macOS. While the software that we will be using for this course does run on Linux, there will be substantially less technical support available for Linux. If you are considering using a Linux computer, please consult with me beforehand.
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 3e Data
Description: Please follow the appropriate tutorial video below to load the files associated with the Murach 3e text book on your computer and to generate the databases that we will be using during the course.

Weekly Course Schedule – Fall 2021

IS455 - AO - Database Design and Prototyping

Meets Tuesday Evenings Online

Week 1 (August 23 – August 29)