Geek Answers Handbook

What is the level of database normalization, which is "practically" sufficient?

I create a database, and I reached (according to my little knowledge) the Third Normal Form (3NF)

Some of my colleagues told me about the Sixth Normal Form ! I was interested to know if the level of database normalization is sufficient.

+4
source share
5 answers

In my experience, it's pretty rare to hear someone talking about going beyond 3NF for real production applications. This should be enough for almost all cases.

+4
source

Usually 3NF is good enough, but it really depends on your requirements. Be practical in your design.

+3
source

I usually optimize my DBs to 3 NF. This is usually enough.

+2
source

Practically - it depends on your needs. For small and fast applications, you are happy with 1NF .. even 0NF, since you don't care.

As the application grows, you need to optimize the data structure.

If you are trying to make some presets, keep 3NF as your primary.

0
source

Strive to be at 5NF unless you find good reason to deviate from it. 6NF should be used only in special cases, since in most cases in most DBMSs you will not be able to implement all the important dependencies under 6NF.

0
source

More articles:


All Articles