Skip to main content
PreparationZone Logo
PreparationZone
Back to Fundamentals

Fundamentals · Medium · Free

Explain 1NF with a violation example.

FresherFundamentalsDatabase Fundamentals
Model answer

First normal form (1NF)

Each column holds atomic values; no repeating groups. Violation: storing multiple phone numbers in one comma-separated column.

sql
-- Bad: phones = '111,222'
-- Good: phone_numbers(student_id, phone)
1NF enables filtering without string hacks.