anomaly. The goal to be reached with 5NF is to keep splitting the tables until either of two states is reached:1. Further splitting would result in tables that could NOT be joined to recreate the original.2. The only splits left are trivial.ConclusionWithout trying to sound too "Zen", it would be fair to say that a thorough understanding of data normalization is a journey, not a destination. The topic is fundamental in that a robust database design cannot be achieved without normalization, yet it is a largely arcane subject that gets less intuitive as one progresses up through the normal forms. Despite the complex notion of database normalization, the application of it is virtually essential to any development undertaking....
