Sixth Normal Form (6NF)

In Sixth Normal Form (6NF), a relation variable is decomposed into its irreducible components − each table contains at most the primary key and one non-key attribute. A relation is in 6NF only if it is already in 5NF and every join dependency on the relation is trivial.

6NF represents the highest level of normalization, where we eliminate all possible redundancy by separating each non-key attribute into its own table. This extreme decomposition ensures that no information loss occurs during normalization while maintaining data integrity through join operations.

Understanding 6NF Decomposition

Example 1: Student Table

Consider the following Student table ?

The possible join dependencies are −

{Enrollment_No, Name}
{Enrollment_No, Marks}

In 6NF, this is decomposed into two irreducible tables −

Example 2: StudentMarks Table

Consider a more detailed table ?

In 6NF, this decomposes into three irreducible tables − each containing the primary key and exactly one non-key attribute ?

Now the above tables are in 6NF. However, as you can guess, this level of decomposition is not practical for real-world applications since it creates too many tables and requires many joins to reconstruct the original data.

Conclusion

6NF decomposes each relation into irreducible components where every table has at most one non-key attribute. While it achieves the highest level of normalization, it is rarely used in practice due to the excessive number of tables and join operations required. 6NF is mainly relevant in temporal databases and data warehousing scenarios where extreme normalization benefits outweigh performance concerns.