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.

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.