Redesign a Vet-Clinic SaaS Database to Third Normal Form
Overview
What this challenge is about.
Normalize a vet-clinic database to 3NF, design an ERD, write a reversible SQL migration, and verify all queries match. Earn a verifiable certificate.
The scenario
VetLedger is a profitable but lean veterinary-software company in Portland whose product handles scheduling, medical records, and billing for hundreds of small-animal clinics. Its database was assembled quickly by an outside contractor and has never been formally modeled, so reporting is slow and risky to change.
The Brief
What you'll do, and what you'll demonstrate.
Redesign VetLedger's denormalized PostgreSQL database to third normal form with documented performance exceptions, and prove that the team's eight key reports still return identical results.
Earning criteria — what you'll demonstrate
- Translate a messy real-world database dump into a clean entity-relationship model of the business domain
- Apply third normal form rigorously while justifying intentional exceptions for performance
- Sequence data-definition and backfill steps into a safe, reversible migration
- Prove behavioral equivalence by validating query outputs before and after a schema change
- Communicate technical design decisions to a non-specialist founder in a concise written rationale
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Aligned coursework coming soon.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
- Data Modeling
Apply data modeling to solve real industry problems and demonstrate production-level capability.
- Normalization
Apply normalization to solve real industry problems and demonstrate production-level capability.
- Sql
Query, transform, and analyze relational data to extract meaningful business insights.
- Postgresql
Apply postgresql to solve real industry problems and demonstrate production-level capability.
- Migrations
Apply migrations to solve real industry problems and demonstrate production-level capability.
- Query Validation
Apply query validation to solve real industry problems and demonstrate production-level capability.
Careers
Career paths this challenge builds toward
Completing this challenge demonstrates skills that transfer directly to these roles:
Database Administrator
Designing a normalized schema and a safe, reversible migration for a live billing system mirrors the core daily work of a database administrator: protecting data integrity while evolving a production database without downtime or report regressions.
This challenge sharpens
- normalization
- migrations
- postgresql
Data Engineer
Modeling entities and validating that downstream reports stay correct after a structural change is exactly the discipline data engineers apply when refactoring pipelines and warehouses, where silent output drift is the costliest failure.
This challenge sharpens
- data-modeling
- sql
- query-validation
Backend Engineer
Backend engineers constantly reshape schemas behind running services; this challenge builds the habit of sequencing migrations safely and proving behavior is unchanged before shipping a database change.
This challenge sharpens
- sql
- migrations
- data-modeling