Week 16 (December 9 – December 15)

Monday, December 10   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 14
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

Schedule Note
No Online Lab Session will be held on Thursday, December 13, due to Reading Day.

Saturday, December 15, @  11:55 P.M. Additional Deadline
Coding Assignments Due	Final Project Description: Develop a small database project from start to finish. Submit to: Final Project Final Project Instructions Starter files for final project Tutorial Video: Tips on Completing the Final Project Tutorial Video: How to Read a Grading Rubric for a Final Assignment Grading Rubric for Final Project Tutorial Video: How to Read a Grading Feedback Form for a Final Assignment