MU Information Technology (Semester 7)
Data Warehousing, Mining and Business Intelligence
May 2013
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


1 (a) Give different between OLTP and OLAP
5 M
1 (b) Explain DBSCAN.
5 M
1 (c) Give difference between Classification and Clustering.
5 M
1 (d) Explain constraint based association rule mining.
5 M
1 (e) Explain Regression.
5 M

2 (a) List the dimension and facts for hospital management system and also draw star schema and snowfalke schema.
10 M
2 (b) Why preprocessing is required?
5 M
2 (c) Explain multidimention association rule.
5 M

3 (a) What is web structure mining? Explain Technique of web structure mining.
10 M
3 (b) Explain data descritization and summarization with example.
10 M

4 (a) Define the following terms with example-
(i) Item set (ii) frequency item set (iii) closed item set.
10 M
4 (b) What is Market basket analysis? Explain its use.
10 M

5 (a) Following table gives fat and proteins content of items. Apply single linkage clustering and construct dendrogram :-
Food Item Protein Fat
1 1.1 60
2 8.2 20
3 4.2 35
4 1.5 21
5 7.6 15
6 2.0 55
7 3.9 39
10 M
5 (b) Explain spatial data mining (SDM). Also explain a model of spatial data warehouse.
10 M

6 (a) Use k-mean Algorithm to create three cluster for given set of values :-
{2,3,7,8,9,15,17,19,25}.
10 M
6 (b) Explain Hoeffding tree algorithm with example.
10 M

Write short notes on any three :-
7 (a) Spatial data cube construction
7 M
7 (b) Bayesian classification
7 M
7 (c) Text mining approaches
7 M
7 (d) Issue in data mining
7 M



More question papers from Data Warehousing, Mining and Business Intelligence
SPONSORED ADVERTISEMENTS