Scribd
Upload
8 views2 pages

Data Warehousing and Mining Questions

The document outlines a set of assignment questions related to data warehousing and data mining, with a submission deadline of August 17, 2024. It includes questions on various topics such as the distinction between data warehousing and mining, applications, architectures, schemas, OLAP, ETL processes, sampling methods, data pre-processing, and decision tree algorithms. Additionally, it provides datasets for practical exercises involving ID3 and CART methods for determining root nodes.

Uploaded by

kunalsawant2611
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views2 pages

Data Warehousing and Mining Questions

The document outlines a set of assignment questions related to data warehousing and data mining, with a submission deadline of August 17, 2024. It includes questions on various topics such as the distinction between data warehousing and mining, applications, architectures, schemas, OLAP, ETL processes, sampling methods, data pre-processing, and decision tree algorithms. Additionally, it provides datasets for practical exercises involving ID3 and CART methods for determining root nodes.

Uploaded by

kunalsawant2611
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DWM Assignment Questions

Submission guidelines:
1. Submit on or before Aug 17, 2024
Q1. Distinguish between data warehousing and data mining approaches.
Q2. What are the applications of data warehousing?
Q3. Distinguish between database and data warehouse.
Q4. What are the common 3 architectures of data warehouse?
Q5. Explain about star schema and snowflake schema. Write down their advantages and disadvantages.
Q6. What is OLAP, what are the different types of OLAP, explain in brief for each type.
Q7. What do you understand by ETL? Mention the steps of ETL in brief.
Q8. How can we select attribute subset from an entire dataset.
Q9. What are the different types of sampling? Explain in brief.
Q10. What do you understand by binning? Explain with one example.
Q11. What is histogram? Explain using an example.
Q12. What is data pre-processing? Explain in brief.
Q13. What is the purpose of data cleaning?
Q14. What is the purpose of data normalization. Apply min-max, z-score and constant factor normalization on the below example.

Q15. Find out the root node using ID3 (Information Gain) from the below data set.
Day Outlook Temp. Humidity Wind Play
Tennis

D1 Sunny Hot High Weak No

D2 Sunny Hot High Strong No

D3 Overcast Hot High Weak Yes

D4 Rain Mild High Weak Yes

D5 Rain Cool Normal Weak Yes

D6 Rain Cool Normal Strong No

D7 Overcast Cool Normal Weak Yes

D8 Sunny Mild High Weak No

D9 Sunny Cold Normal Weak Yes


D10 Rain Mild Normal Strong Yes

D11 Sunny Mild Normal Strong Yes

D12 Overcast Mild High Strong Yes

D13 Overcast Hot Normal Weak Yes

D14 Rain Mild High Strong No

Q16. Find out the root node using CART (Gini index) from the below data set.

You might also like