X402.5 Lecture Files (PDF Format, Handouts with 3 Slides Per Page)
Class 01: Introduction to Data Modeling
Class 01: Relational Database Components
Class 01: Normalization Exercise 1
Class 01: Normalization Exercise 1 Solution #1
Class 01: Normalization Exercise 1 Solution #2
Class 01: Normalization Exercise 2
Class 01: Normalization Exercise 2 Solution
Class 02: Alternatives to ER Modeling
Class 02: Entity Relationship Modeling
Class 02: Supertypes and Subtypes
Class 02: Exercise in Supertypes and Subtypes
Class 02: Instructor's Solution to Exercise in Supertypes and Subtypes
Class 03: Organizing Database Projects
Class 03: Conceptual Data Modeling
Class 03: Exercise on Conceptual Modeling
Class 03: Instructor's Solution to Exercise on Conceptual Modeling without Attributes
Class 03: Instructor's Solution to Exercise on Conceptual Modeling with Attributes
Class 04: Attributes, Primary Keys, and Normalization
Class 04: Exercise in Normalization 1
Class 04: Exercise in Normalization 2
Class 04: Solution to Exercise in Normalization 1 and 2
Class 05: Advanced Normalization
Class 05: Exercise in Advanced Normalization
Class 05: Solution to Exercise in Advanced Normalization
Class 06: Physical Database Design
Class 06: Exercise on Modeling the UB04 Claim Form
Class 06: Solution to Exercise on Modeling the UB04 Claim Form
Class 07: Modeling Business Rules
Class 07: Exercise in Modeling Business Rules
Class 07: Solution to Exercise in Modeling Business Rules
Class 08 Exercise and solution coming soonClass 09: Modeling for Analytical Databases
Class 09: Enterprise Data Modeling
Class 09 Exercise and solution coming soon