Week 15 (April 23 – April 29)

Tuesday, April 25 (6:30 P.M. – 7:30 P.M., Blackboard Collaborate) Optional Session
Online Office Hours	Every Tuesday 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, April 26 (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 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 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

Weekly Course Schedule – Spring 2017