Guru Gobind Singh Indraprastha Vishwavidyalaya 2007 B.C.A Computer Application Mobile Computing - Question Paper

Q1 (a) What is a data warehouse? discuss its various characteristics.
Differentiate ranging from data warehouse architectures.
(b) discuss various data warehouse architectures.
Q2 Differentiate ranging from the following:-
(i) OLAP and Data Mining
(ii) ROLAP and MOLAP
(iii) Drill across and drill through
(iv) Relational data \bases and Multidimensional databases.
Q3 (a) On the basis of underlying structures and basic process make a comparison
ranging from various datamining technique.
(b) explain the cluster analysis technique in details?
Q4 (a) What is back propagation? How does it work? Write a back propagation
Algorithm for a neural network trained to classify the samples where given: the
Training samples, the learning rate, a multilayer feed network trained to classify
the samples.
(b) provide a few examples where temporal mining is relevant.
Q5 (a) What is the STAR schema? elaborate the component tables?
(b) You are the data design specialist on the data ware house project team for a
Manufacturing company. Design a star schema to track the production volumes
are analyzed along the business direction of product, tuime parts used, production
quality and production ryun. State your assumptions.
(c) discuss various OLAP operations?
Q6 (a) discuss the role of detamining in data warehousing.
(b) discuss various datamining acto\ivities in detail?
(c) What is the essential difference ranging from associate rules & decision rules/
Q7 discuss various data mining techniques based on data retention.
Q8 Write short on the following:-
(i) Data Mining Applications
(ii) Multidmensional Analysis
(iii) Data Intergration and Transformation

Earning:   Approval pending.