Download JNTUH MCA 3rd Sem R17 2021 July-August 843AA Data Base Management Systems Question Paper

Code No: 843AA

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

FirstRanker.com

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

R17

MCA III Semester Examinations, July/August - 2021

DATA BASE MANAGEMENT SYSTEMS

Time: 3 Hours Max.Marks:75

Answer any five questions

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

All questions carry equal marks

1. a) Explain about various data models.
   b) Discuss about database users and administrators. [8+7]
2. a) Draw ER diagram for Ternary Relationship set with suitable example.
   b) Discuss about key constraints for Ternary Relationships. [8+7]

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

3. a) Discuss about Complex integrity constraints in SQL. [15]
4. a) Explain about tuple relational calculus.
   b) Discuss about the expressive power of relational algebra and calculus. [8+7]
5. a) Define Third Normal Form and explain with example.
   b) Explain about Loss less-join decomposition. [8+7]

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

6. a) Describe Validation-based locking protocols. [15]
7. a) Explain advanced recovery techniques. [15]
8. a) Explain about B+ tree index file. Illustrate deletion of an element in B+ Tree with example.
   b) Explain in detail about Extendible hashing. [8+7]

--00000--

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

FirstRanker.com