Final Assessmentdefenseadvanced
Final Defense (Session 1)
First session of the final oral defense — students present and explain their SQL assignments.
Overview
The first defence session. Half the class presents their final assignments to the instructor individually. Each student runs their scripts live, explains design choices, and answers questions from the grading rubric.
Lesson Plan
| Time | Activity |
|---|---|
| 0–5 min | Instructions, order list, setup |
| 5–75 min | Individual student presentations (5–7 min each) |
| 75–80 min | Interim feedback summary |
Key Concepts
- Student presents all sections: DDL, INSERT script, SELECT queries, DCL
- Live run required — no pre-loaded databases
- Must explain: schema design rationale, FK resolution, idempotency
- Verification questions from the rubric will be asked
- Grading: correctness 40%, rerunability 20%, explanation 40%
✏️Practice
Students present their solutions.