Course contentsShow
← Computer Science
Lesson 1633 of 2,87237. Database Design and NormalizationFree lesson

Achieving First Normal Form

Transforming unnormalized tables into 1NF by eliminating repeating groups and creating atomic attributes.

Achieving First Normal Form

You'll learn how to transform messy, unnormalized tables into clean First Normal Form by eliminating repeating groups and ensuring every field holds a single, atomic value.

The Problem: Repeating Groups and Non-Atomic Data

Before normalization, tables often contain repeating groups (multiple values crammed into cells) or non-atomic attributes (composite data that should be split). For example, storing multiple phone numbers in one cell like "555-1234, 555-5678" or combining street address and city into one field violates 1NF.

Think of it like organizing a messy drawer: instead of throwing all socks into one compartment as a tangled ball, you separate each pair into its own space.

How to Achieve 1NF

Step 1: Eliminate Repeating Groups
If a row contains multiple values for the same attribute (e.g., a customer with three phone numbers in one cell), create separate rows for each value. Each phone number gets its own row with the same customer identifier.

Step 2: Ensure Atomic Attributes
Break down composite fields into their smallest meaningful parts. Instead of FullName containing "John Doe", split it into FirstName and LastName. Instead of Address holding "123 Main St, Boston, MA 02101", create separate columns: Street, City, State, ZipCode.

Step 3: Verify Each Cell Holds One Value
Scan your table: every cell should contain exactly one indivisible piece of data from its domain. No lists, no embedded structures.

Example Transformation

Before (Unnormalized):
StudentID | StudentName | Courses
101 | Alice | Math, Physics, Chemistry

After (1NF):
StudentID | StudentName | Course
101 | Alice | Math
101 | Alice | Physics
101 | Alice | Chemistry

Key Takeaway: Achieving 1NF means removing repeating groups by creating additional rows and splitting composite attributes into atomic columns, ensuring each cell contains only one indivisible value.