Q1. Distinguish between:
a) Data Warehouse and MDBMS.
b) OLAP and OLTP.
Q2. Define and distinguish between the dimensional data modeling and relational data modeling.
Q3. Describe the architecture of the data warehouse with the help of a diagram.
Q4. Explain Drill-Down Analysis and Event Mapping in context of EIS.
Q5. Write brief notes on any three:
a) Partitioning of Data in the Data Warehouse.
b) Lock Management.
c) Data Marts.
d) Outlier Analysis