Relational Data Design by Hand: Flat Tables to Normal Forms, Keys, Functional Dependencies, Update Anomalies, Lookup & Junction Tables, Referential Checks and Reporting Views
Turn a fictional language school's flat booking sheet into clean related tables in 20 hands-on labs: redundancy counts, keys, dependencies, normal forms, anomalies, junction tables, orphan checks, rebuilt reports and migration checks, with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on labs you redesign a fictional language school's flat booking sheet in a spreadsheet. You count redundant cells and conflicting copies, sort attributes into entities, test candidate keys and functional dependencies with COUNTIFS, and split tables into first, second and third normal form. You count update, insert and delete anomalies, build surrogate keys and junction tables, find orphan foreign keys, classify cardinality and rebuild a reporting view with joins that reconcile to the old sheet. Then you handle dated prices, code tables and validation, score when a flattened view pays off, and finish with migration checks and a schema scorecard.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
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
Learner reviews
Be the first to review this course.