CSE Roadmap

Core tier · about 4 hours · 5 parts

Part 2 of 5 · 1 min read

First normal form (1NF)

Every column holds a single, atomic value, not a list.

Think of a form with one box per answer. A box holding three different answers crammed together defeats the point of having separate boxes at all.

In plain words: 1NF requires every column to hold a single, atomic value, not a list or a set of values packed into one field. A table violates 1NF if any column stores something like "comma-separated genres" inside one cell.

A worked example. A books table with a genres column holding "Fiction, Thriller" as one string violates 1NF. Splitting genres into their own table, linked through a junction table, satisfies it.

The key lines.

-- violates 1NF
books (book_id, title, genres)  -- genres = 'Fiction, Thriller'

-- satisfies 1NF
books (book_id, title)
book_genres (book_id, genre)

First normal form (1NF)

First normal form requires every column to hold a single, atomic value, never a list or set packed into one field.

Example: storing "Fiction, Thriller" in one genres column violates 1NF; a separate book_genres row per genre satisfies it.