Normalization Rules and Dependencies from 1NF to 5NF

Explain the different normal forms in a DBMS.

Discuss the purpose of normalization, the conditions for 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF, and the anomalies each form helps prevent. For grading, return the normal forms in order with their defining rule and an associated dependency rule.

Output

1. One row per normal form
2. Columns: normal_form, definition, dependency_rule
3. Sort by normal form progression from 1NF through 5NF

Output details

• Include every form with sort_order <= 5, including forms without matching rules and forms having multiple rules.
• Represent a missing dependency_rule as null.
• Sort ascending by sort_order, then ascending by rule_id.
• Retain duplicate normal-form rows rather than deduplicating them.
• Return all qualifying rows without a row limit.