Q1. Distinguish between:
a) Data Warehouse and MDBMS.
b) OLAP and OLTP.
Q2. What do you mean by Multidimensional DBMS? Describe the merits and demerits of relational foundation of the multidimensional DBMS and cube foundation of the multidimensional DBMS.
Q3. Describe the architecture of the data warehouse by using a diagram.
Q4. Describe the Drill-Down Analysis and Event Mapping in the context of EIS.
Q5. Write a detail note on any three:
a) Partitioning of Data in Data Warehouse.
b) Complexities in transformation and integration of data.
c) Global and Local Data Warehouse.
d) Data Marts.