Download JNTUH MCA 3rd Sem R17 2019 December 843AA Database Management Systems Question Paper

FirstRanker.com

Code No: 843AA

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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

Note: This question contains two parts A and B.
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b, c as sub questions.

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

PART - A

5 x 5 Marks =25

1. a) What is aggregation in ER diagram? Explain with example. [5]
2. b) What are candidate key, primary key, and foreign key? [5]
3. c) What is a functional dependency? Quote example. [5]

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

4. d) What do you understand by serializability of schedules? Explain. [5]
5. e) Explain the distinction between static and dynamic hashing. Discuss the relative merits of each technique. [5]

PART -B

5 x 10 Marks =50

1. Explain following terms with examples
   

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

   a) Data Independence b) Data manipulation language [5+5]
   OR
2. Explain the several choices and issues involved in Conceptual design with ER Model. [10]
3. Discuss the process of converting ER model to Relational model. [10]
   OR

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

4. Consider the following given schema and write the SQL queries
   Sailor (sailorid, sailorname, rating, Age)
   Reserves (sailor id, Boatid, day)
   Boat Schema(Boatid, boatname, color)
   a) find the names and ages of sailors with a rating above 6.
   

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

   b) Find the sailor name, boat id and reservation date for each reservation.
   c) Find the names of sailors who have reserved boat 202.
   d) Find the names of sailors who have reserved at least two boats.
   e) Find the sailors who have reserved all the red boats. [10]
5. Explain primitive operations and derived operations in Relational Algebra. [10]
   

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

   OR
6. What is Lossless join and dependency Preservation property for decomposition? Explain. [10]
7. a) What is the need of concurrency control?
   b) What is two-phase locking and how does it guarantee serializability? [3+7]
   OR

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

8. What is time stamping? Explain a mechanism of concurrency control that uses time stamping with the help of an example. [10]
9. Discuss about B+ tree index file with example. [10]
   OR
10. Discuss about B tree index file with example along with advantages and disadvantages. [10]

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