Database Technologies - December 2014

MU Information Technology (Semester 6)

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

Write a short note on the following:

1 (b) Weak entity set in ER diagram. 5 marks

1 (c) Data mart and data warehouse. 5 marks

1 (d) Trigger in SQL. 5 marks

2 (a) R=(A, B, C, D, E)
This relation R is decomposed into
R₁={A, B, C}
R₂={A, D, E}
Show that the decomposition if following functional dependencies hold
FD={A ?BC, CD?E, B?D, E?E} 5 marks

2 (b) Explain parallel database with advantages and dis-advantages. 5 marks

3 (a) Write a short note on constraints on database. 5 marks

3 (b) Define primary key, super key, candidate key and functional dependencies. 5 marks

4 (a) Describe design and implementation issues in mobile database. 5 marks

4 (b) Explain fragmentation in distributed database with proper example. 5 marks

5 (a) Differentiate between OLTP and OLAP. 5 marks

5 (b) Explain rules of mapping ER diagram to relational model. 5 marks

6 (a) Nested relations in ORDBMS. 5 marks

6 (b) Differentiate RDBMS, ORDBMS, CODBMS. 5 marks

Write short notes on the following:

7 (b) Specialization and generalization 5 marks

7 (c) Replication in distributed database. 5 marks

7 (d) BCNF. 5 marks