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

Code No: 07A4EC14 Set No. 4
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. discuss the E-R diagram components and notaions with their extended features.
[16]
2. (a) What is a relation? Differentiate ranging from relation schema and relation in-
stance. describe the terms unity and degree of relation. elaborate domain
constraints?
(b) What SQL construct enables the definition of a relation? What constructs
allow modification of relation instances? [8+8]
3. What is Normalization? explain elaborate the types? explain the 1NF, 2NF, 3NF
with example. [16]
4. (a) What is Normaliztion?give kinds of normalization
(b) elaborate the advantages of normalized relations over the un normalized rela-
tions? [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) describe dynamic database. discuss phantom issue by considering suitable
example. [8]
(b) discuss B+ tree locking used for concurrency controlwith suitable example.
[8]
7. (a) discuss about tertiary storage media in detail.
(b) discuss about Buffer Manager. [8+8]
8. discuss the distinction ranging from closed and open hashing. explain the relative
merits of every technique in database applications.

Earning:   Approval pending.