Year 13

Assessment Number	Assessment Title	Credits	Internal	External	Due Date
AS91902	Databases	4	✔		Term 1 Week 8
AS91906	Programming	6	✔		Term 2 Week 8
AS91907	Digital Technology Outcome	6	✔		Term 3 Week 8
AS91908	Exam	3		✔	Term 4 Week 4

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

Course Outline