Fundamentals · Medium · Free
Explain 1NF with a violation example.
FresherFundamentalsDatabase Fundamentals
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.