Week 10 (March 28 – April 3)

Monday, March 28   (11:00 A.M. – 12:15 P.M., NWQD-1990) Class Session 17
Topics	Review solution to Skills Practice - Conceptual ERD
Written Assignments Due	Skills Practice - Conceptual ERD Description: Create a conceptual data model (ERD) for the iSchool Webstore case. Submit to: Skills Practice - Conceptual ERD Instructions for Skills Practice - Conceptual ERD 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) Kevin's solution to Skills Practice - Use Case Diagrams (use this as a guide to the scope required for this data model) Grading rubric for Skills Practice - Conceptual ERD Kevin's solution to Skills Practice - Conceptual ERD

Wednesday, March 30   (11:00 A.M. – 12:15 P.M., NWQD-1990) Class Session 18
Topics	Physical Data Modeling State Machine Diagrams Designing Databases
Required Readings	Visual Paradigm (n.d.). State Machine Diagram Example Hoffer: Chapter 9
Other Resources	Sample state machine diagram Sample conceptual ERD ready for physical modeling Hoffer Chapter 9 Slides

Thursday, March 31   (3:00 P.M. – 5:00 P.M., NWQB-3472) Optional Session
Office Hours	Every Thursday afternoon, I will be holding Office Hours in my UWM office. Please feel free to drop by to ask a question, to discuss a problem, or just to say hello.