Core goals, terminology, and why good design matters for data integrity and performance.
Entities, attributes, keys, and relationships—the building blocks of a schema.
Eliminate redundancy and enforce data consistency through normal forms.
OLTP vs OLAP, relational vs non-relational, and when to use each.
From requirements to a practical schema with tables, keys, and constraints.
Primary keys, foreign keys, unique constraints, and cascade actions.
How indexes improve queries and how to design them effectively.