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.
normal_form, definition, dependency_rule| Column | Type | Description |
|---|---|---|
| normal_form_codePK | VARCHAR(10) | Short identifier for the normal form |
| form_name | VARCHAR(50) | Display name of the normal form |
| definition | TEXT | Defining condition for the normal form |
| sort_order | INT | Logical progression order |
| Column | Type | Description |
|---|---|---|
| rule_idPK | INT | Unique dependency rule identifier |
| normal_form_code | VARCHAR(10) | Referenced normal form |
| dependency_type | VARCHAR(80) | Type of dependency addressed |
| rule_text | TEXT | Explanation of the dependency rule |