The Flat-Sheet Problem: Counting Copies & Conflicts
All lessons
- 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
You are not signed in — the lab works, but your progress is not saved. Sign up
✓ Lesson 1 complete
You finished 1 of 20 labs
Keep going with Relational Data Design by Hand: Flat Tables to Normal Forms, Keys, Functional Dependencies, Update Anomalies, Lookup & Junction Tables, Referential Checks and Reporting Views: 19 more hands-on labs, the final exam and your certificate.
Continue for $9.90One-time payment, no subscription.
Loading the spreadsheet…