Download AKTU B-Tech 4th Sem 2016-17 ECS402 Database Management System Question Paper

B.TECH.

THEORY EXAMINATION (SEM–IV) 2016-17

DATABASE MANAGEMENT SYSTEM

--- Content provided by FirstRanker.com ---

Time: 3 Hours Max. Marks : 100

Note: Be precise in your answer.

SECTION – A

1. Attempt the following:
   1. Explain Specialization.
   2. Write Advantages of Database.

   --- Content provided by​ FirstRanker.com ---

   3. Define DML.
   4. Explain Logical data Independence.
   5. Explain Entity Integrity Constraints.
   6. Define 2 NF.
   7. Explain I in ACID Property.

   --- Content provided by FirstRanker.com ---

   8. Define schedule.
   9. Define Exclusive Lock.
   10. Define replication in distributed database.

10 x 2 = 20

--- Content provided by​ FirstRanker.com ---

SECTION - B

2. Attempt any five of the following questions:
   1. Discuss the role of database administrator.
   2. Explain the Primary Key, Super Key, Foreign Key and Candidate key with example.
   3. Draw an ER diagram of Hospital or Bank with showing the Specialization, Aggregation, and Generalization. Also convert it in to relational schemas and SQL DDL.
   4. Discuss Join and Types with suitable example.

   --- Content provided by⁠ FirstRanker.com ---

   5. What is Trigger? Explain different trigger with example
   6. Short Notes on the Following-
      1. MVD or JD
      2. Normalization with advantages
      3. BCNF VS 3NF

   --- Content provided by⁠ FirstRanker.com ---

   7. What is Log? How is it maintained? Discuss the features of deferred database modification and immediate database modification in brief.
   8. What is Two phase Locking (2PL)? Describe with the help of example.

5 x 10 = 50

SECTION – C

--- Content provided by FirstRanker.com ---

3. Attempt any two of the following questions:
   1. What do you mean by serializability? Discuss the conflict and view serializability with example. Discuss the testing of serializability also.
   2. What are multi version schemes of concurrency control? Describe with the help of an example. Discuss the various Time stamping protocols for concurrency control also.
   3. Consider the following relation. The Primary key is Roll No, ISBN –Student (Roll No, Name, Branch), Book (ISBN, Title, Author, Publisher), Issue (Roll No, ISBN, Date_of_issue) Write the query in Relational algebra and SQL of the following-
      1. List the Roll Number and Name of All CSE Branch Student.
      2. List the name of all student who read a book
      3. List the title and author of all books which are issued by a student name started with a.

      --- Content provided by‌ FirstRanker.com ---

      4. List the title of all books issued on or before 20/09/2012.
      5. List the name of student who will read the book of author named ‘Sanjeev’.

2 x 15 = 30

--- Content provided by⁠ FirstRanker.com ---

Visit FirstRanker.com for more resources.