Download AKTU B-Tech 4th Sem 2014-15 Database Management Systems Question Paper

Download AKTU (Dr. A.P.J. Abdul Kalam Technical University (AKTU), formerly Uttar Pradesh Technical University (UPTU) B-Tech 4th Semester (Fourth Semester) 2014-15 Database Management Systems Question Paper

Printed Pages : 3
lllllljlllljlllllllllllll!||||j|lH!l| Rem
(Folluwing Paper ID and Roll N o. to be ?lled in your Answer Book)
PAPER ID : 110406
Roll N 0.
B. Tech.
(813M. 1V) THEORY EXAMINATION, 2014?15
DATABASE MANAGEMENT SYSTEMS
Time : 3 Hours] [Total Marks : 100
Note: 1. Attempt all question.
2. A11 question carry equal marks.
1 Attempt any FOUR questions. 5:14:20
31. Explain the differences between Database
Management System and File System.
b. Draw the overall structure of DBMS and explain
its various components.
What, is data abstraction? Explain di?crent levels
of abstraction.
0
(1. Explain constraints and its types.
What. are data models? Brie?y explain different
types of data models.
ff;
f. Who are data administrators? What are the
functions of database administrator?
110406 1] 1 [(rontd...

2 Attempt any FOUR questions" 5I*?4??20
a.
b. What are the design issues of Entity- Relationship
diagram?
c. What is Uni?ed Modeling Language? Explain
different types of UML.
d. Construct an E?R diagram for a hospital With a
set of patients and a set of medical doctors.
Associate with each patient a log of the various
' tests and examinations conducted.
e. Discuss the candidate key, primary key, super
key, composite key and alternate key.
f. De?ne join. Explain di??erent types of joins.
3 Attempt any TWO questions 10-2?20
:1. Explain Tuple Relational Calculus and Domain
Relational Calculus _.
b. Explain various characteristics of SQL? Discuss
?ve aggregate ?Jnctions with suitable example.
0. What is functional dependency? Explain trivial
and non-trivial functional dependency. De?ne
canonical cover. Compute canonical cover for the
following:
R: (A, B, C.) F*- {A ?> BC, B ?) C,
A?)B, AB ?)C}
4 Attempt any TWO questions 10 ?2?20
21. What do you mean by Normalization? Explain
BCNF and 3NF with a suitable example.
b. What do you mean by Locking techniques of
110406 ]
Explain Generalization, Specialization and
Aggregation.
concurrency control? Discuss the various locking
techniques and recovery with concurrent
transaction also in detail.
2 [ Contd...
c. Explain time based protocol and validation based
protocol with example.
5 Attempt any TWO question. 10XZ=20
a. What is serializability? Explain view serializability
and con?ict serializability.
b. List the ACID properties. Explain the usefulness
of each property.
0. What is dead lock ? How it can be detected
and avoided ?
110406] ? 3 [ 2675 ]