Jawaharlal Nehru Technological University Hyderabad 2011-3rd Sem M.C.A Code No: MC305 R06 s- DATABASE MANAGEMENT SYSTEMS - Question Paper

1. a) What is meant by data abstraction? discuss the 3 levels of data abstraction.
b) explain the significance of E-R diagrams. Draw a E-R diagram for banking enterprise.
2. explain the subsequent operations in the relational algebra.
a) choose operation
b) Set difference operation
c) Cartesian – product operation
d) Rename operation.
3. a) Write the structure of a SQL query. discuss the comparison operators and aggregative operators.
b) elaborate the complex integrity constraints in SQL? discuss them.
4. What is meant by schema refinement? explain about first, 2nd and 3rd normal forms with suitable examples.
5. a) define the term transaction management? explain about ACID properties.
b) discuss the lock based concurrency control with an example.
6. a) explain about check points in crash recovery.
b) discuss the lock conversions and concurrency without locking.
7. What is meant by indexing? explain the cluster indexes, primary and secondary indexes and index data structures.
8. Write short notes on the following:
a) Linear hashing
b) Indexed sequential access methods
c) Hash based indexing.

Earning:   Approval pending.