Advanced Database Management Systems - Dec 2011

Information Technology (Semester 5)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks.

This Qs paper appeared for DBT of

Information Technology (Semester 6) 1 (a) Explain Transient and Persistent Objects.(5 marks) 1 (b) What are Triggers? Illustrate the cases when triggers must not be used.(5 marks) 1 (c) Explain and define the term Data Warehouse.(5 marks) 1 (d) Explain BCNF with suitable example.(5 marks) 2 (a) Explain design and implementation issues in Mobile Database.(10 marks) 2 (b) Explain with proper example nested Relation in ORDBMS.(10 marks) 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 marks) 3 (b) Explain primary horizontal fragmentation in distributed databases.(10 marks) 4 (a) What are the main architectures used for building parallel databases? Give advantages and disadvantages of each.(10 marks) 4 (b) Explain following concepts with example:
(i) Object identity.
(ii) Type Constructors.(10 marks) 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 marks) 5 (b) Explain security and authorization in SQL.(10 marks) 6 (a) Explain various extended features of ER diagram such as aggregation, specialization and generalization with suitable example.(10 marks) 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 3^rd Normal form.(10 marks)

Write short notes on:-

7 (a) Comparison between OLTP & OLAP.(5 marks) 7 (b) Two phase commit protocol.(5 marks) 7 (c) Spatial Database.(5 marks) 7 (d) Integrity Constraint.(5 marks)