Skip to main content

Explain 1NF, 2NF, and 3NF briefly.

Entry MS SQL
Quick Answer 1NF: each cell holds one atomic value, no repeating groups. 2NF: no partial dependency รขโ‚ฌโ€ every non-key column depends on the whole primary key. 3NF: no transitive dependency รขโ‚ฌโ€ non-key columns depend only on the primary key, not on each other. Each level builds on the previous.

Answer

1NF: No repeating groups; atomic values.
2NF: Remove partial dependencies.
3NF: Remove transitive dependencies.

S
SugharaIQ Editorial Team Verified Answer

This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice