Junior — Middle
What are the main levels of normalization in relational databases?
sobes.tech AI
Answer from AI
Main levels of data normalization in relational databases:
- First Normal Form (1NF) — all table attributes contain only atomic (indivisible) values, with no repeating groups.
- Second Normal Form (2NF) — the table is in 1NF, and all non-key attributes fully depend on the entire composite key (if the key is composite).
- Third Normal Form (3NF) — the table is in 2NF, and all non-key attributes depend only on the key, without transitive dependencies.
There are more strict forms (Boyce-Codd Normal Form, 4NF, 5NF), but for most practical purposes, the first three are sufficient.