First Normal Form (1NF)
A table is in 1NF if:
- All attributes contain atomic (indivisible) values
- No repeating groups or arrays
- Each row is unique (has primary key)
0:00
0% complete
LearnStep 1 of 2
1NF and 2NF
Learning Objectives
- •Understand 1NF
- •Identify partial dependencies
- •Apply 2NF
Lesson Outline
LearnStep 1/2
1NF and 2NF
Second Normal Form (2NF)
A table is in 2NF if:
- It is in 1NF
- No partial dependencies (non-prime attributes fully depend on the whole candidate key)