Q1. Describe the fundamental components or elements of the data warehouse with the help of a diagram.
Q2. Distinguish between the given:
a) OLTP and OLAP
b) Database and Data Warehouse
Q3. Describe three different kinds of distributed data warehouse. Describe local and global data warehouses.
Q4. What do you mean by EIS? Describe it with the help of an illustration.
Q5. Write detail notes on any three of the given:
a) ERP-oriented Corporate Data Warehouse
b) Data Warehouse Physical Data Model
c) Structuring Data in Data Warehouse
d) Granularity in Data warehouse Environment.