1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
M.Sc.DEGREE EXAMINATION STATISTICS
FOURTHSEMESTER APRIL 2018
16PST4MC02- DATA WAREHOUSING AND DATA MINING
Date: 20-04-2018 Dept. No. Max. 100 Marks
Time: 01:00-04:00
Part A
Answer all the questions 10 X 2 =20
1. Define data warehouse according to W.H Inmon
2. What is relational database in data warehouse?
3. Define data cube.
4. State any two benefits of star schema.
5. State the roles of administrator in data warehouse.
6. What is metadata in data warehouse?
7. What is data mining?
8. When do stop the tree in CHAID?
9. Define confidence in Association rule mining?
10. What is support in Apriori rule mining?
Part B
Answer any FIVE questions 5 X 8 =40
11. Distinguish between data warehouse database and OLTP database
12. Explain snowflake schema.
13. Explain type of indexes.
14. Describe horizontal partition in data warehousing.
15. What are advantages and disadvantages of decision tree?
16. Explain any four applications of data mining.
17. What are the issues in Data Mining?
18. What are the three important types of data model? Explain.
Part C
Answer any TWO questions 2 X 20 =40
19. Explain CRISP Data Mining Architecture.
Mention the advantages and disadvantages of decision trees.
20. What kind of Data can be mined?
How does Naïve Bayesian work in data mining?
21. Explain Classification tree algorithm.
22. Explain the algorithms.
Artificial Neural Networks
k nearest neighborhood