Introduction
- What is data modeling?
- Entity Relationship Model
- Notation - Information Engineering(IE) basic symbols
- Download and Install ERwin software
- ERwin workspace - Model, Subject Areas and Diagrams
Relationships
- Relationships - Identifying and Non Identifying
- Relationships - Recursive relationships
- Relationships - Super types and Sub types
- Relationships - Sub types transformations
Data Modeling Exercise
- Data Modeling Exercise - Retail banking system
ERwin Core Features
- Diagrams - How to create diagrams with different display elements
- Domain Dictionary - How to use domain objects in model
- Bulk Editor - How to edit definition of all entities/tables
- Forward Engineering - How to generate database schema from model
- Reverse Engineering - Creating a data model from database
- Naming Standards - Name settings and attaching business glossary
- Complete Compare - Compare models and import/export differences
- Reporting and Publishing - How to export diagram images
- Reporting and Publishing - Entity report using Report Designer
- Reporting and Publishing - HTML and PDF export with diagrams
Dimensional Modeling
- What is dimensional modeling
- Creating a star schema - retail sales
- Documenting Source to Target mappings and ETL rules
- Publishing Source to Target mappings and ETL Rules
Normalization
- Normalization - Introduction
- Normalization - First Normal Form Part1
- Normalization - First Normal Form Part2
- Normalization - Second Normal Form
- Normalization - Third Normal Form
- Normalization - BCNF
Student Exercises
- Logical data modeling practice - Public Library
- Public Library : Solution
- Logical data modeling practice - Transportation services
- Transportation Services : Solution
