Download JNTUH MCA 3rd Sem R13 2019 December 813AP Database Management Systems Question Paper

FirstRanker.com

Firstranker's choice

Code No: 813AP

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA I Semester Examinations, December - 2019

DATABASE MANAGEMENT SYSTEMS

Time: 3hrs Max.Marks:60

Note:

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

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

PART - A

5 x 4 Marks =20

1. a) What is data model? Explain various types of data model? [4]

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

2. b) What is the difference between tuple relation calculus and domain relation calculus? [4]
3. c) Explain Multivalued dependencies and Fourth normal form with example? [4]
4. d) What is concurrency control? Explain. [4]
5. e) What is indexing? Explain the cluster index, primary and secondary indexes. [4]

PART -B

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

5 x 8 Marks = 40

1. What is E-R Model? Define generalization, specialization and aggregation? How are they represented in E-R Model?

   List out the significant difference between file processing system and DBMS. [4+4]

   OR

   Define data independence? Explain difference between logical and physical data independence.

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

   What is E-R Model? Draw an E-R Diagram for Airline reservation system. [4+4]

2. Let R=(ABC) and S=(DEF) let r(R) and s(S) both relations on schema R and S.

   Give an expression in the Tuple relational calculus that is equivalent to each of the following.

   1) sA1(r) 1) sB=9(r) 1i1) rXs V) sA=C(rXs).

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

   What is a trigger? Explain various types of triggers with examples. [4+4]

   OR

   Explain the following Operators in SQL with examples

   1) EXISTS i) NOT IN iii) INTERSECTION iv) UNION

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

3. Explain various DML statements in SQL With example. [4+4]

4. What are the conditions required for a relation to be in BCNF What is the difference between 3NF and BCNF.

   What is the maximum normal form satisfying the following relation R and functional dependencies?

   R(A,B,C,D,E,P) and F.D ={ AB->CD, DE->P,C->E,P->C} [4+4]

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

   OR

   Define functional dependencies. How are primary keys related to FD’s?

   Explain about Inclusion dependencies with example? [4+4]

5. Explain the multiversion concurrency control protocol ? How is it used to ensure Serializability?

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

   Explain the following

   1) Write-Ahead Log Protocol i1) Fuzzy Check point. [4+4]

   OR

   Give an overview of deadlocks. [8]

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

6. What are the difference between ISAM and B+ trees Indexes? Explain Deletion and insertion operations in ISAM with examples? [8]

   OR

   What is linear hashing? How does linear hashing avoid directory? Discuss the round robin splitting of buckets. [8]

FirstRanker.com

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