Day 1
Preface - Course Logistics, Agenda and Participant Introductions
Logical Data Modeling – Concepts
Chapter 1) What is Data Modeling? Picture This!
Logical Data Modeling Definition and Benefits
Data Modeling Basics: The Tools of the Trade
What is Metadata? And Why Do We Care?
Entities
Attributes
Business Rules
A Logical Introduction to Keys (more later…)
Primary, Alternate & Inversion Entry
Relationships
Chapter 2) Gathering Information for the Data Model
Modeling in the Real World
The Data Modeling Team
The Interview Process
The Group Facilitated Session (GFS)
What are we going to analyze?
The Business Case Study
Chapter 3) It’s All in the Details – Let’s Have a GFS!
Our Business Case Study
Determine & Define Entities, Attributes & Keys
Determine & Define Relationships
A Word About User Defined Properties (UDPs)
Definition & Benefits
Suggestions, Anyone?
Chapter 4) Now That You Know The Basics - Advanced Concepts
Unification & Rolenaming of Keys
Recursive Relationships (Have We Been Here Before?)
Resolving Many to Many Relationships (Like in Life)
Supertypes & Subtypes (Generalization Hierarchies)
Referential Integrity
Normalizing The Model (Not the Modelers)
Day 2
Using ERwin™ – Logically Speaking
Chapter 5) Getting Started - Building an ERwin® Model
ERwin® Navigation: Getting around town
The Lay of the Land –
The Model Explorer
The ‘Undo Redo’ Window
The Workspace
Drop Down & Popup Menus
Model Settings & Notation
A Visit to the Toolbox
The Editors
Building and Documenting the GFS Material
Creating Entities, Attributes & Keys
Logical Domains & Properties
Creating Relationships
Creating UDPs
Chapter 6) Communication is Everything: Logically Organizing & Displaying the Model
Subject Areas
Custodianship, Business Areas & ‘Work Spaces’
Stored Displays
Diagram Enhancement Tips
Color & Font
Drawing & Alignment Options
Chapter 7) The Ability to Meaningfully Document and Report
Determining Documentation Standards
The Benefit of Consistent Deliverables
Creating Command UDPs
The Data Browser
Creating Standardized, Customized & UDP Reports
Exporting Options
Printing Models
The Report Template Builder
Talk About Output!
Day 3
Chapter 8) Advanced Concepts – Let’s Get Some Resolution!
Validating Keys - Unification & Rolenaming
Building Recursive Relationships
Evaluating and Resolving ‘Many to Many(s)’
Determining & Building Supertypes & Subtypes
(Generalization Hierarchies)
Logical Transforms
Many-to-Many
Using ERwin® – Let’s Get Physical
Chapter 9) Logical? Physical? - What’s The Difference?
Physical Data Design Basics: A Mirror Image (at the beginning)
Logical vs. Physical Objects
Let’s Talk About:
Columns
Tables
Indexes
Referential Integrity (Remember the Business Rules?)
Preparing the Model for Database Creation
Transforms
Many to Many
Supertype/Subtype Identity
Validation Rules
Chapter 10) Forward Engineering – Giving Your Model a Promotion
What’s Forward Engineering?
Physical Transforms
Supertype/Subtype Rollup/Rolldown
Creating A Database from an ERwin® Model
Schema Generation Options
Validating the Script
Generating The Database
Day 4
Chapter 11) Reverse Engineering – Making Friends With Your Databases
What’s Reverse Engineering?
Do It With a Catalogue!
Do It With a Script!
Analyzing the Re-engineered Model: Making Sense of it All
Using ERwin® Domains
Validating Standards
Using ERwin™ Macros
Synchronizing
ERwin®’s Complete Compare
Chapter 12) Database Views – The Art of Perspective
What a View!
Creating A Database View
Modifying the View
Synchronizing the Model With the View
Getting Your Money’s Worth
Chapter 13) Best Practices - Suggestions for a successful modeling effort
The Big Picture: An Enterprise Wide View
Methods, Standards & Procedures
Model Reviews
Logical Model Validation & Quality Assurance
Physical Model Validation & Quality Assurance
Logical & Physical Models – Keep The Link
Creating A Structured Environment – Let ERwin® Help
Design Layers: Establish Your Model Environment
Maintenance: We’re Back to Standards & Procedures!
Splitting Logical/Physical Models
Deriving Models
Model Sources
Consistency! Reusability! Standards!
The Naming Standards Editor
The Datatype Standards Editor
Epilogue: Be Careful Out There
Closing Remarks
Evaluations
Certificates
Optional Course Chapters
Chapter 14) The Database Administrator’s World (DBA: Life on the Other Side)
The Finer Points of Referential Integrity
ERwin® RI Templates
Customizing Triggers
Stored Procedures
Pre & Post Scripts
Physical Transforms
Denormalization
Partitioning
Volumetrics
Chapter 15) Dimensional Modeling
So You Want A Data Warehouse?
Basic Concepts
Building a Star Schema Diagram