Week 3 (February 3 – February 9)

Tuesday, February 4 (12:30 P.M. – 2:30 P.M., Zoom) Class Session 3
Topics	Conceptual Data Modeling
In-Class Activities	Review Computing Vincent Blog Experience From Prior Week Form Semester-Long Breakout Groups Breakout Group: Conceptual Data Model for NITE-LITE Trail Guide System
Required Readings	Oppel: Chapter 1 (Introduction to Data Modeling) Oppel: Chapter 2 (Relational Model Components) Oppel: Chapter 3 (Data and Process Modeling) Oppel: Chapter 5 (Conceptual Data Modeling)
Optional Readings	Oppel: Chapter 4 (Organizing Database Project Work)
Required Recordings	Lecture Video: Conceptual Data Modeling - Part 1 Lecture Video: Conceptual Data Modeling - Part 2 Lecture Video: Conceptual Data Modeling - Part 3
Prep For In‑Class Activities	Explore Prospects for Semester-Long Breakout Groups We will be using the break-out session to meet other students in the class and find prospects for forming semester-long breakout groups.

Friday, February 7 (3:00 P.M. – 4:00 P.M., Zoom) Optional Session
Lab Session	On Friday afternoons from 3:00 PM till 4:00 PM, I will be holding an optional 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. Please use a headset while participating.

Sunday, February 9, @ 11:55 P.M. Weekly Assignments Deadline
Written Assignments Due	Conceptual Data Modeling Assignment Description: You will be creating a conceptual data model Instructions for Conceptual Data Modeling Assignment Exercise 1 Requirements Video Exercise 2 Requirements Video Tutorial Video: Conceptual Data Modeling Part 1 - Ragbag Exercise PLEASE NOTE: This video was recorded for a previous course and a few details are out of date. Nevertheless, it does a good job of showing a ragbag exercise being conducted for the Student Attendance System. So, please excuse any of-of-date references. Starter file for ragbag exercise Tutorial Video: Conceptual Data Modeling Part 2 - Adding Entities Tutorial Video: Conceptual Data Modeling Part 3 - Adding Relationships Tutorial Video: Conceptual Data Modeling Part 4 - Adding Attributes and Identifiers Tutorial Video: Conceptual Data Modeling Part 5 - Evaluating the Model Grading Rubric for the Conceptual Data Modeling Assignment
Computing Setup	Choose Your In-Class Breakout Group Description: Use the Canvas Groups feature to choose your group for the in-class breakout sessions. Any students who have not chosen a breakout group by the deadline will randomly assigned to a group. If you have difficulty finding or using the Canvas Groups feature, please contact the iSchool Help Desk for assistance.

Sunday, February 9, @ 11:55 P.M.
Weekly Assignments Deadline

Written Assignments Due

Conceptual Data Modeling Assignment
Description: You will be creating a conceptual data model
- Instructions for Conceptual Data Modeling Assignment
- Exercise 1 Requirements Video
- Exercise 2 Requirements Video
- Tutorial Video: Conceptual Data Modeling Part 1 - Ragbag Exercise PLEASE NOTE: This video was recorded for a previous course and a few details are out of date. Nevertheless, it does a good job of showing a ragbag exercise being conducted for the Student Attendance System. So, please excuse any of-of-date references.
- Starter file for ragbag exercise
- Tutorial Video: Conceptual Data Modeling Part 2 - Adding Entities
- Tutorial Video: Conceptual Data Modeling Part 3 - Adding Relationships
- Tutorial Video: Conceptual Data Modeling Part 4 - Adding Attributes and Identifiers
- Tutorial Video: Conceptual Data Modeling Part 5 - Evaluating the Model
- Grading Rubric for the Conceptual Data Modeling Assignment

Computing Setup

Choose Your In-Class Breakout Group
Description: Use the Canvas Groups feature to choose your group for the in-class breakout sessions. Any students who have not chosen a breakout group by the deadline will randomly assigned to a group. If you have difficulty finding or using the Canvas Groups feature, please contact the iSchool Help Desk for assistance.

Weekly Course Schedule – Spring 2025