Assignment No. 01
Your assignment must be uploaded/submitted before or on October 23, 2009.
Assignment Marks: 20
Topics covered in this assignment are basic data warehouse concepts.
Please view the assignment submission process document provided to you by the
Rules for Marking
It should be clear that your assignment will not get any credit if:
o The assignment is submitted after due date
o The assignment is copied
- To learn and understand basic data warehouse concepts.
Q No. 1 
Give at least four reasons why we De-Normalize the database.
Q No. 2 
If de-normalization improves data warehouse processes, why fact table is in normal form?
Q No. 3 
Is OLTP database design optimal for Data Warehouse?
Q No. 4 
Why data warehouse and transaction databases need to be different.