DBMS Mid -II important Questions

1) Expalin about various constraints in ER-model?

2) Differentiate between specialization and generalization with ER-diagram.

3) Define Normalization?Explain 1NF,2NF,3NF with examples.

4) Define Funtion dependency?And explain it’s types with examples?

5) Explain different types of locks used in Concurrecy Control.

6) Construct B+ tree with the elements of 2,4,7,10,17,21,28?

7) Explain about the serializability concept?

8) Define 2PL? Explain the concept of 2PL?

9) Describe about the multilevel indexing with examples?

DBMS MATERIAL

UNIT- III

Entity Relationship Model ---[ Download ]

UNIT - IV

Normalization ---[ Download ]

UNIT - V

Transaction Management & Indexing---[ Download ]

DBMS IMPORTANT QUESTION ( UNITS 3,4 & 5 )

---[ Download ] ---

Lab Experiments

5 [Download] | 6 [Download] | 8 [Download] | 9 [Download]

DBMS Lab (List of Experiments)

---[ Download ] ---

Download