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 — Constraints

Covers the constraint types that enforce relational integrity — primary/candidate/alternate/composite/foreign keys, unique, check, default, and referential integrity.

3 — Relational Algebra

Introduces the relational algebra operators — selection, projection, rename, union, difference, Cartesian product, join, and division — that underpin SQL query semantics.

4 — Relational Calculus

Explains tuple and domain relational calculus, the safety restriction on formulas, and their expressive equivalence with relational algebra.

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.