Overview
What this challenge is about.
Normalize a vet-clinic SaaS schema to 3NF and validate 8 reporting queries to earn your verifiable certificate.
CredentialBlockchain-anchored
ShareableLinkedIn-ready
LanguageEnglish
PaceSelf-paced
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.