DBMS
32 articles in this topic
Basics of DBMS: Full Concept Set with Worked Examples for GATE and Interviews
Connect the core DBMS ideas through concrete tables: why databases beat files, how keys and normalization work, how ER designs become relations, and how ACID protects a bank transfer.
Keys and Integrity Constraints in DBMS: Types, Rules and Worked Examples
Learn how superkeys, candidate keys, primary keys, foreign keys and integrity rules work together through one university database and a complete closure proof.
Concurrency Control in DBMS: Anomalies, Serializability, Locking and 2PL with Worked Examples
Connect the full DBMS concurrency-control chain through one precedence-graph schedule, strict 2PL examples, timestamp rules and recovery checks.
Big Data Systems for GATE CS: CAP Theorem, Sharding and MapReduce with Worked Examples
See what changes when a database spreads across machines. Build a clear mental model of shards, replicas, CAP choices, quorums, MapReduce and NoSQL.
Transaction Management in DBMS: ACID, Serializability, Locking and Recovery
Learn to trace DBMS transactions from operation sequences to precedence graphs, recovery rules, lock protocols, timestamp checks, and crash handling.
Relational Algebra in DBMS: Complete Guide with Worked Queries
Learn relational algebra by tracing selection, projection, set operations, joins, and division through one small university database with exact outputs.
DBMS Normalization from 1NF to BCNF: One Complete Worked Example
Follow one university-registration relation from a repeating group to BCNF. Compute both candidate keys, remove each dependency violation, and test the final split.
SQL in DBMS: Complete Guide with Queries, Joins and Worked Results
Learn SQL by following one college database from table creation to joins, aggregates, subqueries, and transactions. Every worked query includes the rows you should predict.
Relational Model and Functional Dependencies in DBMS: Keys, Closure and Minimal Cover
Build keys, closures and a minimal cover from one seven-attribute enrolment relation. Then use the same dependencies to explain redundancy and decomposition.
ER Diagram in DBMS: Complete Guide with Worked Examples for GATE and Interviews
Learn to read a crowded ER diagram, reduce it to the minimum relational tables, and avoid the weak-entity, multivalued-attribute, and relationship traps that change the answer.
Decomposition in DBMS: Lossless Join, Dependency Preservation and 4NF with Worked Examples
Learn the two decomposition checks through concrete joins, attribute closures, the 3NF and BCNF trade-off, and a worked 4NF example.
Database Recovery in DBMS: Log-Based Recovery, Checkpoints, and a Fully Worked Crash Example
Learn how logs, WAL, checkpoints, undo, and redo restore a DBMS after failure. Then replay a complete crash log to find the final values of A, B, and C.