Explainer Draft for review

Third normal form, explained for business owners

Third normal form is a way of organising database tables so that every fact is stored once, in the right place. It matters because it keeps reports correct and changes safe, even as an application grows.

DynamicForm by AG Studio Ventures · Updated 29 Sep 2026

The idea in plain words

Each table describes one kind of thing, such as a customer or an address. Each fact is stored once: a city name lives in the city table, and a customer record only points to it by code. Nothing in a row depends on anything except that row's own key.

Why it matters to the business

Reports add up, because no fact is counted twice.
A correction is made in one place, not in hundreds of rows.
New screens and fields can be added without reshaping old data.
Any reporting tool can read the tables with plain SQL.

How DynamicForm applies it

When a screen is published, the platform creates a table for it keyed by the case, a child table for each repeating section keyed by the case and row, and stores dropdown values as codes that refer to master tables.