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.