DBMS · CS Fundamentals
DBMS Notes for Interviews
The DBMS topics that come up most in interviews are normalization (1NF through BCNF), ACID transactions, indexing (especially why B+ trees beat balanced BSTs for disk-backed indexes), and crash recovery. Interviewers increasingly ask you to spot a normalization violation or debug an anomaly in a real schema rather than just define a normal form — Ediky's DBMS question bank is built around exactly that scenario/debugging style.
What to actually study
- Normalization (1NF-BCNF) — recognizing violations in a real schema, not reciting definitions
- ACID properties and how atomicity/durability are actually implemented (write-ahead logging)
- Indexing — why B+ trees, not balanced BSTs, back disk indexes
- Transactions & concurrency control — locking, isolation levels, and where they break
- Crash recovery — reconstructing state from a log after a failure
Real questions from Ediky's DBMS bank
These are actual question titles from Ediky's CS Fundamentals bank, not invented examples — the style is deliberately scenario-driven:
- "Spot the 1NF Violation in a Candidate Skills Table"
- "Debug a Deletion Anomaly Caused by a Transitive Dependency"
- "Reconstructing a Crashed Ledger Engine's Recovery Path"
- "Why Disk Indexes Use B+ Trees Instead of Balanced Binary Search Trees"
Two ways to study on Ediky
For structured, lecture-by-lecture learning, Ediky's DBMS video course has 22 lectures from ER modeling through SQL, normalization, and transactions. For active recall once you've covered the material, the 65-question DBMS bank in CS Fundamentals is scenario and debugging style, AI-evaluated — closer to how DBMS actually gets asked in interviews than flashcard-style MCQs.
Practice DBMS scenario questions
65 DBMS questions in Ediky's CS Fundamentals bank, AI-evaluated, scenario and debugging style.
Open CS Fundamentals