// subject deep-dive
Database Management Systems
Master relational modeling, SQL, normalization, and transaction management.
📊 Average Weightage: 7–8 Marks (3–4 Questions)
Relational Model & SQL
ER-model, relational algebra operations (select, project, join), and DDL/DML SQL queries.
Normalization
Functional dependencies and normal forms from 1NF to BCNF for efficient database design.
Transactions & Concurrency
ACID properties, transaction states, and concurrency control using lock-based protocols.
Storage & Indexing
File organization techniques and indexing structures like B-Trees and B+ Trees.
💡
High-Yield Topics
Normalization (specifically BCNF and 3NF) and Transaction management (ACID properties and locking) are highly frequent topics.