"Ship a real database."
The seven topic pages teach techniques in isolation. These six cases ask you to integrate them into something a stakeholder would actually use. Each is a business scenario with its own dataset, design document, SQL scripts, and worksheets.
How to use these
Pick the case closest to your group project. Work through the design, run the SQL on Oracle APEX or your Hostinger MySQL instance, complete the worksheet, and present it as if it were the real deliverable. The deliverable is a working database — not a notebook.
The six cases
CASE 1
HealthOne
Medical records DB · MySQL on Hostinger
Querying · Deploy
CASE 2
Planet Fitness
Full database design document
Design · Querying
CASE 3
KathyJane
Full-stack web + database app
Deploy · Emerging
CASE 4
First National Bank
EER design at enterprise scale
Design
CASE 5
Northwind
Classic SQL teaching dataset
Tables · Querying
CASE 6
Prescription Audit
Triggers & audit-trail deep dive
Business Rules
Optional reference
- Database Design — Real-World Case StudyWorked end-to-end design with the trade-offs annotated.
- Web Hosting Consultants HandbookReference for the deployment cases.
- AI Prompt Templates GuideFor accelerating any of the design cases responsibly.