MGM’s College of Engineering, Nanded.
Department of IT
Semester I (2018-19)
Class: BE(IT) Subject: DMDW Assignment I
Department of IT
Semester I (2018-19)
Class: BE(IT) Subject: DMDW Assignment I
1. Define Datawarehouse. What are its characteristics? Explain.
2. Compare OLTP and OLAP.
2. Compare OLTP and OLAP.
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 stocks of 5 branches , which OLAP operations can be used to find stock of each branch? Why?
6. A data cube is having marks of different subjects of students, and it was decided to find the total marks of each student, which OLAP operation is useful and why?
5. A data cube is having aggregate stocks of 5 branches , which OLAP operations can be used to find stock of each branch? Why?
7. Compare star and snowflake schema for DW.
8. Explain fact constellation schema with an example.
9. Suppose a DW consists of four dimensions Year, State, Item, Manager and two measures Quantity_sold and Amount.Draw a star and snowflake schema.
10. Write SQL statements to create above star schema (Q No 9).
11. Explain starnet query model with an appropriate example.
12. Design a data warehouse for the results of a university having different affiliated colleges. Assume suitable dimensions.
13. Define data mining. Discuss the characteristics of DM output.
14. What are the steps of KDD process? Explain briefly.
15. Create a bitmap index for the following table.
8. Explain fact constellation schema with an example.
9. Suppose a DW consists of four dimensions Year, State, Item, Manager and two measures Quantity_sold and Amount.Draw a star and snowflake schema.
10. Write SQL statements to create above star schema (Q No 9).
11. Explain starnet query model with an appropriate example.
12. Design a data warehouse for the results of a university having different affiliated colleges. Assume suitable dimensions.
13. Define data mining. Discuss the characteristics of DM output.
14. What are the steps of KDD process? Explain briefly.
15. Create a bitmap index for the following table.
TID
|
Branch
|
Class
|
Count
|
T1
|
IT
|
Distinction
|
25
|
T2
|
CSE
|
First
|
15
|
T3
|
Civil
|
First
|
15
|
T5
|
IT
|
Distinction
|
25
|
T6
|
CSE
|
Second
|
10
|
16. Compare ROLAP, MOLAP and HOLAP.
Faculty Incharge: Hashmi S A
