MU Information Technology (Semester 5)
Advanced Database Management Systems
December 2011
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 Transient and Persistent Objects.
5 M
1 (b) What are Triggers? Illustrate the cases when triggers must not be used.
5 M
1 (c) Explain and define the term Data Warehouse.
5 M
1 (d) Explain BCNF with suitable example.
5 M

2 (a) Explain design and implementation issues in Mobile Database.
10 M
2 (b) Explain with proper example nested Relation in ORDBMS.
10 M

3 (a) All electronics company have sales department Sales consider the dimensions namely
(i) Time (ii)Product (iii) Branch (iv) Location
with two measures
(i) Dollars-sold (ii) Units-sold
Design Star Schema and write DMQL for the above statement.
10 M
3 (b) Explain primary horizontal fragmentation in distributed databases.
10 M

4 (a) What are the main architectures used for building parallel databases? Give advantages and disadvantages of each.
10 M
4 (b) Explain following concepts with example:
(i) Object identity.
(ii) Type Constructors.
10 M

5 (a) Consider a data warehouse for a hospital, where there are three dimensions:
(i) Doctor (ii) Patient (iii) Time
and two measures
(i) Count (ii) Charge
where charge is the fee that the doctor charges a patient for a visit.
Using the above example describe the following OLAP operations:
(i) Slice (ii) Dice (iii) Rollup (iv) Drilldown
10 M
5 (b) Explain security and authorization in SQL.
10 M

6 (a) Explain various extended features of ER diagram such as aggregation, specialization and generalization with suitable example.
10 M
6 (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

Write short notes on:-
7 (a) Comparison between OLTP & OLAP.
5 M
7 (b) Two phase commit protocol.
5 M
7 (c) Spatial Database.
5 M
7 (d) Integrity Constraint.
5 M

More question papers from Advanced Database Management Systems