Kuvempu University 2012 B.Sc Information Technology .,(IT) s /e Data Warehousing &Data Mining - Question Paper

Time: 3hrs
Max. Marks: 100
Note:
1. Part- A compulsory
2. ans any 5 full ques. from part-B
Part-A
ans all questions:

1. What is a database? Why we have to normalize the data. (5)
2. Indicate the important functions of Warehouse Manager and Query Manager. (5)
3. explain the significant problems in automatic cluster detection. (5)
4. List and discuss various events with regard to data ware housing. (5)
5. Write a note on Data mining querying language. (5)

Part- B
ans any 5 full questions:

1.
a) With the help of an example discuss the concept of Data ware house and Data mining. (8)
b) discuss Data ware house schemas. (7)
2.
a) What is meta data and data mart discuss with example. (8)
b) Show the typical process flow in a data ware house. (7)
3.
a) List and discuss the important guidelines to be followed in hardware partitioning. (7)
b) What is summary table? explain the aspects to be looked while designing summary table. (8)
4.
a) discuss in detail the design of star flake schema. (7)
b) discuss in detail Hardware partitioning. (8)
5.
a) elaborate the types of data that can be mined? (7)
b) discuss in detail back propagation neural network. (8)
6.
a) discuss Bayes theorem with the help of an example. (7)
b) What is the meaning of clustering in data mining? List the requirements for clustering. (8)
7.
a) List the guidelines for KDD environment. (7)
b) discuss the data mining for financial data analysis. (8)
8.
Write short notes on the subsequent (3*5=15)
a) Genetic algorithm
b) K-means Clustering
c) Load Manager

Earning:   Approval pending.