Skip to content
Deadline to Die

02. Relational Design

Overview

This module covers the core concepts of relational database design, focusing on data integrity and normalization.

Topics Covered

  • The Relational Model: Relations, attributes, and domains.
  • ERD Modeling: Entity-Relationship Diagrams, entities, and relationship types (1:1, 1:N, N:M).
  • Normalization: Reducing redundancy with First (1NF), Second (2NF), and Third Normal Form (3NF).
  • BCNF & Denormalization: When to move beyond 3NF or when to deliberately introduce redundancy.