1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER-IV EXAMINATION WINTER 2018
Subject Code: 2640005 Date: 29/11/ 2018
Subject Name: Data Warehousing Data Mining
Time: 10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1

Explain the four Key-words of Data Warehousing
07

Define Following Terms: Explain in Short
1. Data mart
2. Noisy Data
3. Outlier
4. Data Generalization
5. Correlation
6. Liner Regression
7. Data Cluster
07
Q.2

Explain the Process of Data Warehouse Design
07

Give the Example with Data of Roll-up, Drill-down, Slice Dice
07
OR

Generate the Data Cubes for Student Registration System
07
Q.3

Explain Data Integration and Data Transformation for Data Warehousing
07

Discuss the Real Application of Frequent Data Item Generation
07
OR
Q.3

What is Missing Values in Data Warehousing? Also Explain how Handle Missing Values.
07

Discuss Real Application of Cluster Analysis
07
Q.4

Explain Attribute-Oriented Induction and its Efficient Implementation
07

Discuss Closed Itemsets, Association Rules for Mining Frequent Patterns
07
OR
Q.4

Explain Mining Class Comparison between Different Classes
07

How Apriori Algorithm best for Mining Frequent Patterns Discuss with Example
07
Q.5

Short note on Types of Cluster Analysis
07

Discuss Application of Biological Data Analysis
07
OR
Q.5

Explain Partitioning Methods for Cluster Analysis
07

Discuss Application of Telecommunication Industry
07