Course Length: 10 Weeks
Focus: 3D Modelling and Resin Printing
| Assessment | Description | Type | Due |
|---|---|---|---|
| Assessment 1 | First 3D Print (Basic Model) | Practical | Week 5 |
| Assessment 2 | Final Resin Print (Refined Model) | Practical | Week 10 |
| Week | Key Vocabulary | Key Concept | SQL Focus |
|---|---|---|---|
| 1 – What is a database? | data, table, record, field | Databases vs spreadsheets | Reading simple SELECT |
| 2 – Entities and Attributes and Relationships | entity, attribute, instance, domain, relationship, one‑to‑many | Identifying entities and how they connect | SELECT with WHERE, ORDER BY, LIMIT; intro to JOINs |
| 3 – Keys and Splitting Data | primary key, foreign key, unique, identifier, redundancy | Why keys matter; why we split tables | Simple JOIN templates |
| 4 – Schema Design | schema, constraint | Designing a 3‑table schema | CREATE TABLE, INSERT, UPDATE, DELETE |
| 5 – Integrity and Constraints | validation, integrity | Preventing bad data | NOT NULL, UNIQUE, CHECK |
| 6 – Aggregation | query, filter, aggregate | Grouping and summarising | COUNT, SUM, AVG, GROUP BY, HAVING |
| 7 – Assessment Work | project vocabulary | Project development | Multi‑table queries |
| 8 – Finalising Assessment | project vocabulary | Finalising project | Final SQL + documentation |
assessment 2