අන්තර්ගතයට යන්න
mcqdinethlive
SPARK

Database design in one school register

The A/L ICT database unit is one job in five steps. One school club register goes from a scenario to an ER diagram, tables and keys, normal forms and SQL, the same order as the 2026 paper.

සිංහලෙන් කියවන්න

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

මේ Spark එක බෙදාගන්න

A/L ICT කරන යාළුවෙකුට යවන්න.

තවත් Sparks

  1. English

    Layer 2 and Layer 3 switches 101

    A Layer 2 switch forwards frames by MAC address inside one LAN, and a Layer 3 switch also routes packets by IP address between networks. Why both exist, where they work today, and the past paper questions that test them.

  2. English

    Planning an A/L ICT second attempt

    A low 2026 A/L ICT result is a map of gaps, not an end. Six units carry 73.4% of the marks, and every paper for the plan is free on this site.

  3. English

    Sequential search in Python 101

    A sequential search returns inside the loop on a match and gives the not found value only after the loop. 2026 Paper II Q9(c) shows where that line goes.

All Sparks