Download AKTU B-Tech 5th Sem 2015-2016 Data Base Management System Ncs 502 Question Paper

Download AKTU (Dr. A.P.J. Abdul Kalam Technical University (AKTU), formerly Uttar Pradesh Technical University (UPTU) B-Tech 5th Semester (Fifth Semester) 2015-2016 Data Base Management System Ncs 502 Question Paper

(\
Printed Pages: 6 S61 NCS-502
(F ollowing Paper ID and Roll No. to be ?lled in your
Paper lD:110502 ' Roll No.
Answer Book)
B. Tech.
(SEM. V) THEORY EXAMINATION, 2015-16
DATA BASE MANAGEMENT SYSTEM
[Time:3 hours] [MaximumMarksz 100
Section-A
1. Attempt all parts Ofthis section. Answer in brief.
(a)
(b)
(C)
(d)
(e)
(10x2=20)
What are the advantages of ?le processing system
which were removed by the DBMS ?
Give example of a simple, composite attributes of
an entity.
What do you mean by referential integrity ?
What do you mean-by DML and DDL ?
Distinguish between functional dependency ?nd
multivalued dependency.
(1) * P.?l?.().

(f) Dating.- muhi \- crsion scheme.
(g) What are {he pitfalls of lock based protocol 1?
{h} What is multimedia database '3
('i? \v?v?hat is union cymzpatibiliiy ?
G) What arc the various anumalics ussvcimcd with
RDBMS ??
Section-B
Note: Attempt any five questions from this section :
00x5:5m
A university ragistrar?s of?ce maintains data about the
tblimving cntitics (:1) courses. iuculding number. title,
cmdiie?. 3;} llabun 21nd prerequisites: (b) course offerings,
i,::_?311ding A?OUI?DC aumbcr. year: semester, section number,
'niirucmrig)? timings and classroom; (0) students,
inci?u-Jang xmdcm-Ed, name and program; and (d)
instruvtm's, including identi?cation number, name
apartment and title. Further. the enrollemem ofstudents
in courses and grades awarded to students in each course
they are enrolled for must be appropriately modeled.
(2)
L44
s nnsmk. an 3 Wk {E?ugmm for thc rea?atr'wa oi? '
Luanncn! n31 mmmpuun that wu mam- sham Ii?
mapping comm aims.
Consider the. following relations :
Siuu?cnt (?, name, address, major)?.
Course (gggg, title)
Registered ($.53. code)
[.556 relational alg?hra to answer the ibllowing :
(1) List the codes of courses in which at least one.
student is registered (registered courses)
(u) List the title of rcgistcred courses.
(m) Llst the codes ()fcuurses for which 110 student is
registered,
(W) The UHCS of courses for which no student i?
registered.
( 5) Names 01? students and the tithes 0f cour?mg [112v
registered to
x.?
717
,?
\-

vi SL?
( } SNS of students who are registered 1;); both
?Dat?ab'ts ? .
c 6 Systems? and ?Annb's?ts OfAlgoriIhmfx".
v? 1 . t .
( n) SSNS 01 students who are rcgisiered for both
?Data ' ? ? ? ?
base Systtms and Analysm ni?Algorithms'.
(vm) lhe name ofstudcnts who are registe'ed for both
?Da 4 . I ,' h ?
tdbase Systems and AnalySIS ofAlgorithms?
ix 4. t? . . .
( ) I ist 01 courses m which allstudents are registered
(x) List of gourses in which all ?ECMP? major studentx?
are registcrd.
xv . l d!? [h
kev.
v
De?ne functional dependency. What do vou mean by
l - a u d
035 less decomposmon ? Explain with suitable example
how function dependencies can be used to show that
decompositions are loss-less.
D - .
etme Normal forms. List the de?nitions of First
Second and T hird normal forms. Explain BCNF with a
suitable example
(4)
9.
What i< transaction ? Draw a state diagram of a
transaction showing its states. ExplainACID properties
of a Iransa ction with suitable examples.
What are schedules ? What are differences between
con?ict serialzabilty and view serialzability ? Explain
with suitable example what are cascadeless and
recoverable schedules ?
What are distributed databases ? List advantages and
disadvanta gcs ofdata replication and data fragmentation.
Expiain with a suitable example. what are differences in
replication and fragmentation transparency ?
Section?C
Note :Attempt any two questions from this section.(15x2=30)
10.
11.
Describe major problems associated with concurrent
processing with examples. What is the role of locks in
avoiding these problems.
Explain the phantom phenomenon. Devise a time stamp
based protocol that avoids the phantom phenomenon.
C
(5) P.T.O.

12. What do you mean by muitiple granularities ? How it is
implemented in transaction system ?
?x__.
(6) Ncs-snz / 165m;