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 −
The possible join dependencies for the above would be −
In Sixth Normal Form (6NF), it would be decomposed to −
Let us see another example −
Let us decompose the table −
| S03|| 85|
Now the above tables are in 6NF, but as you can guess on your know that this isn’t possible in real-world.