Redesign a Vet-Clinic SaaS Database to Third Normal Form
Overview
What this challenge is about.
Redesign a Vet-Clinic SaaS Database to Third Normal Form. Beginner-friendly challenge in design. Designing real products under real constraints, earn a block...
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.
This is not a design exercise. It is the work a product designer does between a brief and a shipped interface. That distinction matters to every hiring manager who has seen candidates redesign Spotify's homepage and none who have worked under real product constraints.
When you finish, you will have something most graduates do not: a real-world deliverable, verified by Ewance, that you can show to a hiring manager and say "I did this. Here is the proof."
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