Loading Depth Study
Preparing your workspace
Database design defines how data is organized, while normalization reduces unnecessary duplication and migrations provide a controlled way to change database structure.
Good database design starts by identifying entities, relationships, fields, and rules. Normalization is a set of design principles that helps reduce problematic duplication and update inconsistencies. As software evolves, tables and constraints also need to change. Database migrations make those schema changes explicit, repeatable, and trackable across development and production environments.
A learning platform may start with users and courses, then later add enrollments, organizations, and progress tables through ordered migrations.
-- Migration: add a published column ALTER TABLE courses ADD COLUMN published boolean NOT NULL DEFAULT false; -- Later migration: CREATE INDEX idx_courses_published ON courses(published);
Database structure evolves through explicit migration steps that can be tracked and applied consistently.