X402.5 Lecture Files (PDF Format, 1 Slide Per Page)


Class Meeting 1, Morning

Class 01: Introduction

Chapter 01: Introduction to Data Modeling

Chapter 02: Relational Model Components

Class 01: Normalization Preview

Class Normalization Exercise: Good News Grocers

Class Normalization Exercise: Good News Grocers Solution

Class Normalization Exercise: Good News Grocers Solution #1 (ERwin)


Class Meeting 1, Afternoon

Class Normalization Exercise: Art Gallery

Class Normalization: Art Gallery Solution

Class Normalization Exercise: Art Gallery Solution (ERwin)

Chapter 03: Data and Process Modeling

Class Exercise in Supertypes and Subtypes

Solution to Exercise in Supertypes and Subtypes

Solution to Exercise in Supertypes and Subtypes (ERwin)


Class Meeting 2, Morning

Chapter 04: Organizing Database Projects

Chapter 05: Conceptual Data Modeling

Class Exercise on Conceptual Modeling

Solution to Exercise on Conceptual Modeling without Attributes

Solution to Exercise on Conceptual Modeling with Attributes

Solution to Exercise on Conceptual Modeling (ERwin)


Class Meeting 2, Afternoon

Chapter 06: Logical Design Using Normalization

Class Exercise in Normalization (Animal Hospital)

Solution to Class Exercise in Normalization (Animal Hospital)

ERwin Model for Solution to Exercise in Normalization (Animal Hospital)

Chapter 07: Beyond Third Normal Form

Class Exercise in Advanced Normalization (Transit Schedule)


Class Meeting 3, Morning

Solution to Exercise in Advanced Normalization (Transit Schedule)

Solution to Exercise in Advanced Normalization ERwin (Transit Schedule)

Chapter 08: Physical Database Design


Class Meeting 3, Afternoon

Chapter 09: Alternatives for Incorporating Business Rules

Class Exercise in Modeling Business Rules

Solution to Exercise in Modeling Business Rules

ERwin Model for Solution to Exercise in Modeling Business Rules


Class Meeting 4, Morning

Chapter 10: Alternatives for Handling Temporal Data

Class Exercise in Modeling Time-Dependent Data

Class Exercise in Modeling Time-Dependent Data Solutions 1 (Effective-dated Tables) and 2 (History Tables

ERwin Models for Solutions 1 and 2 to Exercise in Modeling Time-Dependent Data


Class Meeting 4, Afternoon

Chapter 11: Modeling for Analytical Databases

Chapter 12: Enterprise Data Modeling

Class Exercise in Analytical Data Modeling

ERwin Model (3NF OLTP) for Exercise in Analytical Data Modeling

Class Exercise in Analytical Data Modeling Solution (Sale and Sale Discount Marts)

ERwin Model (Dimensional OLAP) for Solution to Exercise in Analytical Data Modeling




Return to X402.5 Home Page