Lab 10: From Paper to Database
Build and load your own client database from the ERD, then reconcile the imported data.
BEFORE THE LAB
1. Prepare for Lab 10
Rehearse a build, then apply it to your client
Six focused topics connect the ERD to staging, exclusions, reconciliation and rebuilding. Browser exercises inspect fictional Trail Gear data; the desktop kit runs the actual build and import. Your class lab uses your own client files.
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 10 Handout: From Paper to Database (PDF, Milestone 3 build rehearsal) ↗
- Lab 10 Handout: From Paper to Database (PDF, Milestone 3 build rehearsal) ↗
- Lab 10 starter (zip: schema_check.sql; your data is your client's files) ↗
- The Five Clients — your client brief ↗
- Project Milestone Checklists ↗
Client project · SQLite shell: 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 10 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.