Elective 2A · Databases
Curriculum hours: 38 · Paper weight: ~12.5% · Main language: SQL (SQL-92).
This elective extends Module A. You learn relational theory, design databases with ER diagrams, normalise schemas, and write SQL to query and modify databases.
Chapter map
| Chapter | Sub-topics | Hours |
|---|---|---|
| 1 · Relational Database Concepts | Tables, keys, integrity, indexes, rollback | 6 |
| 2 · SQL | DDL, DML, SELECT, joins, sub-queries, set ops, views | 18 |
| 3 · Database Design Methodology | ER diagrams, normalisation, denormalisation, access | 14 |
Why 2A is popular
- Predictable mark schemes — questions follow well-established patterns.
- Tightly coupled with SBA — you'll almost certainly use SQL in your project.
- SQL is a transferable skill far beyond the exam.
Study tips
- Every concept must be coded. Reading SQL is half the speed of writing it. Open SQL Books alongside this site.
- Build flashcards for the SQL reserved word list.
- Draw ER diagrams by hand — even rough ones — for every example scenario.
➡️ Start: Chapter 1 · Relational Database Concepts