Normalisation of data is great until it isn’t.
If you’re building a reporting DB, sometimes denormalising is worth it. But for transactional stuff? Normalise all the way.
Check out “SQL Antipatterns” book—it’s got a whole section on this.
If you’re building a reporting DB, sometimes denormalising is worth it. But for transactional stuff? Normalise all the way.
Check out “SQL Antipatterns” book—it’s got a whole section on this.