Could you list the normal forms in relational databases starting from the fourth?
sobes.tech AI
Answer from AI
Fourth Normal Form (4NF) and Fifth Normal Form (5NF) are extensions of normalization in relational databases aimed at eliminating more complex data anomalies.
-
4NF (Fourth Normal Form): A table is in 4NF if it is in 3NF and does not contain multi-valued dependencies. A multi-valued dependency occurs when one record is associated with multiple values of another attribute independently of other attributes.
-
5NF (Fifth Normal Form): A table is in 5NF if it is in 4NF and every dependency is a consequence of a key. This eliminates anomalies related to decomposing tables into smaller ones without losing data.
Example: If you have a table with information about students, courses, and instructors, and one student can attend multiple courses, and each course can be taught by multiple instructors, then to eliminate multi-valued dependencies, the table should be split into several tables to achieve 4NF and 5NF.