How to learn database design?

Question

Python

Good afternoon! I work with the django framework sometimes yii, let's say when designing a store database, there are no business cards for simple projects. But when it comes to complex projects, such as portals, and so on, then difficulties arise with the design of the database, we are talking about the fact that there is no certainty that this decision is correct, it happened that you had to completely redo the database, which took a lot of time and nerves. Can you advise the materials of the book, or is it stupid experience that you need to get when creating projects?

Answer 1

habrahabr.ru/post/254773

Answer 2

80 percent is experience, the remaining 20 is theory, for example, there are 6 normal forms of the database, in fact the first three are most often used, and so in theory, they should always be used, but in some specific tasks it is required to abandon some of them - and this there will already be experience, read articles, watch and study the architecture of open source projects