Week 15 (April 24 – April 30)

Tuesday, April 26   (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, April 26   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate) Class Session 14
Topics	Review Conceptual Database Design Assignment Logical Database Design Using Normalization
Required Readings	Oppel: Chapter 6
Other Resources	Logical Database Design Process
Written Assignments Due	Conceptual Database Design Practice Description: Create a non-trivial conceptual data model from a list of requirements. Submit to: Conceptual Database Design Practice Instructions for Conceptual Database Design 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 Kevin's solution to conceptual data modeling exercise