Weekly Course Schedule – Summer 2018

IS 490 - DBO (Meets Thursday Evenings Online)

Week 10 (July 15 – July 21)



Tuesday, July 17   (6:30 P.M. – 7:30 P.M., Our normal Blackboard Collaborate Ultra classroom)
Optional Session
Online Lab Session
Every Tuesday evening, 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.


Thursday, July 19   (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra)
Class Session 10
Topics
  • Review Conceptual Database Design Assignment
  • Logical Database Design Using Normalization
Computing Setup
  • Install Visio 2016 (Our data modeling tool for Windows users)
    Description: If you are using a Windows computer, follow the directions demonstrated in the tutorial video below to install Visio 2016 on your machine. A FREE COPY is available to all iSchool students via the Illinois Webstore (https://webstore.illinois.edu). Download the product entitled "Microsoft Imagine Program: Visio Professional 2016 License and Download". If you have difficulty locating this free version, please contact the iSchool Help Desk.(
  • OR, Prepare to Use MySQL Workbench Diagrammer (Our data modeling tool for macOS and Linux users)
    Description: For the limited amount of data modeling that we do in our class, I have found that the best alternative for non-Windows users is to use the MySQL Workbench Diagrammer in an adaptive way. Please play the video tutorial below for an example of how to adapt this diagrammer for the purpose of our data modeling assignments. I typically discourage students from using some other diagrammer for our data modeling work. If you are convinced that you have a compelling case for using a different diagrammer, please seek permission using our Request Center Portal before using a different diagrammer.
Required Readings
  • Oppel: Chapter 6
Other Resources
Written Assignments Due