Download VTU BE 2020 Jan CSE Question Paper 15 Scheme 5th Sem Database Management System

USN
Fifth Semester B.E. Degree Examination, Dec.201Vriii.
-
2020
Database Management System

--- Content provided by FirstRanker.com ---

Time: 3 hrs. Max. Marks: 80
c..)
.,.-).
Note: Answer any FIVE full questions, choosing ONE full question from each module.
P

--- Content provided by FirstRanker.com ---

E.
-7,
Module-1
1 a. Discuss the main characteristics of the database approach and how it differs from traditional
tu

--- Content provided by FirstRanker.com ---

a
file systems. (08 Marks)
b. Explain the component module of I)13MS and their interactions with the help of neat
4
.?

--- Content provided by FirstRanker.com ---

GO -0
ct diagram. (08 Marks)
c..:-
.-.>
... --

--- Content provided by FirstRanker.com ---

7 `
11

n
II

--- Content provided by FirstRanker.com ---

?-?--

as 2 a.
i) Weak entity type
ii) Degree of a relationship type

--- Content provided by FirstRanker.com ---

i I i) Role names and recursive relationship. (06 Marks)
?
o
-a 5
6

--- Content provided by FirstRanker.com ---

c
u. 0
c.
cz
I

--- Content provided by FirstRanker.com ---

)
3
cr.
3
4

--- Content provided by FirstRanker.com ---

a.
b.
a.
Discuss the different types
basic operations deals with

--- Content provided by FirstRanker.com ---

Explain the data types available
Consider the two tables T
i

of update

--- Content provided by FirstRanker.com ---

constraint
for
and T
,
. Show

--- Content provided by FirstRanker.com ---

T
i

Module-2
relational database.

--- Content provided by FirstRanker.com ---

in SQL.
the following
T,
Explain how the
(08 Marks)

--- Content provided by FirstRanker.com ---

(08 Marks)
operations:
violations.
attribute
operations on

--- Content provided by FirstRanker.com ---

specification
OR
the results of
R A B C
10 a 5 10 b 6

--- Content provided by FirstRanker.com ---

15 b 8 25 c 3
25 a 6 10 b 5
i) T >a
r2
T,

--- Content provided by FirstRanker.com ---

,
Sr. tIO
ii) I><1
T T
12

--- Content provided by FirstRanker.com ---

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:

--- Content provided by FirstRanker.com ---

0 <
. .
0
z
4

--- Content provided by FirstRanker.com ---

E
.

0
a.

--- Content provided by FirstRanker.com ---

iii) T,
T
-1-2A
T
2

--- Content provided by FirstRanker.com ---

iv) T >zll
v) T
1 p=

(10 Marks)

--- Content provided by FirstRanker.com ---

(06 Marks)
AND 1`
11{
=T
2

--- Content provided by FirstRanker.com ---

0
1.
2
b. Explain Unary relational operations with an example.
1 of 2

--- Content provided by FirstRanker.com ---

FirstRanker.com - FirstRanker's Choice
USN
Fifth Semester B.E. Degree Examination, Dec.201Vriii.
-
2020

--- Content provided by FirstRanker.com ---

Database Management System
Time: 3 hrs. Max. Marks: 80
c..)
.,.-).
Note: Answer any FIVE full questions, choosing ONE full question from each module.

--- Content provided by FirstRanker.com ---

P
E.
-7,
Module-1
1 a. Discuss the main characteristics of the database approach and how it differs from traditional

--- Content provided by FirstRanker.com ---

tu
a
file systems. (08 Marks)
b. Explain the component module of I)13MS and their interactions with the help of neat
4

--- Content provided by FirstRanker.com ---

.?
GO -0
ct diagram. (08 Marks)
c..:-
.-.>

--- Content provided by FirstRanker.com ---

... --
7 `
11

n

--- Content provided by FirstRanker.com ---

II
?-?--

as 2 a.
i) Weak entity type

--- Content provided by FirstRanker.com ---

ii) Degree of a relationship type
i I i) Role names and recursive relationship. (06 Marks)
?
o
-a 5

--- Content provided by FirstRanker.com ---

6
c
u. 0
c.
cz

--- Content provided by FirstRanker.com ---

I
)
3
cr.
3

--- Content provided by FirstRanker.com ---

4
a.
b.
a.
Discuss the different types

--- Content provided by FirstRanker.com ---

basic operations deals with
Explain the data types available
Consider the two tables T
i

--- Content provided by FirstRanker.com ---

of update
constraint
for
and T
,

--- Content provided by FirstRanker.com ---

. Show
T
i

Module-2

--- Content provided by FirstRanker.com ---

relational database.
in SQL.
the following
T,
Explain how the

--- Content provided by FirstRanker.com ---

(08 Marks)
(08 Marks)
operations:
violations.
attribute

--- Content provided by FirstRanker.com ---

operations on
specification
OR
the results of
R A B C

--- Content provided by FirstRanker.com ---

10 a 5 10 b 6
15 b 8 25 c 3
25 a 6 10 b 5
i) T >a
r2

--- Content provided by FirstRanker.com ---

T,
,
Sr. tIO
ii) I><1
T T

--- Content provided by FirstRanker.com ---

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)

--- Content provided by FirstRanker.com ---

Define the following terms:
0 <
. .
0
z

--- Content provided by FirstRanker.com ---

4
E
.

0

--- Content provided by FirstRanker.com ---

a.
iii) T,
T
-1-2A
T

--- Content provided by FirstRanker.com ---

2
iv) T >zll
v) T
1 p=

--- Content provided by FirstRanker.com ---

(10 Marks)
(06 Marks)
AND 1`
11{
=T

--- Content provided by FirstRanker.com ---

2
0
1.
2
b. Explain Unary relational operations with an example.

--- Content provided by FirstRanker.com ---

1 of 2
Module-3
5 Consider the following schema of order database
SALESMAN (Salesmanid, name, city, commission);
CUSTOMER (Custid, custname, city, grade, salesmanid);

--- Content provided by FirstRanker.com ---

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'.

--- Content provided by FirstRanker.com ---

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)

--- Content provided by FirstRanker.com ---

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?

--- Content provided by FirstRanker.com ---

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'.

--- Content provided by FirstRanker.com ---

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.

--- Content provided by FirstRanker.com ---

b. Why concurrency control is needed demonstrate with example?
preserving properties of a
(08 Marks)
(08 Marks)
OR

--- Content provided by FirstRanker.com ---

10 a. Discuss Two-Phase Locking Technique for concurrency control.
b. Explain NO-UNDO/REDO Recovery based on deferred update.
(10 Marks)
(06 Marks)

--- Content provided by FirstRanker.com ---

2 of 2
FirstRanker.com - FirstRanker's Choice