SNDT Womens University 2008 B.Tech Information Technology -Advance DBMS - Question Paper

Advance Database Management System
Year – 2008
Fourth Year ( IT )
Duration – three hrs

Note: Attempt any 5 ques.. [Marks : 100]

Q 1]
A] Compare and contrast RDBMS, OODBMS and ORDBMS with reference to data model, architecture, query language and implementation. [Marks : 10]
B] describe the concept of nested relations in ORDBMS with example. [Marks : 10]

Q 2]
A] discuss different techniques for distributed database design with suitable example with advantage and disadvantage of every. [Marks : 10]
B] discuss the concurrency control in distributed database management system with ex. [Marks : 10]

Q 3]
A] In case of distributed database, discuss the data fragmentation and its kind with example.
[Marks : 10]
B] elaborate various architecture models for parallel database? discuss [Marks : 10]

Q 4]
A] provide the rules for converting EER to object relational database schema. [Marks : 10]
B] discuss 2 tier and 3 tier client server architecture with example. [Marks :10]

Q 5]
A] discuss the transaction management in object oriented DB system. [Marks : 10]
B] discuss features of object query language (OQL) with reference to path expression, methods, polymorphism, group and having construction in OQL with example. [Marks : 10]

Q 6] Detailed Notes on Following [Marks : 20]
A] Deductive DB
B] Temporal DB

Q 7]
A] elaborate components of EER diagram? provide rules for converting EER diagram to relational table with suitable example. [Marks : 10]
B] Draw EER for airline reservation system. [Marks : 10]

Earning:   Approval pending.