3 ms·
> But normalization only mens splitting into multiple tables in the case were it reduces data redundancy. Normalization means splitting into multiple tables wh
by dragonwriter 4y ago
> But normalization only mens splitting into multiple tables in the case were it reduces data redundancy.
Normalization means splitting into multiple tables where it avoids anomalies, redundancy (because it allows inconsistency) is one source of anomaly, but not the only one. 4NF -> 5NF normalizations, for instance, do not (at least, as a generality) remove redundancies. (Neither does DKNF -> 6NF, but I’m not convinced that actually reduces anomalies.)
- bazoom42 4y agoI forgot about 6NF which I consider non-canonical fan-fiction. As far as I understand it is only useful in the context of data-warehouses. But the other normal forms reduce redundancy which is what makes inconsistencies possible.