Week 8 (July 5 – July 11)

Tuesday, July 6 (6:00 P.M. – 8:00 P.M., Zoom) Class Session 8
Topics	Review Chapter 11 exercise solutions 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, July 11 (9:00 A.M. – 10:00 A.M., Zoom) Optional Session
Lab Session	On Sunday mornings from 9:00 AM till 10:00 AM, I will be holding an Lab Session using Zoom. 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.

Sunday, July 11, @ 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 conceptual 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, July 11, @ 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 conceptual 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 – Summer 2021

IS455 - AOG/AOU - Database Design and Prototyping

Meets Tuesday Evenings Online

Week 8 (July 5 – July 11)