Download AKTU B-Tech 5th Sem 2017-2018 NCS502 Database Management System Question Paper

Printed pages: 01

Paper Id: 1037

Roll No:

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

B TECH

(SEM V) THEORY EXAMINATION 2017-18

DATABASE MANAGEMENT SYSTEM

Time: 3 Hours

Total Marks: 100

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

Notes: Attempt all Sections. Assume any missing data.

SECTION-A

1. Attempt all questions of the following: (10×2=20)
   1. Explain Specialization.
   2. Write Advantages of Database.
   3. Define DML.

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

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

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

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

SECTION-B

2. Attempt any Three of the following: (10×3=30)
   1. Discuss the role of database administrator.

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

   2. Discuss Join and Types with suitable example.
   3. What is Trigger? Explain different trigger with example.
   4. Write difference between BCNF Vs 3 NF.
   5. What is Two phase Locking (2PL)? Describe with the help of example.

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

SECTION-C

3. Attempt any One of the following: (10×1=10)
   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.
4. Attempt any One of the following: (10×1=10)
   1. Consider the following relation. The Primary key is Rollno, Isbn, Student(RollNo, Name, Branch), Book(Isbn, Title, Author, Publisher) Issue(Rollno, 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.

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

      2. Find the name of students who have issued a book of publication ‘BPB’.
      3. List the title and author of all books which are issued by a student name started with a.
      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’.

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

   2. Draw an ER diagram of Hospital or Bank with showing the Specialization, Aggregation, Generalization. Also convert it in to relational schemas and SQL DDL.
5. Attempt any One of the following: (10×1=10)
   1. Explain the Primary Key, Super Key, Foreign Key and Candidate key with example.
   2. Short Notes of the Following-
      1. MVD or JD
      2. Normalization with advantages

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

6. Attempt any One of the following: (10×1=10)
   1. What is Log? How is it maintained? Discuss the features of deferred database modification and immediate database modification in brief.
   2. What do you mean by Transaction? Explain transaction property with detail and suitable example.

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

7. Attempt any One of the following: (10×1=10)
   1. Explain all database languages in detail with example.
   2. Explain data fragmentation with types.

For more, visit FirstRanker.com

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