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 — Relational Model Fundamentals

Defines the core vocabulary of the relational model — relations, tuples, attributes, domains, keys, degree, cardinality, and NULL semantics.

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.

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.