Download Visvesvaraya Technological University (VTU) BE ( Bachelor of Engineering) CSE 2015 Scheme 2020 January Previous Question Paper 5th Sem Database Management System
Fifth Semester B.E. Degree Examination, Dec.201Vriii.
-
2020
Database Management System
Time: 3 hrs. Max. Marks: 80
c..)
.,.-).
Note: Answer any FIVE full questions, choosing ONE full question from each module.
P
E.
-7,
Module-1
1 a. Discuss the main characteristics of the database approach and how it differs from traditional
tu
a
file systems. (08 Marks)
b. Explain the component module of I)13MS and their interactions with the help of neat
4
.?
GO -0
ct diagram. (08 Marks)
c..:-
.-.>
... --
7 `
11
n
II
?-?--
as 2 a.
i) Weak entity type
ii) Degree of a relationship type
i I i) Role names and recursive relationship. (06 Marks)
?
o
-a 5
6
c
u. 0
c.
cz
I
)
3
cr.
3
4
a.
b.
a.
Discuss the different types
basic operations deals with
Explain the data types available
Consider the two tables T
i
of update
constraint
for
and T
,
. Show
T
i
Module-2
relational database.
in SQL.
the following
T,
Explain how the
(08 Marks)
(08 Marks)
operations:
violations.
attribute
operations on
specification
OR
the results of
R A B C
10 a 5 10 b 6
15 b 8 25 c 3
25 a 6 10 b 5
i) T >a
r2
T,
,
Sr. tIO
ii) I><1
T T
12
o
OR
Draw an ER-diagram for AIRLINE database schema with atleast five entity types and
specify primary key and structural constraints and weak entity type. (10 Marks)
Define the following terms:
0 <
. .
0
z
4
E
.
0
a.
iii) T,
T
-1-2A
T
2
iv) T >
v) T
1 p=
(10 Marks)
(06 Marks)
AND 1`
11{
=T
2
0
1.
2
b. Explain Unary relational operations with an example.
1 of 2
FirstRanker.com - FirstRanker's Choice
USN
Fifth Semester B.E. Degree Examination, Dec.201Vriii.
-
2020
Database Management System
Time: 3 hrs. Max. Marks: 80
c..)
.,.-).
Note: Answer any FIVE full questions, choosing ONE full question from each module.
P
E.
-7,
Module-1
1 a. Discuss the main characteristics of the database approach and how it differs from traditional
tu
a
file systems. (08 Marks)
b. Explain the component module of I)13MS and their interactions with the help of neat
4
.?
GO -0
ct diagram. (08 Marks)
c..:-
.-.>
... --
7 `
11
n
II
?-?--
as 2 a.
i) Weak entity type
ii) Degree of a relationship type
i I i) Role names and recursive relationship. (06 Marks)
?
o
-a 5
6
c
u. 0
c.
cz
I
)
3
cr.
3
4
a.
b.
a.
Discuss the different types
basic operations deals with
Explain the data types available
Consider the two tables T
i
of update
constraint
for
and T
,
. Show
T
i
Module-2
relational database.
in SQL.
the following
T,
Explain how the
(08 Marks)
(08 Marks)
operations:
violations.
attribute
operations on
specification
OR
the results of
R A B C
10 a 5 10 b 6
15 b 8 25 c 3
25 a 6 10 b 5
i) T >a
r2
T,
,
Sr. tIO
ii) I><1
T T
12
o
OR
Draw an ER-diagram for AIRLINE database schema with atleast five entity types and
specify primary key and structural constraints and weak entity type. (10 Marks)
Define the following terms:
0 <
. .
0
z
4
E
.
0
a.
iii) T,
T
-1-2A
T
2
iv) T >
v) T
1 p=
(10 Marks)
(06 Marks)
AND 1`
11{
=T
2
0
1.
2
b. Explain Unary relational operations with an example.
1 of 2
Module-3
5 Consider the following schema of order database
SALESMAN (Salesmanid, name, city, commission);
CUSTOMER (Custid, custname, city, grade, salesmanid);
ORDERS (Ordno, purchaseamt, orddate, custid, salesmanid);
Write SQL queries for the following:
i) Find the name and numbers of all salesman who had more than one customer.
ii) Count the customers with grade above Bangalore's average.
iii) List all the salesman details whose first name is 'John'.
iv) List all salesman and indicate those who have and don't have customers in their cities
(Use UNION operation).
v) Use the delete operation by removing salesman with id = 2000. (16 Marks)
OR
6 a. Explain three-tier architecture with neat diagram. (08 Marks)
b. Define stored procedure. Explain creating and calling of stored procedure with an example.
(08 Marks)
Module-4
7 a. Define normal form. Explain INF, 2NF and 3NF with suitable example. (08 Marks)
h. Discuss insertion, deletion and modification anomalies. Why are they considered bad?
Illustrate with example. (08 Marks)
OR
8 a. Explain the four informal guidelines that may be used as measures to determine the quality
of relation schema design. (08 Marks)
b. Write an algorithm for finding a minimal cover 'F' for a set of functional dependencies `E'.
Find the minimal cover for the given set of FD's
G: ?> BCDE, CD ---> E (08 Marks)
Module-5
9 a. Discuss the atomicity, durability, isolation and consistency
database transaction.
b. Why concurrency control is needed demonstrate with example?
preserving properties of a
(08 Marks)
(08 Marks)
OR
10 a. Discuss Two-Phase Locking Technique for concurrency control.
b. Explain NO-UNDO/REDO Recovery based on deferred update.
(10 Marks)
(06 Marks)
2 of 2
FirstRanker.com - FirstRanker's Choice
This post was last modified on 02 March 2020