Year & Sem: II B.

Tech I semester (R20)

Subject: DBMS

Assignment Questions

Bloom’s CO
S.N
Questions Taxonomy
o Attaine
Level
d
UNIT-I
Understandin
1 Level-1: Explain briefly about 3-tier schema architecture for data g
independence. (K2)
Understandin
2 Explain conceptual Design with ER Model. g
(K2)
Understandin
3 Level-2: What is an ER model? Explain additional features of ER Model. g (K2) CO1

4 Explain about the applications of the database. Understandin

g (K2)

5 Understandi
Level-3: Explain about different types data models in detail
ng (K2)
Understandin
6 Explain regarding the Centralized architecture of DBMS
g (K2)

UNIT-II

1 Level-1: Explain all the constraints in relational model along with an Understandin
example and simplify their importance. g (K2)
Understandi
2 Describe different categories of SQL functions along with examples.
ng (K2)

3 Understandin
Level-2: Explain the concepts of relational model. g (K2) CO2
4 Applying
Write different categories of SQL queries using where clause. (K3)

5 Level-3: Explain about relational algebra and relational calculus with suitable Applying
examples. (K3)

6 What is a schema? Define a table using all DDL Commands along with Applying
syntax & examples. (K3)
 PRAGATI ENGINEERING COLLEGE
(Autonomous)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Bloom’s
Taxono CO
S. my
Questions Attain
No Lev ed
el
UNIT-III
Understand
1 Level-1: What is meant by file organization? Explain about the different
file organizations ing (K2)

2 What is an indexing? Explain about single and multi level indexing

Understandin
g (K2)
Level-2:
Understandin
3 g (K2)
Explain about Hash indices with an example CO3
Understandin
4 Explain about hash file organization with an example. g (K2)

Level-3: Understandin
5 g (K2)
Explain about the B+tree and the structure of B+tree in detail with an
example
Understandin
6 Explain the differences between Static Hashing and Dynamic Hashing g (K2)

UNIT-IV

1 Level-1: Explain about different types of functional dependencies and read Applying (K3)
about kesava?
CO4

2 Explain about 1NF and 2NF each with an Example Applying (K3)

3 Level-2: Explain the following and give two examples for each d)Order by Applying (K3)
e)Union, Intersect, Except f)Correlated queries ( EXIST, NOT EXIST)

4 Explain about 3NF and BCNF each with an Example Applying (K3)

5 Level-3: Demonstrate Lossless Join Decomposition and Dependency Applying (K3)

Preserving Decomposition with examples.

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

2
 PRAGATI ENGINEERING COLLEGE
(Autonomous)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Bloom’s
CO
S.N Question Taxono
Attain
o my
ed
Lev
el
UNIT-V
1 Level-1: What is meant by a)lost updates b)uncommitted data c)
Understandin
Inconsistent retrievals. g
(K2)
2 What is meant by concurrency control? Explain its locking methods. Understandin
g
(K2)
3 Level-2: What is meant by serializability? Explain about Two-phase
Understandin CO5
locking for ensuring serializability. g (K2)
4 What is a Transaction? Explain about ACID properties?
Understandin
g (K2)
5 Level-3: What are the SQL commands for granting and revoking the Applying
permissions to the user groups? (K3)
6 What is meant by deadlock? Explain about wait/die and wound/wait Understandin
schemes. g (K2)