Download GTU BE/B.Tech 2018 Winter 7th Sem New 2170715 Data Mining And Business Intelligence Question Paper

FirstRanker.com

Subject Code: 2170715

GUJARAT TECHNOLOGICAL UNIVERSITY

--- Content provided by⁠ FirstRanker.com ---

BE - SEMESTER-VII (NEW) EXAMINATION - WINTER 2018

Subject Name: Data Mining and Business Intelligence

Time: 10:30 AM TO 01:00 PM

Date: 03/12/2018

Total Marks: 70

--- Content provided by FirstRanker.com ---

Instructions:

1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q.1

--- Content provided by‍ FirstRanker.com ---

1. (a) What is Data Mining? Why is it called data mining rather than knowledge mining? (03)
2. (b) Explain various features of Data Warehouse? (04)
3. (c) Differentiate between Operational Database System and Data Warehouse (07)

Q.2

1. (a) What is the difference between KDD and Data Mining? (03)

--- Content provided by FirstRanker.com ---

2. (b) What is Concept Hierarchy? List and briefly explain types of Concept Hierarchy (04)
3. (c) Explain Mean, Median, Mode, Variance, Standard Deviation & five number summary with suitable database example. (07)

OR

1. (a) What is noise? Explain data smoothing methods as noise removal technique (03)
2. (b) to divide given data into bins of size 3 by bin partition (equal frequency), by bin means, by bin medians and by bin boundaries. (04) Consider the data: 10, 2, 19, 18, 20,18, 25, 28, 22

--- Content provided by FirstRanker.com ---

3. (c) Differentiate Fact table vs. Dimension table (07)

Q.3

1. (a) Suppose that the data for analysis includes the attribute age. The age values for the data tuples are (in increasing order): 13, 15, 16, 16,19, 20, 23, 29, 35, 41, 44, 53, 62, 69, 72 Use min-max normalization to transform the value 45 for age onto the range [0:0, 1:0] (03)
2. (b) Explain mining in following Databases with example. (04)
   1. Temporal Databases
   2. Sequence Databases

   --- Content provided by‌ FirstRanker.com ---

   3. Spatial Databases
   4. Spatiotemporal Databases.
3. (c) List and describe methods for handling missing values in data cleaning. (07)

OR

--- Content provided by​ FirstRanker.com ---

1. (a) Explain the following as attribute selection measure: (03)
   1. Information Gain
   2. Gain Ratio

Q.4

1. (a) How K-Mean clustering method differs from K-Medoid clustering method? (03)

--- Content provided by⁠ FirstRanker.com ---

2. (b) Define data cube and explain 3 operations on it. (04)
3. (c) State the Apriori Property. Generate large itemsets and association rules using Apriori algorithm on the following data set with minimum support value and minimum confidence value set as 50% and 75% respectively (07)

   TID	Items Purchased
   T101	Cheese, Milk, Cookies
   T102	Butter, Milk, Bread
   T103	Cheese, Butter, Milk, Bread
   T104	Butter, Bread

OR

1. (a) Define following terms : (03) Data Mart , Enterprise Warehouse & Virtual Warehouse
2. (b) Discuss the application of data warehousing and data mining (04)

--- Content provided by‍ FirstRanker.com ---

3. (c) What is web log? Explain web structure mining and web usage mining in detail (07)

Q.5

1. (a) Draw the topology of a multilayer, feed-forward Neural Network. (03)
2. (b) Explain Linear regression with example. (04)
3. (c) Explain the major issues in data mining (07)

--- Content provided by⁠ FirstRanker.com ---

OR

1. (a) Briefly explain text mining (03)
2. (b) What is market basket analysis? Explain the two measures of rule interestingness: support and confidence (04)
3. (c) What is Big Data? What is big data analytic? Explain the big data-distributed file system. (07)

FirstRanker.com

--- Content provided by FirstRanker.com ---