Overview
What this challenge is about.
Read the current schema dump (PostgreSQL, around 28 tables, heavily denormalized) and the team's 8 most common reporting queries. Produce an entity-relationship diagram from the business domain (clinics, patients, owners, visits, treatments, invoices). Normalize to 3NF; explicitly document the 2-3 deliberate denormalizations for performance. Write a migration plan (DDL (data definition language) + data backfill SQL) and validate that all 8 queries still return identical results. Deliver the ERD, the migration plan, validation evidence, and a 5-page schema-rationale memo.
The Brief
What you'll do, and what you'll demonstrate.
Migrate a denormalized PostgreSQL schema to 3NF with documented exceptions and prove the 8 reporting queries still return identical results.
Earning criteria — what you'll demonstrate
- Reverse-engineer a domain model from a working but messy schema
- Normalize to 3NF and justify deliberate denormalizations
- Write a migration plan with rollback steps
- Validate schema changes against real query results, not just structure
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.