Final Assessmentexamadvanced
Final Work Session 2
Second independent work session: DML and INSERT section of the final assignment.
Overview
Students continue the final assignment, focusing on the DML section: writing rerunable INSERT scripts for the designed schema. The instructor circulates for targeted support.
Lesson Plan
| Time | Activity |
|---|---|
| 0–5 min | Progress check: DDL status, open questions |
| 5–70 min | Independent work: INSERT / DML section |
| 70–80 min | Checkpoint: instructor reviews INSERT section |
Key Concepts
- Building INSERT scripts based on the schema created in session 1
- Resolving FKs dynamically — no hardcoded IDs
- Idempotency: ON CONFLICT or existence checks
- Correct insert order following FK dependency chain
- Testing the script on a clean copy of the schema
✏️Practice
Students complete tasks independently.