UE+ Approved: Yes
Credits Available: 19
| Assessment Number | Assessment Title | Credits | Internal | External | Due Date |
|---|---|---|---|---|---|
| AS91902 | Databases | 4 | ✔ | Term 1 Week 10 | |
| AS91906 | Programming | 6 | ✔ | Term 2 Week 10 | |
| AS91907 | Digital Technology Outcome | 6 | ✔ | Term 3 Week 10 | |
| AS91908 | Exam | 3 | ✔ | Term 4 Week 4 |
AS91902: Use complex techniques to develop a database
UE approved
Internal 4 Credits
| Week | Key Vocabulary | Key Concept | SQL Focus | Resources |
|---|---|---|---|---|
| 1 – What is a database? | data, table, record, field | Databases vs spreadsheets | Reading simple SELECT | SQL Introduction (W3Schools) |
| 2 – Entities & Attributes | entity, attribute, instance, domain | Identifying entities & attributes | SELECT with WHERE, ORDER BY, LIMIT | Entities & Attributes (Lucidchart) |
| 3 – Relationships | relationship, one-to-many, many-to-many, linking table | How entities connect | Reading JOINs | ER Diagram Basics |
| 4 – Keys | primary key, foreign key, unique, identifier | Why keys matter | Simple JOIN templates | Primary & Foreign Keys (W3Schools) |
| 5 – Splitting Data | redundancy, consistency | Why we split tables | Basic JOIN writing | Intro to Normalisation (Guru99) |
| 6 – Schema Design | schema, constraint | Designing a 3‑table schema | INSERT, UPDATE, DELETE | Schema & CREATE TABLE |
| 7 – Integrity & Constraints | validation, integrity | Preventing bad data | NOT NULL, UNIQUE, CHECK | SQL Constraints |
| 8 – Aggregation | query, filter, aggregate | Grouping & summarising | COUNT, SUM, AVG, GROUP BY | GROUP BY & Aggregates |
| 9 – Assessment Work | project vocabulary | Project development | Multi‑table queries | SQL Teaching (interactive) |
| 10 – Assessment Work | project vocabulary | Finalising project | Final SQL + documentation | SQL Practice (Codecademy) |