Jawaharlal Nehru Technological University Hyderabad 2009-2nd Sem B.Tech Information Technology , Code No: 07A4EC14 Set No1 II Regular s, / DATA BASE MANAGEMENT SYSTEMS ( Common to Computer Sc

Code No: 07A4EC14 Set No. 1
II B.Tech II Semester Regular Examinations, Apr/May 2009
DATA BASE MANAGEMENT SYSTEMS
( Common to Computer Science & Engineering and info
Technology)
Time: three hours Max Marks: 80
ans any 5 ques.
All ques. carry equal marks
? ? ? ? ?
1. (a) elaborate the kinds of languages a database system provides? discuss.
(b) elaborate the 5 main functions of a Database Administrator? [8+8]
2. (a) What is a relational database query? discuss with an example.
(b) discuss the subsequent fundamental operations of relational algebra. choose
project set rename. [8+8]
3. (a) discuss in detail the two ways of executing pipeline?
(b) Write the SQL expressions for the subsequent relational database? [6+10]
sailor schema (sailor id, Boat id, sailorname, rating, age)
Recerves (Sailor id, Boat id, Day)
Boat Schema (boat id, Boatname, color)
i. obtain the age of the youngest sailor for every rating level?
ii. obtain the age of the youngest sailor who is eligible to vote for every rating
level with at lead 2 such sailors?
iii. obtain the No.of reservations for every red boat?
iv. obtain the avg. age of sailor for every rating level that at lowest two sailors.
4. Consider the relation R(A,B,C,D,E,F) and FDs
A ! BC, F ! A,C ! AD ! E, E ! D AD is the decomposition of R into
R1(A,C,D) R2 (B,C,D) and R3 (E,F,D) loss less? discuss the requirement of Loss
less decomposition?
5. (a) describe the concept of schedule for a set of concurrent transaction. provide a
suitable example. [8]
(b) discuss read-only, write-only & read-before-write protocols in serialazability.
[8]
6. (a) discuss how a system crash can recovered using ARIES Algorithm. [8]
(b) Write a short notes on
i. WAL Protocol
ii. Check pointing [8]
7. discuss about Fixed-Length file organization with an example. [16]
8. discuss all the operations on B+
-tree by taking a sample example.

Earning:   Approval pending.