What sensible articles have you seen about working with a database?

Question

MySQL

I noticed that I can’t find a sensible article or examples of organizing a database for frameworks.
Most articles are basic ala:

page ( title, content ),
users ( pass, name );

as if further freedom of thought-creativity.
It seems to me that for anyone there are some rules for creating databases, such as SOLID and Design Patterns for programming languages.
I ask this question because. now I work on frameworks, and I find a certain common feature in database sites. And it seems to me that there are basic tables that everyone has and it makes no sense to write the same tables every time. Either writing is not beautiful enough ... I think it's understandable, I mean.

Answer 1

It seems to me that for anyone there are some rules for creating databases

These rules are called Normal Forms.
A good book on the subject is SQL Antipatterns: Avoiding the Pitfalls of Databas...