Week 16 (December 10 – December 16)

Monday, December 11   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate) 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 Office Hours will be held on Thursday, December 14 due to Reading Day.

Saturday, December 16, @  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 Annotated Final Project Instructions This is the version that I display during the Final Project Workflow tutorial video (below). Tutorial Video: Final Project Workflow Reviews the instructions for the Final Project. Gives tips regarding the workflow, especially warnings about where your workflow can go wrong. Provides guidance on creating script to load table test data and on running that script properly. Provides tips on final checks to make to your project work before submitting it. Please note that this video was recorded for a different course during the Summer 2017 semester. Nevertheless, the content is still current. Test Data for 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