UNIVERSITY EXAMINATIONS: 2010/2011
THIRD YEAR STAGE EXAMINATION FOR THE DEGREE OF BACHELOR
OF SCIENCE IN INFORMATION TECHNOLOGY
BIT 4204: DATA WAREHOUSING AND DATA MINING
DATE: AUGUST 2011 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a)Explain the following concepts
i) Data mining (2 Marks)
ii) Data Warehouse (2 Marks)
iii)Online Analytical Processing (2 Marks)
b)Describe the basics of Bayesian Theorem (10 Marks)
c)Elaborate the following schemas as used in data warehousing
i) Simple Star Schemas (2 Marks)
ii) Multi-Star Schema (2 Marks)
iii)Snowflake Schema (2 Marks)
d)Outline the typical OLAP operations (4 Marks)
e)Explain any four applications of data mining (4 Marks)
QUESTION TWO
a)Outline the main challenges associated with web mining (4 Marks)
b)Differentiate between k-medoids and the k-means methods in partitioning (4 Marks)
c)Explain any four general applications of clustering? (8 Marks)
d)What is the meaning of the term good clustering? (4 Marks)
QUESTION THREE
a)Explain how clustering can be used in the following areas
i) Marketing (2 Marks)
ii) Land use (2 Marks)
iii)Insurance (2 Marks)
b)Explain the term neural network as applied in data mining (2 Marks)
c)Discuss the following as used in knowledge discovery
i) Data Selection (2 Marks)
ii) Cleaning (2 Marks)
iii)Enrichment (2 Marks)
d) i) What is Frequent Pattern Mining? (2 Marks)
ii) Give examples of frequent patterns (4 Marks)
QUESTION FOUR
a)Describe the various techniques used in estimation of trends (6 Marks)
b)Expound on any four clustering algorithms (8 Marks)
c)Outline the main challenges associated with web mining (6 Marks)
QUESTION FIVE
a)Explain the various functionalities given by a data mining tool (8 Marks)
b)Substantiate on the different types of data mining output (6 Marks)
c)Giving reasons explain the importance of online analytical mining (6 Marks)
