Normalized schemas are less prone to certain kinds of hard-to-solve issues.
Example: When you have the same data in two places, which is authoritative? If they disagree, which one is right?
And querying data reliably is much easier when you've got good relations that can be relied on to be accurate. SQL is almost a masterpiece (though imho it should have been FROM, WHERE, SELECT).
Example: When you have the same data in two places, which is authoritative? If they disagree, which one is right?
And querying data reliably is much easier when you've got good relations that can be relied on to be accurate. SQL is almost a masterpiece (though imho it should have been FROM, WHERE, SELECT).