PRAGATI ENGINEERING COLLEGE

(Autonomous)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Subject :Database Management Systems Year &Sem: II- II

S.
N QUESTION BTL CO
O.
UNIT-I
1 Level-1: Understanding
Explain briefly about 3-tier schema architecture for data
independence.
2 Explain conceptual Design with ER Model. Understanding
3 Level-2: Understanding
What is an ER model? Explain additional features of ER CO1
Model.
4 Explain about the applications of the database. Understanding
5 Level-3: Remembering
Explain about different types data models in detail
6 Explain regarding the Centralized architecture of DBMS Understanding
UNIT-II
1 Level-1: Understanding
Explain all the constraints in relational model along with an
example and simplify their importance.
2 Describe different categories of SQL functions along with Understanding
examples.
3 Level-2: Understanding
Explain the concepts of relational model.
CO2
4 Write different categories of SQL queries using where Applying
clause.
5 Level-3: Applying
Explain about relational algebra and relational calculus with
suitable examples.
6 What is a schema? Define a table using all DDL Commands Applying
along with syntax & examples.
UNIT-III
1 Level-1: Understanding
Explain about different types of functional dependencies
2 Explain about 1NF and 2NF each with an Example. Applying
3 Level-2: Applying
Explain the following and give two examples for each
d)Order by e)Union, Intersect, Except CO3
f)Correlated queries ( EXIST, NOT EXIST)
4 Explain about 3NF and BCNF each with an Example. Applying
5 Level-3: Applying
Demonstrate Lossless Join Decomposition and Dependency
Preserving Decomposition with examples.
 PRAGATI ENGINEERING COLLEGE
(Autonomous)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

6 Create a table and justify whether it is in 4NF or not. Applying

1 Level-1: Understanding
What is meant by file organization? Explain about the
different file organizations.
2 What is an indexing? Explain about single and multi level Understanding
indexing
3 Level-2: Understanding
Explain about Hash indices with an example CO4
4 Explain about hash file organization with an example. Understanding
5 Level-3: Understanding
Explain about the B+tree and the structure of B+tree in
detail with an example
6 Explain the differences between Static Hashing and Understanding
Dynamic Hashing
UNIT-V
1 Level-1: Understanding
What is meant by a)lost updates b)uncommitted data
c) Inconsistent retrievals.
2 What is meant by concurrency control? Explain its locking Understanding
methods.
3 Level-2: Understanding
What is meant by serializability? Explain about Two-phase
CO5
locking for ensuring serializability.
4 What is a Transaction? Explain about ACID properties? Understanding
5 Level-3: Applying
What are the SQL commands for granting and revoking the
permissions to the user groups?
6 What is meant by deadlock? Explain about wait/die and Understanding
wound/wait schemes.

*****