Good description. It might be important to point out that the decision has to be made carefully; whilst normalisation typically improves write performance, a no

Good description. It might be important to point out that the decision has to be made carefully; whilst normalisation typically improves write performance, a normalised database can absolutely munch read performance, especially when it comes to things like aggregations. Furthermore, there are some redundancies that you can't eliminate without also necessarily losing the ability to represent functional dependencies, which kinda buggers that one.