Week 12 (November 11 – November 17)

Tuesday, November 12 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 12
Topics	Review Chapter 12 exercise solutions Conceptual Data Modeling
Required Readings	Oppel: Chapter 5
Other Resources	Oppel Chapter 5 Slides Sample Use Case Diagram for Student Attendance System Terms from Ragbag Exercise for Student Attendance System Sample Conceptual Data Model for Student Attendance System

Sunday, November 17 (10:00 A.M. – 11:00 A.M., Blackboard Collaborate Ultra) Optional Session
Online Lab Session	On Sunday mornings from 10:00 AM till 11:00 AM, I will be holding an optional Online Lab Session in our normal Blackboard Collaborate Ultra classroom. Please drop by to ask a question, to discuss solutions to previous assignments, to get help with the current assignment, to discuss the final project, or just to say hello. Please use a headset when joining this session.

Sunday, November 17, @ 11:55 P.M. Weekly Assignments Deadline
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 Microsoft's Azure Dev Tools for Teaching Web site. I have provided a link below for your use. If you have difficulty accessing this free version, please contact the iSchool Help Desk. Or, stop by our Online Lab Session on Sunday morning. Azure Dev Tools for Teaching Tutorial Video: Install Visio 2016 on Windows 10 While this is a fairly old tuturial, it should still be sufficient to help you install this fairly old product. If you have problems, please stop by our Online Lab Session on Sunday morning. 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. Tutorial Video: Adapt MySQL Workbench Diagrammer for Data Modeling Assignments
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) Starter file for conceptual data modeling exercise (PDF version) Starter file for conceptual data modeling exercise (VSDX version) Grading rubric for Conceptual Data Modeling Practice

Sunday, November 17, @ 11:55 P.M.
Weekly Assignments Deadline

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 Microsoft's Azure Dev Tools for Teaching Web site. I have provided a link below for your use. If you have difficulty accessing this free version, please contact the iSchool Help Desk. Or, stop by our Online Lab Session on Sunday morning.
- Azure Dev Tools for Teaching
- Tutorial Video: Install Visio 2016 on Windows 10 While this is a fairly old tuturial, it should still be sufficient to help you install this fairly old product. If you have problems, please stop by our Online Lab Session on Sunday morning.
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.
- Tutorial Video: Adapt MySQL Workbench Diagrammer for Data Modeling Assignments

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

Weekly Course Schedule – Fall 2019

IS 455 - AO (Meets Tuesday Evenings Online)

Week 12 (November 11 – November 17)