Lab 4: The Deliveries Investigation
Clean records and reconstruct a delivery investigation using SQL string, numeric, date, and NULL functions.
BEFORE THE LAB
1. Prepare for Lab 4
Learn the functions, then investigate
Work through the seven reading topics and their guided checks. Use the team challenge as a warm-up; then return to the official lab questions.
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 4 Handout: The Deliveries Investigation (PDF) ↗
- Week 4 database (deliveries.db) ↗
- Lab 4 ERD Diagram: deliveries database (PDF) ↗
North Shore Deliveries
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.
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 4 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.