problem 1)a) Give the schematic representation of star schema by incorporating the following dimensions.

i) Sales fact table.

ii) Any four dimension tables

b) Differentiate between Data Warehouse and Data Mining.

problem 2)a) Describe the function of the following OLAP operations.

i) Dice

ii) Slice

iii) Roll up

iv) Roll down

b) prepare down the difference between DBMS and KBCS.

problem 3)a) Describe knowledge discovery in databases process. Bring out the block diagram of KDD process and describe the components of KDD process.

b) prepare a note on datamarts.

problem 4)a) Describe generalized Bayes decision model.

b) Give the model for estimating P (correct).

problem 5)a) Describe decision tree pruning algorithm.

b) Describe the use of entropy in the construction of a decision tree.

problem 6)a) Describe neural network based classification procedure.

b) prepare a detailed note on genetic algorithms.