EXTRA CLASS PRACTICE / North Shore Deliveries

Deliveries: the dispatch desk challenge

A 35–45 minute team practice companion for Lab 4. Repair misleading queries and defend a package timeline using the assigned Deliveries database.

All database labs Matching lecture Printable handout ↗

Opening your saved work…

Worksheet version 2026-09-09 · North Shore Deliveries · Original practice companion; follow Canvas for assigned lab numbering, grades, and deadlines.

Come ready to investigate

Read the lecture, explore a small sample, and bring a question. This preparation does not replace a graded Canvas pre-lab check.

Read the lecture →Try guided practice →

1. Know your evidence

Open Quick schema. What does one row in packages mean, and how does that differ from one row in scans? Which field carries the package ID between them?

2. Predict before running

Read the functions sequence. Predict 7 / 2 versus 7 * 1.0 / 2, and explain why an empty string and NULL need different tests.