What to read about database normalization?

Question

MySQL

What to read about database normalization? What is a worthwhile textbook that helped you. Thank you.

Answer 1

In principle, a tutorial is not needed for this, normalization - minimizing data redundancy, has 5 forms. The first three forms are aimed at data connectivity, the last two are aimed at improving the structure. Very well described here - citforum.ru/database/dblearn/index.shtml (chapters 6 and 7)
Briefly here - support.microsoft.com/kb/283878/ru
And yes, you don't always need to chase minimization, sometimes you have to duplicate data for faster searching, the world is not perfect.
And here is a good video - www.youtube.com/watch?v=1GWx5CZdSCg

Answer 2

Of course, I could be wrong, but I think that on normalization, in principle, there is not much information to read the textbook. Enough Google and the query "bd normal forms". Further article on Wikipedia, the realization that it is difficult without examples, searching and finding examples, again Wikipedia while (!understood). In principle, we can say that understood == true when there is an understanding of at least the first 3 normal forms. The rest is more difficult to understand, but is achieved by itself in most database design applications.

Answer 3

Not exactly about database normalization, but here you can read about optimizing highly loaded systems.
http://ruhighload.com
In the section "server" there are articles about databases. There is a lot of useful material there.

Answer 4

Date K. Introduction to database systems.- K.; M.; St. Petersburg: Publishing house "Williams", 2000.- p.
This book has a chapter on normalization.