Archive for March 17th, 2009
You are browsing the archives of 2009 March 17.
When NOT to normalise the database
When talking of Database Normalisation, textbooks often talk of BCNF, fifth and higher normal forms. However, in practice (in large software/ERPs) I have rarely noticed normalisation beyond Third Normal form. In fact, there is a certain degree of redundancy that is desirable. While doing database design, I believe there are two critical aspects that should [...]
