Week 11 (April 4 – April 10)

Thursday, April 7   (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.

Thursday, April 7   (5:30 P.M. – 8:10 P.M., NWQD-1990) Class Session 10
Topics	Review solution to Skills Practice - State Machine Diagram Review solution to Skills Practice - Physical ERD Non-Functional Requirements
Required Readings	Wikipedia (n.d.). Non-functional requirement
Other Resources	Slides for Non-Functional Requirements Lecture MS Word template file for developing non-functional requirements Sample Non-Functional Requirements for Student Attendance System Common Non-Functional Requirements Errors
Written Assignments Due	Skills Practice - State Machine Diagram Description: Create a state machine diagram for an important entity within the data model for the iSchool Webstore case. Submit to: Skills Practice - State Machine Diagram Instructions for Skills Practice - State Machine Diagram Demo Video – Create a State Machine Diagram With Visio (Captioned Version) Common State Machine Diagram Errors Grading rubric for Skills Practice - State Machine Diagram Kevin's solution to Skills Practice - State Machine Diagram Skills Practice - Physical ERD Description: Create a physical data model (ERD) for the iSchool Webstore case. Submit to: Skills Practice - Physical ERD Instructions for Skills Practice - Physical ERD Tutorial Video – Physical Data Model - Part 1 (Correct conceptual data model) Tutorial Video – Physical Data Model - Part 2 (Create associative entities for many-to-many relationships) Tutorial Video – Physical Data Model - Part 3 (Give each attribute a data type) Tutorial Video – Physical Data Model - Part 4 (Remove repeating data from entity types) Tutorial Video – Physical Data Model - Part 5 (Make further changes for normalization) Tutorial Video – Physical Data Model - Part 6 (Add foreign keys to implement relationships) Common Errors in Creating Physical ERDs Grading rubric for Skills Practice - Physical ERD Kevin's solution to Skills Practice - Physical ERD