අන්තර්ගතයට යන්න
mcqdinethlive
SPARK · UNIT 8

Normalisation by dependencies 101

The normal form of a table comes from its arrows. Find the key, draw who decides each column, and the kind of arrow names the normal form and the split.

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

The normal form of a table is decided by its dependencies, not by how the table looks. Find the key first. Then draw an arrow from the smallest set of columns that decides each other column. An arrow from part of a composite key is a partial dependency, so the table is in 1NF. An arrow from a column outside the key is a transitive dependency, so the table is in 2NF. No such arrow means 3NF (8.7). The Teachers' Guide names these three kinds but does not define them (Teachers' Guide 8.7, page 64) (ගුරු අත්පොත 8.7, පිටුව 65).

2021 (held 2022) Paper II, B, Q9(b) shows the fastest case. The key of Contracts is CNo, one column, so no partial dependency is possible. ACode decides AName and AMobile, and ACode is not the key. So the table is in 2NF, and the next tables are Contracts(CNo, ACode, Client) and Agent(ACode, AName, AMobile). That is the official answer. The same four steps give the scheme answer in every Paper II from 2019 to 2025.

Work all eight Paper II questions with the method in the full breakdown.

මේ 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