Bird
0
0

What does First Normal Form (1NF) require in a database table?

easy📝 Conceptual Q11 of 15
SQL - Database Design and Normalization
What does First Normal Form (1NF) require in a database table?
AEach table must have a primary key.
BTables must have at least two columns.
CEach column must contain atomic (single) values only.
DColumns can contain lists or multiple values.
Step-by-Step Solution
Solution:

  1. Step 1: Understand 1NF definition

    1NF requires that each column holds only one atomic value per row, no lists or sets.

  2. Step 2: Evaluate options

    Each column must contain atomic (single) values only. matches the 1NF rule exactly. Options A, B, and D describe other concepts or violate 1NF.

  3. Final Answer:

    Each column must contain atomic (single) values only. -> Option C

  4. Quick Check:

    1NF = atomic columns only [OK]
Quick Trick: 1NF means no multiple values in one cell [OK]
Common Mistakes:
  • Thinking 1NF requires a primary key
  • Allowing lists or sets in columns
  • Confusing 1NF with other normal forms

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Top-N per group query - Quiz 13medium Advanced Window Functions - Percent of total with window functions - Quiz 11easy Common Table Expressions (CTEs) - Multiple CTEs in one query - Quiz 11easy Database Design and Normalization - Third Normal Form (3NF) - Quiz 1easy Database Design and Normalization - Denormalization and when to use it - Quiz 1easy SQL Security Basics - Why prepared statements exist - Quiz 4medium Stored Procedures and Functions - Parameters (IN, OUT, INOUT) - Quiz 15hard Stored Procedures and Functions - CREATE PROCEDURE syntax - Quiz 13medium Window Functions Fundamentals - Window function vs GROUP BY mental model - Quiz 12easy Window Functions Fundamentals - OVER clause with PARTITION BY - Quiz 6medium