DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI), B.E. (IT) Semester- 7, (May 2013)

DATA WAREHOUSING, MINING AND BUSINESS INTELLIGENCE (DWMBI)

B.E. (IT) Semester- 7, (May 2013)

Con. 7596-13.

GS-5344

(3 Hours)

[Total Mark 100]

N.B. (1) Question No 1 is compulsory.

(2) Attempt any four questions from remaining six questions.

(3) Assume suitable data if required.

1. Attempt any four : -

(a) Give difference between OLTP and OLAP. --- (5 Marks)
(b) Explain DBSCAN. --- (5 Marks)

(c) Give difference between Classification and Clustering. --- (5 Marks)
(d) Explain Regression. --- (5 Marks)

2. (a) List the dimension and facts for hospital management system and also draw star schema and snowflake schema. --- (10 Marks)
(b) Why pre-processing is required? --- (5 Marks)
(c) Explain multidimension association rule. --- (5 Marks)

3. (a) What is Web structure mining? Explain technique of Web structure mining. --- (10 Marks)
(b) Explain data discritization and summarization with example. --- (10 Marks)

4. (a) Define the following terms with example: --- (10 Marks)

I. Item Set

II. Frequent Item Set

III. Closed Item Set

(b) What is market basket analysis? Explain its use. --- (10 Marks)

5. (a) Following table gives fat and proteins content of items. Apply single linkage clustering and construct dendrogram: - --- (10 Marks)

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

(b) Explain spatial data mining (SDM). Also explain a model of spatial data warehouse. --- (10 Marks)

6. (a) Use K- mean Algorithm to create three clusters for given set of values: --- (10 Marks)

{

2,

3,

7,

8,

9,

15,

17,

19,

25

}

(b) Explain Hoeffding tree algorithm with example. --- (10 Marks)

7. Write short notes on any three:- --- (20 Marks)
(a) Spatial data cube construction

(b) Bayesian classification

(c) Text mining approaches

(d) Issues in data mining

Also see Data warehousing, Mining and business intelligence question papers for December 2012