Database Management Systems

A book-shaped table of contents for DBMS: relational foundations through SQL mastery, storage internals, transactions, distributed databases, NoSQL, and MAANG interview prep — cross-linking existing system-design/patterns notes instead of duplicating them.

1 — ER Modeling

Covers entity-relationship modeling — entities, attributes, relationships, weak entities, cardinality, participation constraints, and ISA hierarchies.

3 — Functional Dependencies

Covers trivial and non-trivial functional dependencies, closure, attribute closure, and computing a minimal cover.

4 — Normalization

Walks through the normal forms — 1NF through 5NF and Domain-Key Normal Form — and the anomalies each eliminates.

5 — Denormalization

Covers why and when to denormalize, the read/write tradeoffs involved, and practical scenarios where it pays off.