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

Code No: 07A4EC14 Set No. 2
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) discuss the Transaction management in a database.
(b) explain the Query Processor of Database system structure. [8+8]
2. (a) What is a relational database query? discuss with an example.
(b) elaborate the SQL constructs to replace the structure of tables, views and to
destroy the tables and views? [8+8]
3. (a) describe query processing and briefly discuss the steps involved in it?
(b) Write queries for the subsequent using the provided info
Emp Name DOB DOJ Emp Salary Bonus DOR
Buelin 06-12-1983 07-08-2005 15000 600 07-08-2055
Andy 12-01-1970 06-12-1973 20000 1200 06-12-2043
Lubber 07-08-1985 12-04-2006 13000 500 12-04-2056
Zobra 08-02-1960 07-03-1982 25000 1500 07-03-2032
(a) obtain total salary of employees from emptable?
(b) obtain months ranging from employee DOJ and DOR from emp-schema?
(c) Create new salary table using the ampno, empname, and empsalary from
existing table?
(d) organize empnames in ascending and descending order? [16]
4. (a) describe BCNF. How does BCNF differ from 3NF? discuss with an example.
(b) discuss 3nf? provide 1 example? [8+8]
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) elaborate the kinds of failures of a system. [6]
(b) elaborate the reasons strict 2PL used in many database systems [5]
(c) How the use of 2PL would prevent interference ranging from the 2 transactions.
[5]
7. (a) discuss about Fixed-Length Representation in detail.(b) discuss about Byte-String Representation. in detail. [8+8]
8. discuss about the B -tree and the structure of B + tree in detail with an example
(b) discuss about Byte-String Representation. in detail. [8+8]
8. discuss about the B -tree and the structure of B + tree in detail with an example

Earning:   Approval pending.