Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the level of database normalization that is "practically" enough?

I am designing a database and I reached (as per my little knowledge) the Third Normal Form (3NF)

Some of my colleagues told me about a Sixth Normal Form!! I was wondering how to know if the level of normalization of database is enough.

like image 588
Mohamed Kamal Avatar asked Jul 08 '11 14:07

Mohamed Kamal


People also ask

Is 3NF good enough?

Third Normal Form (3NF) is considered adequate for normal relational database design because most of the 3NF tables are free of insertion, update, and deletion anomalies.

Which normalization is best in database?

Each rule is called a "normal form." If the first rule is observed, the database is said to be in "first normal form." If the first three rules are observed, the database is considered to be in "third normal form." Although other levels of normalization are possible, third normal form is considered the highest level ...

Which normal form is most adequate one practically?

Which normal form is considered adequate for normal relational database design? Explanation: 3NF is sufficient because because most of the 3NF tables are free of insertion, update, and deletion anomalies. Moreover, 3NF always ensures functional dependency preserving and lossless.


2 Answers

In my experience, it's pretty rare to hear anyone talk about going beyond 3NF for real-world production applications. That should be sufficient for nearly all cases.

like image 120
Dave Sherohman Avatar answered Sep 30 '22 15:09

Dave Sherohman


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

like image 40
Peter Avatar answered Sep 30 '22 15:09

Peter