INTRODUCTION:
Transaction Database 
Transaction Database Definition and features 
E-R Data Model Database Normalization using 
Six Normal Forms Database Denormalization.

Warehouse Database 
Data Warehouse Definition and Features 
Difference between Transaction Database and Warehouse Database 
Dimensional Data Model 
Star Schema Model 
Star Flake Schema Model 
Snow Flake Schema Model 
Extended Star Schema Model 
Galaxy Schema Model 
Cube Designing using different models 
Denormalization of Data Warehouse 
Other Databases Data Mart Staging Database Operation Data Storage/Source (ODS) 

Database Modeling using ERWIN Logical Data Model and Physical Data Model Models, 
Subject Areas and Display Objects Entities, 
Relations, 
Attributes and Business Rules Relation Cardinalities, 
Verb Phrases, 
Relation Types & Referential Integrity ERWin Macros, 
Model Properties, 
Model Mart