Course information
A3 · Higher Level

Databases & SQL

Model related data and query it accurately.

DP1 · February–March 2027 · proposed

Learning goals

  • Design related tables with suitable keys.
  • Write and test SQL queries.
  • Explain data integrity and the need for a well-structured schema.

In practice

  1. Model an equipment-loan database.
  2. Query realistic records in SQLite.
  3. Test queries against missing, duplicate and boundary data.

Show understanding

A schema, a set of tested queries and design justification.

Predict first. Implement second. Test deliberately. Explain what the evidence shows.

Textbook: Baumgarten, Ganea & Turland. Topic codes follow the course; the book’s teaching order is not strictly numerical. Exact reading and submission requirements are set with each assignment.