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.

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.

5 — Denormalization

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