UNIT-I: Data Warehouse
S. No Question Bloom's Taxonomy Level
1. Define data warehouse. Remembering
2. Differentiate between operational database systems and data warehouses. Understanding
3. List the key characteristics of a data warehouse. Remembering
4. Explain the architecture of a data warehouse. Understanding
5. Describe the ETL (Extraction-Transformation-Loading) process. Understanding
6. How does logical (multi-dimensional) modeling work in data warehousing? Applying
7. Compare the Star schema and Snowflake schema. Analyzing
8. Explain Fact Constellation with an example. Understanding
9. What are dimension table characteristics? Remembering
10. Discuss the OLAP Cube and its operations. Understanding
11. Differentiate between ROLAP, MOLAP, and HOLAP. Analyzing
12. How does schema design impact data warehousing performance? Evaluating
13. Design a basic star schema for an e-commerce business. Creating
14. Assess the challenges in implementing a data warehouse. Evaluating
15 Formulate a strategy for an effective data warehouse design. Creating
UNIT-II: Data Mining Basics
S. No Question Bloom's Taxonomy Level
1. Define data mining. Remembering
2. What are the major functionalities of data mining? Understanding
3. Classify different types of data mining systems. Understanding
4. Explain the data mining task primitives. Understanding
5. Illustrate how data mining integrates with a database system. Applying
6. What are the major issues in data mining? Analyzing
7 .Why is data preprocessing important in data mining? Understanding
8 .Describe data cleaning and its significance. Understanding
9.. How does data integration and transformation help in preprocessing? Applying
10. Discuss the importance of data reduction. Evaluating
11. Explain discretization and concept hierarchy generation. Understanding
12. Compare various data preprocessing techniques. Analyzing
13. Design a preprocessing framework for handling missing values. Creating
14. Evaluate the impact of data preprocessing on mining results. Evaluating
15. Formulate preprocessing steps for a healthcare dataset. Creating
UNIT-III: Classification
S. No Question Bloom's Taxonomy Level
1. Define classification in data mining. Remembering
2. What are the general approaches to solving a classification problem? Understanding
3. Describe various classification techniques. Understanding
4. Explain decision tree construction. Understanding
5. How do you express attribute test conditions in decision trees? Applying
6. Compare different methods for selecting the best split in decision trees. Analyzing
7. Explain Naïve Bayes classifier with an example. Understanding
8. Discuss various prediction accuracy and error measures. Analyzing
9. Evaluate the strengths and weaknesses of decision trees. Evaluating
10 .How do you assess the accuracy of a classifier? Applying
11. Compare decision tree classification with Naïve Bayes classification. Analyzing
12. How can classification models be improved for better prediction? Evaluating
13 .Design a classification model for customer segmentation. Creating
14. Develop a hybrid classification approach for loan approval prediction. Creating
15. Evaluate the impact of feature selection on classification performance. Evaluating
UNIT-IV: Association Rules
S. No Question Bloom's Taxonomy Level
1. Define association rules in data mining. Remembering
2. Explain the frequent itemset generation process. Understanding
3. What is the APRIORI principle? Remembering
4. Describe the confidence and support measures in association rules. Understanding
5. Illustrate the APRIORI algorithm with an example. Applying
6. What are the limitations of the APRIORI algorithm? Analyzing
7. Compare FP-Growth and APRIORI algorithms. Analyzing
8 .How does the partition algorithm work in association rule mining? Applying
9. Describe the compact representation of frequent itemsets. Understanding
10. Explain closed frequent itemset and its importance. Understanding
11.. Evaluate different association rule mining approaches. Evaluating
12. Compare various confidence measures used in association rule mining. Analyzing
13 .Design an improved frequent pattern mining algorithm. Creating
14 .Assess the real-world application of association rule mining in retail. Evaluating
15. Develop an association rule mining strategy for e-commerce recommendation systems. Creating
UNIT-V: Clustering and Advanced Concepts
S. No Question Bloom's Taxonomy Level
1 .Define clustering in data mining. Remembering
2. Categorize major clustering methods. Understanding
3 .Describe the k-means clustering algorithm. Understanding
4. Explain the PAM clustering algorithm. Understanding
5. Compare hierarchical clustering and partitioning clustering. Analyzing
6. How do agglomerative and divisive clustering methods work? Applying
7. What is outlier detection in clustering? Understanding
8. How is web content mining different from web usage mining? Analyzing
9. Describe web structure mining with examples. Understanding
10. Explain the significance of spatial and temporal mining. Understanding
11. How does text mining contribute to data analytics? Understanding
12. Compare different clustering evaluation metrics. Analyzing
13 .Design a clustering model for customer segmentation. Creating
14. Assess the impact of noise on clustering performance. Evaluating
15. Formulate a strategy for mining multimedia data. Creating
