Capstone project
Organization Data Repair and Schema Hardening
Profile defects, repair state safely, add integrity rules, and demonstrate idempotent import. This public brief explains the scenario, deliverables, dataset, assessed skills, and guided-versus-independent expectations without revealing the full solution.
Scenario and deliverables
Profile defects, repair state safely, add integrity rules, and demonstrate idempotent import.
The project expects SQL, assumptions, bounded result snapshots, validation checks, and a local report export.
Milestones
Each milestone is graded as an activity and contributes to project evidence only after independent or transfer validation.
Result preview8 rows
| Step | Deliverable |
|---|---|
| Project step 1 | Profile |
| Project step 2 | Repair plan |
| Project step 3 | Deduplication |
| Project step 4 | Orphan and range repair |
| Project step 5 | Constraint hardening |
| Project step 6 | Idempotent upsert |
| Project step 7 | Transaction and failure proof |
| Project step 8 | Engineering report |
Dataset, prerequisites, and workspace
The public brief describes the work; the app workspace provides the editor, dataset, hints, checker, and final export tools.
Page highlights
- Public project brief
- Milestone rubric summary
- Canonical dataset and prerequisite links to original SQL Trail assets
- Report-export expectation