Syllabus: Cambridge IGCSE Computer Science 0478 (2026–2028), topic 9 Databases.
Learning objectives. By the end of this lesson you should be able to define a single-table database from a set of storage requirements (fields, records and validation), suggest a suitable data type for each field, explain the purpose of a primary key and pick one for a given table, and read, understand and complete SQL scripts that query one table, including working out exactly what a query will output.