1NF (EN)

Concept

First normal form requiring atomic attributes and absence of repeated groups

Architecture

flowchart TD   A[Original Table] --> B{1NF Requirements}   B --> C[Atomic Attributes]   B --> D[No Repeated Groups]   C --> E[Each Cell Has Exactly One Value]   D --> F[No Multivalued Columns]

Example

Not 1NF: Customers(ID, Name, Orders["Book", "Chair", "Lamp"])
1NF: Customers(ID, Name), Orders(ID, CustomerID, Product)

Quelle: AI Generated