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.
Open project workspace
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.
| Step | Deliverable |
|---|---|
| S01 | Profile |
| S02 | Repair plan |
| S03 | Deduplication |
| S04 | Orphan and range repair |
| S05 | Constraint hardening |
| S06 | Idempotent upsert |
| S07 | Transaction and failure proof |
| S08 | 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.