Class: BE(IT) Subject: DMDW Assignment-I Semester-I (2019-20)

MGM’s College of Engineering, Nanded.
Department of IT
Semester I (2019-20)

Class: BE(IT)       Subject: DMDW         Assignment I

1. Differentiate between DBMS and Datawarehouse.

2. What are the properties of data in a datawarehouse? Explain.

3. Draw the block diagram of DW architecture. Explain various components of DW architecture.

4. Define data cube. Explain OLAP operations that can be performed on data cube.

5. A data cube is having aggregate Sales of Maharashtra State. Identify an OLAP operation to find Sales of Mumbai, Pune and Nagpur?

6. A data cube is having data of IPD and OPD patients. Identify an OLAP operation to find the data of all patients.

7. Classify the schema used in datawarehouse design.

8. Design star schema for a Pathological Laboratory. Consider Test, Doctor, Time, and Hospital as Dimensions and Count as a measure.

9. Compose SQL statements to create above star schema (Q No 8).

10. Explain fact constellation schema with an example.

11. Suppose a DW consists of four dimensions Date, Region, Product, Manager and two measures Quantity_sold and Amount. Draw snowflake schema.

12. Categorize the Measures used in Data Cube.

13. Create a bitmap index for the following table.

TID	Branch	Product	Quantity
T10	Pune	SamsungS10	100
T20	Mumbai	iPhone10	75
T30	Nagpur	iPhone10	75
T50	Pune	Samsung S10	100
T60	Mumbai	VivoS25	50

14. Define data mining. Discuss the characteristics of DM output.
15. What are the steps of KDD process? Explain briefly.
16. Compare ROLAP, MOLAP and HOLAP.

******Best of Luck******

Faculty Incharge: Hashmi S A