Database Management System KCS501
Database Management System KCS501
PAPER ID.410247
Roll No:
B. TECH.
(sEM V) THEORY EXAMINATION 2021-22
DATABASE MAI,{AGEMENT SYSTBM
Time: 3 Hours 'I'otal Mtrks: 100
Note: l. Attempt all Sections, lf require any missing data; then choose suitably.
SECTION A
1. Attempt all questions in brief. 2x I0:2(|
a. What is the signiticance of Physiciri Dara Independence'l
b. List. the four functions of DBA.
c. When a relation set is called a rer.:ursive relationship set?
d. \\&at do you msan by currency with respect to database?
e. What is Relational Calculus'/
t. What is Equi-Join in database?
g. What is a CLAUSE in terms of SQL?
h. Define the closnre of an attribute set.
i. When is a transaction Rolled Back?
j List the various levels o{'locking?
sEcrloN s
2. Attempt of the ibllowing:
any. three ' 10x3=30
a. Draw the overall strurcture of DBMS aud explain its various conrponents.
b. Which relational algebra operations require the participating tables to be union-
compatible? Give the Reason in detail.
What do you understand by transitive depenclencies? ExpIin u,ith an example
any tu,o problems that can arise in the database if transitive dependencies are
present in the database.
d. List ACID properties of transaction. Explain the usefi"rlness of each. What is
the importance ol'log?
e. What do you mean by time stamping protocol for concurrency controlling?
Discuss multi version scheme of concurrency control.
SECTION C
3" Attempt any one part of the tbllowing: l0xl:10
(a) What are the difl-erent types of Data Models in DBMS? Explain them.
(b) State the procedural DML and nonprocedrual DML rvith tlieir difI'ercnccs.
L
rrl[reu rtgea Lor a
Subject Code: KC5501
l r ffill I illl ll I llllll
lll I t
PAPER ID410247
lllllll I lll ll llll ll lll
Roll No: li
Attempt one part of the following: 10x1: t0
-
^ny
(r) Describe Armstrong's axioms in detail' What the role of these rules in
database develoPment Process?
(b) Describe the term MVD in the context of DBMS by giving an example. Discuss
4NF and 5NF also.