Final Assessmentexamadvanced
Final Work Session 1
First independent work session for the final SQL assignment.
Overview
Students work independently on the final assignment. No new material is introduced. The instructor is present for questions and guidance only. Focus: DDL section and schema creation.
Lesson Plan
| Time | Activity |
|---|---|
| 0–5 min | Instructions and progress check-in |
| 5–70 min | Independent work on the assignment |
| 70–80 min | Checkpoint: instructor reviews DDL section with each student |
Key Concepts
- Working from the assignment schema specification
- Writing clean, formatted DDL with appropriate constraints
- Checking FK and PK definitions against requirements
- Commenting sections clearly for the defence
- No collaboration — individual submission required
✏️Practice
Students complete tasks independently.