(Page 1 of 2)
USN 22CSU403
B. E. Degree (Autonomous) Fourth Semester End Examination (SEE)
DATABASE MANAGEMENT SYSTEMS
(Model Question Paper – II)
Time: 3 Hours] [Maximum Marks: 100
Instructions to students:
Answer FIVE FULL questions
RBT
[Link]. Questions Marks CO Cognitive
Level
Explain the self-describing nature of a database system in
a) 7 CO1 L3
detail.
1. Discuss constraints on binary relationship types in detail by
b) 7 CO1 L2
considering an example.
c) Describe Weak Entity types in detail. 6 CO1 L2
OR
Explain support of multiple views of the data, sharing of data
a) 6 CO1 L3
and multiuser transaction processing in database systems.
Explain relationship degree, role names, and recursive
2. b) 7 CO1 L3
relationships in detail by considering examples.
Illustrate the main phases of database design with a neat
c) 7 CO1 L2
diagram.
Discuss JOIN operation along with variations of JOIN
a) 10 CO1 L2
operations by considering suitable examples.
With examples, describe the DELETE operations by
3. b) 5 CO1 L3
considering referential integrity.
Discuss DIVISION operation by considering an example in
c) 5 CO1 L2
detail.
OR
Discuss entity integrity, referential integrity and foreign keys
a) 7 CO1 L2
in detail by considering suitable examples.
Explain PROJECT Unary relational operation in detail by
4. b) 7 CO1 L3
considering suitable examples.
Explain SELECT Unary relational operation in detail by
c) 6 CO1 L3
considering suitable examples.
Dr. Ambedkar Institute of Technology, Bengaluru – 560056
(An Autonomous Institution Affiliated to Visvesvaraya Technological University, Belgaum)
(Page 2 of 2)
Consider the below relational schema
a) 8 CO2 L3
Write the queries for below in SQL
a) Make a list of all project numbers for projects that
5. involve an employee whose last name is ‘Smith’,
either as a worker or as a manager of the department
that controls the project.
b) Retrieve all employees whose address is in Houston,
Texas.
c) Show the resulting salaries if every employee
working on the ‘ProductX’ project is given a 10%
raise.
d) Retrieve all employees in department 5 whose salary
is between $30,000 and $40,000.
Consider the relational schema given in the previous
question and write the queries for below in SQL.
a) Retrieve the Social Security numbers of all
employees who work on project numbers 1, 2, or 3.
b) Find the sum of the salaries of all employees, the
b) 8 CO2 L3
maximum salary, the minimum salary, and the
average salary.
c) Find the sum of the salaries of all employees, the
maximum salary, the minimum salary, and the
average salary.
Discuss the basic data types available for attributes in
c) 4 CO2 L2
database systems with examples.
OR
Explain how constraints are specified as Assertions in SQL
a) 10 CO2 L3
with appropriate examples.
6.
b) Explain the need for triggers in SQL in detail. 10 CO2 L3
Dr. Ambedkar Institute of Technology, Bengaluru – 560056
(An Autonomous Institution Affiliated to Visvesvaraya Technological University, Belgaum)
(Page 3 of 2)
Discuss nonadditive (Lossless) join property of a
a) 10 CO3 L2
decomposition in database systems.
7. Examine general definitions for second normal form (2NF)
b) and third normal form (3NF) in designing relation schema by 10 CO3 L3
considering suitable examples.
OR
Discuss the need for normalization of relations in database
a) 7 CO3 L2
systems.
8. b) Examine join dependency and fifth normal form in detail. 7 CO3 L3
Explain dependency preservation property of a
c) 6 CO3 L3
decomposition in database systems.
Discuss view equivalence and view serializability in
a) 10 CO4 L2
database systems.
9.
Explain the algorithm for testing conflict serializability of a
b) 10 CO4 L3
schedule.
OR
Discuss how deadlock and starvation is dealt in database
a) 10 CO4 L2
systems.
10.
Explain binary locks for concurrency control in database
b) 10 CO4 L3
systems.
******
Dr. Ambedkar Institute of Technology, Bengaluru – 560056
(An Autonomous Institution Affiliated to Visvesvaraya Technological University, Belgaum)