Week 15 (December 2 – December 8)

Monday, December 3 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 13
Topics	Review Conceptual Database Design Assignment Logical Database Design Using Normalization
Required Readings	Oppel: Chapter 6
Other Resources	Logical Database Design Process Oppel Chapter 6 Slides
Written Assignments Due	Conceptual Data Modeling Practice Description: Create a non-trivial conceptual data model from a list of requirements. Submit to: Conceptual Data Modeling Practice Instructions for Conceptual Data Modeling Practice iSchool Webstore Case Description Tutorial Video – Conceptual Data Modeling - Part 1 (Ragbag Exercise) Tutorial Video – Conceptual Data Modeling - Part 2 (Entities and Relationships) Tutorial Video – Conceptual Data Modeling - Part 3 (Attributes and Identifiers) Visio starter file for conceptual data modeling exercise Grading rubric for Conceptual Data Modeling Practice

Thursday, December 6 (6:30 P.M. – 7:30 P.M., Our normal Blackboard Collaborate Ultra classroom) Optional Session
Online Lab Session	On Thursday evenings, 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.

Weekly Course Schedule – Fall 2018