ASSIGNMENT 2

1    What is data warehouse

2.     Differences between operational database system and data warehouse

3.     Explain about star , snowflakes and fact constellations schema for multidimensional database

4      Write the steps for the design and construction of data warehouse

 5.     Discuss the usage of data warehouse

6.     Draw  three tier data warehouse architecture

              

7.   Explain about different types of OLAP servers

8.   What is Metadata? What are its requirements?

9.   Explain with a neat diagram about OLAP & OLAM.

10.   Explain about different OLAP operations.