No. of Pages: 3

APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FIRST SEMESTER M.TECH DEGREE EXAMINATION, DECEMBER 2018

Computer Science and. Engineering
(Computer Science and Engineering)

01056151: Data Warehousing & Mining
Max. Marks: 60 Duration: 3 Hours
Instructions: Answer any Two questions from each Part
PART A
1. A data warehouse consists of three dimensions time, doctor and patient and two (9)
measures count and charge, where charge is the fee that a doctor charges a patient for
a Visit.
(i) Enumerate three classes of schema that are popularly used for modeling data
warehouses.
(ii)Draw a schema diagram for the above data warehouse using schema classes
listed in.

2 2. When is data reduction used for preprocessing of data? How is data reduction
done using principal component analysis?

b. Choose any normalization method to normalize the following data. Justify (4) the
choice of normalization method.

13,15,16,16,19,20,20,21,22,22,25,25,25,25,25,30,33,33,35.
3 9. Illustrate the 3 tier architecture of Data warehouse with a neat diagram. (5) b.
Differentiate MOLAP and ROLAP. (4)
PART 13
4. 4. . Illustrate a multi layer Feed Forward Neural Network.

b. List the stages involved i_n the train_ing of Back PropagaHon Network
(BPN).(4)

5. 3. Given two objects represented by the tuples (22, 1, 42, 10) and (20, 0, 36, 8), (2)

compute the cosine similarity between the two tuples.