Week 16 (May 1 – May 7)

Tuesday, May 3   (3:00 P.M. – 5:00 P.M., Blackboard Collaborate) Optional Session
Online Office Hours	Every Tuesday afternoon, I will be holding Online Office Hours using the Blackboard Collaborate platform. You are invited to join us to discuss questions and issues concerning the class. Meet in the Drop In Room of the Blackboard Collaborate platform. Join the Kevin Trainor Office Hours breakout room. Please use a headset.

Tuesday, May 3   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate) Class Session 15
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) Kevin's solution to logical database design practice exercise