Database Technologies - Dec 2011

Information Technology (Semester 6)

TOTAL MARKS: 100
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any four from the remaining questions.
(3) Assume data wherever required.
(4) Figures to the right indicate full marks. 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)