Assignment 1
Database Design and SQL Query Processing
1) Explain the three levels of DBMS architecture with a neat
diagram.
2) Draw and explain an E-R diagram for any real-life example and
convert it into relational tables.
3) What is Normalization? Explain 1NF, 2NF, and 3NF with
examples.
4) Explain different types of keys and referential integrity
constraints with examples.
5) Write and explain SQL commands for DDL, DML, and Joins
with examples.
Assignment 2
Transaction and Concurrency Control
1) Explain the ACID properties of a transaction with suitable
examples.
2) Explain different states of a transaction with a neat state
diagram.
3) What is concurrency control? Explain the problems caused by
concurrent transactions.
4) Explain Lock-based and Timestamp-based Concurrency Control
Protocols.
5) What is Deadlock in DBMS? Explain deadlock handling
methods.
Assignment 3
Database Recovery and Security Techniques
1) Explain different types of failures in DBMS with examples.
2) What is Log-Based Recovery? Explain Deferred and Immediate
Database Modification techniques.
3) Explain Checkpoints and Shadow Paging in database recovery.
4) What are the different types of Database Backups? Explain the
steps to create a backup plan.
5) Explain Database Security techniques and types of Access
Control.
Assignment 4
Parallel and Distributed Database
1) Explain different architectures of Parallel Database Systems.
2) What is Distributed Database System? Explain its architecture
and key characteristics.
3) Explain Fragmentation, Replication, and Transparency in
Distributed Data Storage.
4) What is Query Processing in DDBMS? Explain query
decomposition and localization of data.
5) Explain Transaction Management and Commit Protocols (2-
Phase and 3-Phase Commit) in DDBMS.
Assignment 5
NOSQL database for Business Applications
1) What is NoSQL Database? Explain its types with examples.
2) Explain the features and advantages of MongoDB.
3) What is JSON? Explain its structure with a suitable example.
4) Explain different types of NoSQL Databases with suitable
business applications.
5) What is Firebase? Explain its features and uses as a NoSQL
database platform.