Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application BC0058-Data Warehousing-Assignment for fall session - Question Paper

August 2009
Bachelor of Computer Application (BCA) – Semester 6
BC0058 – Data Warehousing – four Credits
(Book ID: B1011)
Assignment Set – one (60 Marks)


1. elaborate Data Warehouse requirements? How do you gather the requirements?
(8 marks)
2. What is Data Transformation? discuss the tasks involved in it. (10 marks)
3. Why are the operational system keys not recommended for forming data warehouse primary keys? provide any 2 examples. (10 marks)

4. What is Data Management? discuss the various topics in Data Management. (10 marks)
5. Define OLAP. Mention its advantages. (6 marks)
6. Explain Indexing on Dimensional Tables and Fact Tables. (6 marks)
7. What is repository? How is it helpful to the data warehouse maintenance? (10 marks)





August 2009
Bachelor of Computer Application (BCA) – Semester 6
BC0058 – Data Warehousing – four Credits
(Book ID: B1011)
Assignment Set – two (60 Marks)



1. Explain any 5 responsibilities and roles in the development of Data Warehouse.
(10 marks)
2. What is Granularity? Will it effect the size of dimensional and fact tables. (10 marks)
3. What is full refresh? discuss in brief. (8 marks)
4.. discuss the subsequent Data Quality Methods (10 marks)
a. Data Capture
b. Data Integration
c. Data Cleansing
d. Data Augmentation and Enhancement
5. What are the differences ranging from ROLAP and MOLAP? (6 marks)
6. What are Materialized Views? How do these views increase the performance of the Data Warehouse? (10 marks)
7. Explain tech. and operational metadata. (6 marks)

Earning:   Approval pending.