Q1.
a) Illustrate the advantages of Star Schema? Illustrate in detail.
b) What are the different Star Schema Keys? Describe with the help of an illustration.
Q2.
a) What are the features of the OLTP and the fundamental data warehouse environments as they relate to the information delivery needs?
b) There are mostly two models of OLAP – ROLAP and MOLAP. State the features of these two models of the OLAP.
Q3.
a) List and describe the activities of ETL process.
b) What are the merits and demerits of Top-Down Approach and Bottom-Up Approach for the data warehouse design?
Q4.
a) Describe the differences between the Regression Tree and Model Tree.
b) Why is data security a main concern for the web-enabled data warehouse?
c) The average member method is sometimes employed to describe the outcomes for an unsupervised neural network clustering
i) List all the merits and demerits of this approach.
ii) Is there any similarity between this explanation method and the K-means algorithm? Describe.