MGM’s College of
Engineering, Nanded.Department of IT
Semester I (2017-18)
Class: BE(IT) Subject: DMDW Assignment I
1.
Enlist and explain characteristics of Data warehouse.
2.
Define metadata. What are the contents of metadata in DW? Enlist and explain.
3.
Draw the block diagram of DW architecture. Explain various components of DW
architecture.
4.
Enlist and explain the OLAP operations with appropriate example.
5.
A data cube is having sales of different cities of India, and it was decided to
find the total sales of each state, which OLAP operation is useful and why?
6.
A data cube is having total marks of students, which OLAP operations can be
used to find marks of each subject? Why?
7.
Compare snowflake and fact constellation schema with appropriate example.
8.
Suppose a DW consists of four dimensions
Time, Product, Branch, Manager and one measure Total_Sales. Draw a star and snowflake schema.
9.
Write SQL statements to create the above star schema (Q No. 8).
10.
Design a data warehouse for a regional weather bureau.
The weather bureau has about 1000 probes, which are scattered throughout
various land and ocean locations in the region to collect basic weather data,
including air pressure, temperature, and precipitation at each hour. All data
are sent to the central station, which has collected such data for more than 10
years. Your design should facilitate efficient querying and online analytical
processing, and derive general weather patterns in multidimensional space.
11. Explain starnet query model with an appropriate
example.
12. Describe the steps involved in data mining when
viewed as a process of knowledge discovery.
13. Suppose your task as a software engineer at Big-University
is to design a data mining system to examine
their university course database, which contains the
following information: the name, address, and status
(e.g., undergraduate or graduate) of each student, the
courses taken, and their cumulative grade point average (GPA). Describe the architecture
you would choose. What is the purpose of each component of this
architecture?
14. You design a data mining
software system for an enterprise, how you evaluate the performance of your data
mining software.
15. Create a bitmap index
for the following table.
|
TID
|
City
|
Type
|
Sales
|
|
T1
|
Pune
|
Retail
|
10000
|
|
T2
|
Mumbai
|
Dealer
|
>50000
|
|
T3
|
Nagpur
|
Dealer
|
>50000
|
|
T5
|
Pune
|
Dealer
|
10000
|
|
T6
|
Mumbai
|
Retail
|
>100000
|
16.
How is a data warehouse different from a
database? How are they similar?
Faculty
Incharge: Hashmi S A
