First Normal Form: One Value per Cell
Lessons in this course
- The Flat-Sheet Problem: Counting Copies & ConflictsFree
- Entities & Attributes: Sorting Columns into Tables Locked
- Candidate Keys: Which Columns Identify a Row? Locked
- Functional Dependencies: Does A Determine B? Locked
- First Normal Form: One Value per Cell Locked
- Second Normal Form: Facts That Depend on Part of the Key Locked
- Third Normal Form: Course → Level → Price Locked
- Update, Insert & Delete Anomalies in a Flat Sheet Locked
- Surrogate vs Natural Keys: Ids and a Mapping Table Locked
- Junction Tables: Students × Courses Locked
- Referential Checks: Orphan Keys and Money at Stake Locked
- Cardinality: One-to-Many or Many-to-Many? Locked
- Rebuilding the Report: Joins That Reconcile Locked
- Redundancy Compared: Stored Cells Before and After Locked
- Effective Dates: The Right Price on the Booking Date Locked
- Code Tables & Validation: Allowed Values Only Locked
- When to Flatten Again: A Reporting View by Numbers Locked
- Data Quality After the Redesign: Duplicates & Blank Keys Locked
- Migration Checks: Row Counts & Control Totals Locked
- Final Project: The Schema Scorecard Locked