Sixth Normal Form (6NF)

In 6NF, the relation variable is decomposed into irreducible components. A relation is in 6NF, only if, It is in 5NF, and every join dependency on the relation is trivial

Let us see an example −

<Student>

The possible join dependencies for the above would be −

In Sixth Normal Form (6NF), it would be decomposed to −

<StudentInformation>

<ResultInformation>

Let us see another example −

<StudentMarks>

Let us decompose the table −

<StudentFirstName>

<StudentLastName>

<StudentResult>

Now the above tables are in 6NF, but as you can guess on your know that this isn’t possible in real-world.