Relational Database Design and Modeling for Software Engineers

Higher Normal Forms (4NF, 5NF)

Fourth Normal Form (4NF)

Requirements of 4NF

Example: Student_Activities Table

Identifying a Multi-Valued Dependency

Converting to 4NF

Fifth Normal Form (5NF)

Requirements of 5NF

Example: Course_Instructor_Student Table

Converting to 5NF

Importance of Higher Normal Forms

Benefits of Normalization

Higher normal forms, such as the **Fourth Normal Form (4NF)** and **Fifth Normal Form (5NF)**, address advanced dependency types that can exist in complex database structures. These forms aim to eliminate multi-valued dependencies (4NF) and join dependencies (5NF), further reducing redundancy and optimizing database design. 

> **Note**: For a table to be in 4NF or 5NF, it must already meet the requirements of Boyce-Codd Normal Form (BCNF).


## Fourth Normal Form (4NF)

The **Fourth Normal Form (4NF)** handles **multi-valued dependencies**