2013-14 Sem I DMDW Assignment I

MGM’s College of Engineering, Nanded.

Department of IT

Semester I (2013-14)

Class: BE(IT) Subject: DMDW Assignment I

________________________________________________________

1. What is Data warehouse? Explain the characteristics of DW.

2. Give the comparison between OLTP and OLAP.

3. What is data cube? Explain with an appropriate example.

4. Compare star, snow-flake and fact constellation schema.

5. Draw and explain Star and snow-flake schema of a DW for sales.

6. Explain the DW applications.

7. Explain OLAP operations with examples.

8. Explain the benefits of using DW for the businesses.

9. Explain the steps of data warehouse design process.

10. What is concept hierarchy? Explain with an example.

11. What are the different categories of Measures? Explain.

12. Write a note on starnet query model.

13. Draw and explain the architecture of datawarehouse.

14. Explain the data warehouse back-end tools.

15. What are the contents of metadata repository?

16. Write down the DMQL for

a. Star schema of a DW for sales

b. Snowflake schema of a DW for sales

c. Fact constellation schema of a DW for sales and shipping.

17. Discuss the types of OLAP servers.











Faculty Incharge: Hashmi S A