Databases

29 min · 4 IGCSE exam questions

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.

In this lesson

  • What is a database?
  • Tables, records and fields
  • Validation in a database
  • The six basic data types
  • Primary keys
  • SQL and SQL scripts
  • The SQL commands you need
  • Writing conditions with WHERE
  • Sorting with ORDER BY
  • Worked examples: reading the output of a query
  • Defining a single-table database from requirements
  • Going further: building a table with SQL
  • Practice
  • Revision checklist