13

14

15

a)

b)

H192009 Pages: 3

Suppose a datawarehouse consists of three measures customer, account and
branch and two measures count (number of customers in the branch) and
balance. Draw the schema diagram using snowflake schema.

Real-world data tend to be incomplete, noisy, and inconsistent. What are the
various approaches adopted to clean the data?

PART C
Answer any two full questions, each carries 9 marks.

Given the following data on a certain set of patients seen by a doctor, can the
doctor conclude that a person having chills, fever, mild headache and without

running nose has the flu?(Use Naive Bayes algorithm for prediction)

Pre running nose headache fever | has flu

Y N mild Y N
Y Y no N Y
ட்‌ N strong ட்‌ Y
N Y mild ட்‌ x
N N no N N
N ட்‌ strong ட்‌ ரட்‌
N Y strong N N
Y Y mild ட்‌ Y

The following figure shows a multilayer feed-forward neural network. Let the
learning rate be 0.9. The initial weight and bias values of the network is given in
the table below.The activation function used is the sigmoid function.

Pe fee eee किन ‏وج‎ ர
-0.4

05
0.2

06
0.1

೪46. ४७४56

-0.3 -0.2

೪134 [೪೫35
-0.5 0.2

3. 4

1 0.2

೪15
-0.3

1೫24
0.4

W25
0.1

Page 2of 3

(4)

(5)

(9)

(9)