Hall Ticket No Question Paper Code: BCS005
INSTITUTE OF AERONAUTICAL ENGINEERING
(Autonomous)
M.Tech II Semester End Examinations (Supplementary) January, 2019
Regulation: IARE-R16
ADVANCED DATABASE MANAGEMENT SYSTEM

Time: 3 Hours Max Marks: 70
Answer ONE Question from each Unit
All Questions Carry Equal Marks
All parts of the question must be answered in one place only
UNIT I
1. Explain inheritance Abstraction mechanism in DBMS?
Define views and specify the commands for creating, destroying, and altering view tables. For
following entities create a view SeniorEmp with the columns as sname, sage, salary from the
given tables and implement update delete operations on the viewtable. Emp integer,
ename: string, age: integer, salary: real) Works integer, did: integer, pct time: integer)
Dept(did: integer, budget: real, managerid:integer)
2. Define ER Diagram and draw the ER Model for online railway reservation system
What are structured data types and describe its operations, create a table PERSON which
consists of three columns where two are of regular data types and other one should be abstract
type.

UNIT II
3. Differentiate Relational Data Base Management System and Object Relational Data Base Management
System.
Given n x n array of objects, assume that you can fit 100 objects on a disk page. Describe a
way to layout (Chunk) the array into pages so that retrievals of square m x m sub regions of the
array are efficient.

4. Differentiate horizontal and vertical partitioning techniques with examples
Explain query optimization mechanism with suitable examples.
UNIT III
5. Differentiate centralized databases verses distributed databases .
Draw the reference architecture for distributed database and explain the components of distributed
data bases.
6. Explain the types of data fragmentation techniques in distributed databases.
Page 1 of 2
Write an update application program for distributed transparency mechanism.
UNIT IV
7. Write steps involved in transforming global queries into fragmental query.

Give an example of bank application, accessing a database which is distributed over the branches
of the bank, in which the relevant predicates for data distribution in the text of application
program.

8. Draw and explain framework for distributed database design
Give an example of global schema, fragmentation schema and additional semantic knowledge
such that all this information can be used for deducing the simplification of a query?
UNIT V
9. Explain Information Retrieval Model with example scenarios
Explain the procedure for creation of join queries, general queries and non-join queries in a
distributed DBMS?
10. Describe Querying XML data and the procedure of efficient evaluation for XML queries.
Demonstrate the cost-based query optimization technique in distributed databases?