Advanced Database Management Systems - December 2016
MU Information Technology (Semester 5)
Total marks: --
Total time: -- INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary 1(a) Discuss how each of the following operators can be parallelized using data partitioning.
ii) Join 10 marks
solve any one question from Q.1(b)(i) & Q1(b)(ii).1(b)(i) Consider the following relations Employee
PF) Department (dept_name,
location) Projects (p_id,
Give two examples that world be meaningful for horizontal fragmentation.
ii) Give an example for mixed fragmentation.
iii) Give an example for vertical fragmentation. 10 marks
1(b)(ii) Consider following schema for Jet Airline system
email) Flight( flight_no,
Explain the different types of transparencies in distributed database with respect to above schema. 10 marks
solve any one question from Q.2(a)(i) & Q2(a)(ii).2(a)(i) Design Object Relational Schema for Multiplex system. 10 marks
2(a)(ii) Design ODL Schema for payroll system 10 marks
2(b) What are the spatial operations possible on spatial database? Explain with examples. 10 marks
solve any one question from Q.3(a)(i) & Q3(a)(ii).3(a)(i) What is difference between data warehouse and data mart? Explain data warehouse design strategies with advantages and disadvantages for each. 10 marks
3(a)(ii) Draw and explain data warehouse architecture 10 marks
3(b) Show updates to the following dimension table. Consider Type 1,
3 Changes wherever applicable. Customer (customerId,
i) Wrongly entered Name: Kriti Gupta. Correct this Name to Kriti Sharma.
ii) Change the Martial status of the above customer from single to Married from the date Oct 1 2016.
ii) Temporary change in address of the above customer from New England to Chicago from 1 Dec 2015. 10 marks
solve any one question from Q.4(a)(i) & Q4(a)(ii).4(a)(i) What are the types of data transformation? Explain any five in detail. 10 marks
4(a)(ii) What are the different characteristics of dimension and fact table? Demonstrate with suitable examples. 10 marks
4(b) Design Snowflake Schema and Fact Constellation Schema for Banking system 10 marks
5 Explain following
i) Differentiate between relational and object relational database
ii) Need for object based database 10 marks
6 While working as a database analyst for Banking system, you are asked to he part of its data warehouse teams. Project group is ready to make a final decision between ROLAP and MOLAP. According to you which type of OLAP model should be used and why? 10 marks