The A/L ICT database unit is easier to learn as one job than as seven separate levels. Take one school club register. Dineth is in the ICT Society and the Chess Club, each club has one advisor, and the school records the date each student joins each club. That scenario becomes an ER diagram with an M:N link between students and clubs. Both Teachers' Guides start the ER diagram from the nouns and the verbs of a scenario (Teachers' Guide 8.4, page 60) (ගුරු අත්පොත, පිටුව 57). The diagram becomes five tables with primary and foreign keys. Normalisation then checks that each fact, such as an advisor's name, is stored only once, and SQL builds the tables and reads them.
The 2026 paper follows the same order. Paper I has eight Unit 8 MCQs in a row, from 2026 P-I Q26 to 2026 P-I Q33: database models, constraints, a SELECT query, an ER diagram and normal forms. 2026 P-II B Q8 asks for an ER diagram and its tables, then gives a club membership table and asks for its dependencies and its 3NF tables. So one register, worked through all five steps, covers most of the unit's marks.
The full breakdown, with the ER diagram, the mapping rules, the constraints, the normal forms, SQL and the book errors, is in an Explained post. Then try the 2026 paper.
Past PaperA/L ICT 2026 Past PaperMCQ 50 · මිනි. 120 · ලියූ වාර 3Open paper