# Dbms
All Dbms notes →1 — ER Modeling
Covers entity-relationship modeling — entities, attributes, relationships, weak entities, cardinality, participation constraints, and ISA hierarchies.
dbms database-design book
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.
dbms database-design book
3 — Functional Dependencies
Covers trivial and non-trivial functional dependencies, closure, attribute closure, and computing a minimal cover.
dbms database-design book
4 — Normalization
Walks through the normal forms — 1NF through 5NF and Domain-Key Normal Form — and the anomalies each eliminates.
dbms database-design book
5 — Denormalization
Covers why and when to denormalize, the read/write tradeoffs involved, and practical scenarios where it pays off.
dbms database-design book