Skip to content
2210 §9 · 9618 §8

ZAK's Database Designer

Normalisation is in every 9618 Paper 1 and it is marked on dependencies, not table names. Type the dependencies, propose your tables, and the checker tells you exactly which partial or transitive dependency you left in — in the examiner's words. Draw the ER diagram, resolve the many-to-many, and send the DDL straight to the SQL Lab. O Level students design the single table with types, validation and a primary key.

Loading the designer…

Example library

  • Normalisation to 3NF 6

    Given the unnormalised table and its dependencies, split it into 1NF, 2NF and 3NF tables

  • Entity–relationship diagrams 5

    Entities, 1:1 / 1:M / M:M relationships, resolving many-to-many with a link table

  • Single-table design (2210) 3

    Fields, data types, validation and a primary key for a flat-file database

Enroll nowOnline classes