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.

2 — Mapping ER to Relational Model

Covers the rules for translating an ER diagram's entities, relationships, weak entities, and ISA hierarchies into relational tables.

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.