Week 11 (July 22 – July 28)

Tuesday, July 24 (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.

Thursday, July 26 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 11
Topics	Review Logical Database Design Assignment Physical Database Design
Required Readings	Oppel: Chapter 8
Other Resources	Slides for Oppel Chapter 8
Written Assignments Due	Logical Database Design Practice Description: Create a non-trivial logical data model based upon the previously-created conceptual data model and other requirements. Submit to: Logical Database Design Practice Instructions for Logical Database Design Practice Tutorial Video – Logical Database Design - Part 1 (Introduction) Tutorial Video – Logical Database Design - Part 2 (Convert attributes into columns) Tutorial Video – Logical Database Design - Part 3 (Remove redundant columns and relationships) Tutorial Video – Logical Database Design - Part 4 (Eliminate repeating columns) Tutorial Video – Logical Database Design - Part 5 (Relocate misplaced columns) Tutorial Video – Logical Database Design - Part 6 (Replace free-form text fields) Tutorial Video – Logical Database Design - Part 7 (Resolve many-to-many-relationships) Tutorial Video – Logical Database Design - Part 8 (Add foreign keys) Grading rubric for Logical Database Design Practice

Weekly Course Schedule – Summer 2018