Lab 13: The Inherited Schema
Audit the inherited ticket-sales sheet, normalize it, migrate the data, and prove that nothing was lost.
BEFORE THE LAB
1. Prepare for Lab 13
DURING THE LAB
2. Use the official questions and data
The handout contains the complete questions, required column names, findings, and report instructions. Keep its question numbers in your report.
- Lab 13 Handout: The Inherited Schema (PDF) ↗
- Week 13 database (inherited.db) ↗
- The Five Clients — your client brief ↗
- Project Milestone Checklists ↗
Desktop SQLite · Normalization: follow the handout in the assigned tool using the Canvas files above.
Keep your SQL as text, your result evidence, and your explanation together. Complete the handout’s client task and personal reflections where assigned.
AFTER THE LAB
3. Submit your own lab report
You may work with others as the handout permits, but each person submits their own report. Use the official report template and check the assignment for the current deadline and requirements.
Submit Lab 13 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.