Download JNTUH MCA 3rd Sem R15 2018 June-July 823AC Database Management Systems Question Paper

FirstRanker.com

Firstranker's choice

Code No: 823AC Rl 5

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA III Semester Examinations, June/July - 2018

DATABASE MANAGEMENT SYSTEMS

Time: 3hrs Max.Marks:75

Note:

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

This question paper 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.

PART - A 5 x 5 Marks =25

1. Define types of relationships in ER diagram. 5
2. Explain types of Logical connectivity’s. 5

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

3. Differentiate Lossy and Lossless decomposition. 5
4. What is ARIES? 5
5. Define Structure of B+ trees. 5

PART -B 5 x 10 Marks =50

1. a) Define ER model and Explain the following kinds of constraints that can be specified in the ER diagram, and give an example of each:*a) key constraint b) participation constraint. [10]
   

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

   OR
   b) Define Data Model. Explain types of data models with suitable examples. [10]
2. a) Explain in detail about Relational Algebra, Domain Relational Calculus and Tuple Relational Calculus with suitable examples. [10]
   OR
   b) What is an unsafe query? Give an example and explain why it is important to disallow such queries? What is relational completeness? If a query language is relationally complete, can you write any desired query in that language? Justify. [5+5]

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

3. a) What are the properties of Decomposition? Discuss about loss less join Decomposition. What is meant by functional dependency and multi valued dependency? [5+5]
   OR
   b) Consider a relation R with five attributes ABCDE. You are given the following Dependencies: A -> B, BC -> E, and ED -> A.
   1. List all keys for R
   2. Is R in 3NF?
   3. Is R in BCNF.

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

   Which of the following decompositions of R=ABCDEG, with the same set of dependencies F,is (i) Dependency-preserving? (ii) Lossless-join? I) {AB, BC, ABDE, EG} II) {ABC, ACDE, ADG} [5+5]
4. a) State and explain various Lock-based concurrency control mechanisms and algorithms. [10]
   OR
   b) What is Deadlock? Discuss the methods for handling Deadlocks. [10]
5. a) Explain the File organization types and its techniques. [10]
   

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

   OR
   b) What are Index data structures? Explain with suitable examples the hash based indexing. [10]

FirstRanker.com