Database Management System 2078

Section A

Long Answer Questions.

Attempt any Two questions.        (2 x 10 = 20)

1. What are different types of Database users and their roles? Explain the Data independence with example.

2. what are the components of ER diagram? Explain the function of various symbols use in ER diagram. Construct an ER diagram to store data in a library of your college.

3. Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?

Section B

Short Answer Questions.

Attempt any Eight questions.        (8 x 5 = 40)

4. What is difference between logical data independence and physical data independence?

5. Explain Relationship and Relationship sets with example.

6. Retrieve the TName, SName, SPhone for "ABC" school using SQL from given relation as below.

        TEACHER(TID, TName, TAddress, TQualification)

        SCHOOL(SID, SName, SAddress, SPhone)

        SCHOOL_TEACHER(SID, TID, No_of Period).

7. What is integrity? Explain different types of database integrity.

8. Define Functional dependencies. Explain trivial and non trivial dependencies?

9. Explain the difference between "Join" and "Natural Join" of algebraic operators with example.

10. What is Checkpoints in database recovery? How does it help in database recovery? Explain.

11. Define schedule and serializability. How can you test the serializability?

12. Explain Boyce-Codd normal form with example. How it is different than 3^rd Normal form.