Week 15 (November 27 – December 3)

Monday, November 28 (6:30 P.M. – 8:30 P.M., Blackboard Collaborate) Optional Session
Online Office Hours	Every Monday evening, 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.

Wednesday, November 30 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate) Class Session 14
Topics	Review Conceptual Data Modeling Assignment Logical Database Design Using Normalization
Computing Setup	Install Visio 2016 Description: The preferred tool for doing the next 2 assignments is Visio 2016. You can download a free copy from the Illinois Webstore. Make sure you sign in to see your free download deal. If you cannot use Visio (ie. if you have a Mac), my best recommedation is to try using the MySQL Workbench Diagrammer. If you do, you will have to adapt the assignment to the features of that tool. Tutorial Video: Install Visio 2016 on Windows 10
Required Readings	Oppel: Chapter 6
Other Resources	Logical Database Design Process
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 Use case diagram for limited scope version of iSchool Webstore case Case Description for Conceptual Data Modeling Practice 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: Resource is available on Moodle.

Weekly Course Schedule – Fall 2016