-modeling data for the data warehouse
-because of the vast size of a data warehouse, the warehouse database consists of de-normalized data
- relational theory does not apply to a data warehousing system
- wherever possible normalized tables pertaining to selected events may be consolidated into de-normalized tables