EXTRA CLASS PRACTICE / Trail Gear: build rehearsal

Trail Gear: prove the build and load

An original Lab 10 rehearsal: inspect a staged import in the browser, then build the same small fictional database with the downloadable SQLite kit. Your official lab uses your own client files.

All database labs Matching lecture Printable handout ↗

Opening your saved work…

Worksheet version 2026-09-09 · Trail Gear: build rehearsal · 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. Get the right tool ready

Open a terminal and confirm sqlite3 starts. Read the official pre-lab and complete its Canvas check. Which commands belong to the SQLite shell rather than the browser SQL editor?

2. Bring the build contract

Have the corrected client ERD, dictionary, CSVs and challenge rules ready. Write the parent-first build order and identify the first file to load. Which required fields and two business rules need constraints?