Download JNTU OR MCA 3-semester DATABASE MANAGEMENT SYSTEM December 2008 Exam Question Paper

Code No: OR-31-MCA
M.C.A.-III Semester Supplementary Examinations, December 2008.
Time:3hours Max.Marks.60
Answer any FIVE questions
All questions carry equal marks

1. Explain with examples various database models.

2.a) Construct an E-R diagram for a university registrar’s office. The office maintains data about each class, including the instructor the enrollment, and the time and place of the class meetings. For each student-class pair, a grade is recorded. Document all assumptions that you make about the mapping constraints.
b) Explain the difference between a weak and a strong entity set with examples.

3.a) Give the formal definition for triple relational calculus. Cement on expressive power of the triple relational calculus.
b) Explain with an example how QBE allows queries that span several relations.

4.a) Explain with examples how database modification can cause violations of referential integrity.
b) Compute B+ of the following set I of functional dependencies for relation R= (A, B, C, D, E).

5. Explain in detail normalization using multivalued dependencies.

6. What is a B+ tree. How are the following operations executed on B+ tree
a) look-up
b) Insertion
c) Deletion

7. Explain in detail log-based recovery.

8.a) Explain validation based protocol.
b) Write on multiple granularity.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.