MU Information Technology (Semester 5)
Advanced Database Management Systems
December 2012
Total marks: --
Total time: --
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary

This Qs paper appeared for DBT of Information Technology (Semester 6)
1 (a) Explain Replication in Database.
5 M
1 (b) Explain BCNF with Example.
5 M
1 (c) Compare Data mart and Data Warehouse.
5 M
1 (d) Explain Nested Relations.
5 M

2 (a) Suppose that we decompose the schema
R = (A, B, C, D, E) into (A, B, C) and
(A, D, E)Show that this decomposition is a lossless join decomposition if the following set F of functional dependencies hold:
A ? BC
CD ? E
B ? D
E ? A
10 M
2 (b) What are the main architectures used for building parallel Databases? Give advantages and disadvantages of each.
10 M

3 (a) Explain Security and Authorization in SQL.
10 M
3 (b) Given a relation with eight attributes Proj_no, Proj_name, Emp_no, Emp_name, Job_class, Charge_hrs, Hrs_billed and Tot_charges.
Normalize it upto 3rd Normal form.
10 M

4 (a) Explain design and implementation issues in Mobile Database.
10 M
4 (b) What is fragmentation? Explain different types of fragmentation in distributed database.
10 M

5 (a) Explain object identity and type constructors with example.
10 M
5 (b) Define Data warehouse. Explain architecture of data warehouse with suitable block diagram.
10 M

6 (a) Consider a data warehouse for hospital, where there are three dimensions:
(i) Doctor (ii) Patient (iii) Time
and two measures-
(i) Count (ii) Charges
where charges is the fee that doctor charges a patient for visit.
Using the above example, describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
10 M
6 (b) Explain various Extended features of ER Diagram such as aggregation,Generalization and Specialization with suitable examples.
10 M

Write short notes on (any two)
7 (a) Spatial Databases.
10 M
7 (b) OLAP Servers.
10 M
7 (c) ODL Schema.
10 M
7 (d) Comparison between OLTP and OLAP.
10 M

More question papers from Advanced Database Management Systems