Q1. A data warehouse is a subject-oriented, time-variant, integrated and non-volatile collection of data to support of management’s decision-making process. Describe critically.
Q2. Explain how is data structured in the Data Warehouse? Describe?
Q3. What do you mean by Granularity? Illustrate the benefits related to the Data Warehouse?
Q4. Describe how process and data model can apply to the architecture environment? Explain why Process model is not appropriate for the data warehouse.
Q5. Describe in detail all the three data warehouse data models.
Q6. Describe star join with an illustration. Making a star join for the data warehouse is a mistake. Comment on it.
Q7. Describe Multidimensional DBMS. Describe the ways of implementing it by giving its strength and weaknesses. Explain how Multidimensional DBMS is distinct from the warehouse?