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.
