DATA WAREHOUSE AND DATA MINING (DWDM) DECEMBER 2012 COMPUTER SCIENCE SEMESTER 6
Con. 8161-12. KR-9224
(3 Hours) [Total Marks : 100]
Note: 1. Question 1 is compulsory
2. Answer any 4 out of the remaining questions.
3. Answers to sub questions must be written together.
| Q1. (a) | Consider the following database for a chain of bookstores. | |
| BOOKS (Booknum, Primary_author, Topic, Total_stock, price) | ||
| BOOKSTORE (Storenum, City, State, Zip, Inventory_value) | ||
| STOCK (Storenum, Booknum, Qty) | ||
| With respect to the above business scenario, answer the following questions. Clearly state | ||
| any resonable assumptions you make. | ||
| (i) Design an information package diagram. | (5) | |
| (ii) Design a star schema for the data warehouse clearly identifying the Fact table(s). | (5) | |
| Dimension table(s), their attributes and measures. | ||
| (b) | Consider the 5 transactions given below. If minimum support is 30% and minimum | (10) |
| confidence is 80%, determine the frequent itemsets and association rules using the a | ||
priori algorithm. | ||
| Q2. | Define the following terms by giving examples (5x4) | (20) |
| (a) Factless Fact tables | ||
| (b) Snowflake Schema | ||
| (c) Web structure Mining | ||
| (d) Classification | ||
| Q3. (a) | Explain the ETL cycle for a data warehouse in detail. | (10) |
| (b) | Give five examples of application that use Clustering. Describe | (10) |
| any one clustering algorithm with the help of an example. | ||
| Q4. (a) | Consider a data warehouse storing sales details of various sold, and the | (10) |
| time of the sale. Using this example describe the following OLAP operations | ||
| (1) Slice (2) Dice (3) Rollup (4) Drill down | ||
| (b) | With a neat diagram describe the KDD process | (10) |
Q5. (a) | What do you mean by web mining? Explain any one web mining algorithm | (10) |
| (b) | Describe the different features of a web enabled data warehouse. Give two example | (10) |
| applications where such a system would be used. | ||
| Q6. (a) | Explain spatial and temporal data mining. | (10) |
| (b) | What is the role of Meta data on a data warehouse? Illustrate with examples | (10) |
Q.7 | Describe through a short note each of the following topics (10X2) | (20) |
| (a) DMQL | ||
| (b) Visualization techniques for Data warehousing and mining |
No comments:
Post a Comment