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

You are here: » Download JNTU OR MCA 3-semester DATABASE MANAGEMENT SYSTEM December 2008 Exam Question Paper

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.
DATABASE MANAGEMENT SYSTEM
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).
A→BC
CD→E
B→D
E→A

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.

ilook website
 
 

Categories:Uncategorized;Tags: , ,

   

No Comment to “Download JNTU OR MCA 3-semester DATABASE MANAGEMENT SYSTEM December 2008 Exam Question Paper”

  1. No Comment yet. Be the first to comment...
Leave your comment here: