MGM’s College of
Engineering, Nanded.
Department of IT
Semester I (2019-20)
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.
15. What are the steps of KDD process? Explain briefly.
16. Compare ROLAP, MOLAP and HOLAP.
******Best of Luck******
Faculty Incharge:
Hashmi S A
