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

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 3rd Sem (Third Semester) Regulation-R13 2019 December 813AP Database Management Systems Previous Question Paper


R13

Code No: 813AP















JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA III Semester Examinations, December - 2019

DATABASE MANAGEMENT SYSTEMS

Time: 3hrs















Max.Marks:60

S

Note: This question paper contains two parts A and B.

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 ? 4 Marks = 20



1.a)

What is data model? Explain various types of data model?





[4]

b)

What is the difference between tuple relation calculus and domain relation
calculus?



















[4]

c)

Explain Multivalued dependencies and Fourth normal form with example?

[4]

d)

What is concurrency control? Explain.











[4]

e)

What is indexing? Explain the cluster index, primary and secondary indexes.

[4]



PART - B

















5 ? 8 Marks = 40



2.a)

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

b)

List out the significant difference between file processing system and DBMS.

[4+4]

OR

3.a)

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

b) What is E-R Model? Draw an E-R Diagram for Airline reservation system.

[4+4]



4.a)

Let R =(ABC) and S=(DEF) let r(R) and s(S) both relations on schema Rand S.
Give an expression in the Tuple relational calculus that is equivalent to each of the
following.
i) A1,(r)

ii) p=19(r)

iii) rXs

iv) A,F,( C=D(rXs)).

b)

What is a trigger? Explain various types of triggers with examples.



[4+4]

OR

5.a)

Explain the following Operators in SQL with examples



i) EXISTS



ii) NOT IN

iii) INTERSECTION iv) UNION

b)

Explain various DML stamens in SQL With example.







[4+4]


6.a)

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



b) What is the maximum normal form satisfying the following relation R and functional

dependencies?
R(A,B,C,D,E,P) and F.D ={ ABCD, DEP,CE,PC }





[4+4]

OR

7.a)

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

b)

Explain about Inclusion dependencies with example?







[4+4]




8.a)

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

S b) Explain the following

i) Write-Ahead Log Protocol

ii) Fuzzy Check point.





[4+4]

OR

9.

Give an overview of deadlocks.













[8]


10.

What are the difference between ISAM and B+ trees Indexes? Explain Deletion and
insertion operations in ISAM with examples?









[8]

OR

11.

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















[8]





---ooOoo---


This post was last modified on 17 March 2023