Lab 7: Exam 1 Review Lab
Rehearse Exam 1 with a closed-laptop paper section, followed by SQL and schema design on the Marathon data.
BEFORE THE LAB
1. Prepare for Lab 7
Use the Exam 1 study guide and review set; Part A is completed on paper.
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 7 Handout: Exam 1 Review Lab (PDF, Part A on paper) ↗
- Week 7 database (grandmas_marathon.db, same file as Week 3) ↗
Grandma’s Marathon
The assigned teaching database is ready in the browser. Quick schema shows its tables and columns; signed-in, approved students can save SQL drafts to their account. Wait for the saved indicator before leaving; guests keep drafts on this device.
Open this only after the closed-laptop paper section. Complete the CREATE TABLE work in your assigned SQLite environment.
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 7 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.