Assignment No. 01

Deadline date:

Your assignment must be uploaded/submitted before or on October 23, 2009.

Assignment Marks: 20

Assignment Topic:

Topics covered in this assignment are basic data warehouse concepts.

Uploading instructions

Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.

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

Objective

• To learn and understand basic data warehouse concepts.

Problems

Q No. 1 [5]

Give at least four reasons why we De-Normalize the database.

Q No. 2 [5]

If de-normalization improves data warehouse processes, why fact table is in normal form?

Q No. 3 [5]

Is OLTP database design optimal for Data Warehouse?

Q No. 4 [5]

Why data warehouse and transaction databases need to be different.