Database Dictionary

DATABASE DESIGN LAB

Normalization Lab

Transform an order record into a clear, reliable relational schema.

  1. 1NFAtomic values
  2. 2NFFull dependency
  3. 3NFNo transitive dependency

STARTING RELATION

OrderRecord (UNF)

One order
OrderID
ORD-1001
OrderDate
12 Aug 2026
CustomerID
C-17
CustomerName
Aina
CustomerCity
Shah Alam
Products
PR-04 · Keyboard · Unit 80 · Qty 2PR-11 · Mouse · Unit 25 · Qty 1

Step 1 of 3