View Single Post
  #12 (permalink)  
Old
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 740
Quote:
Originally Posted by pootle flump
Ok - so why do you think a database normalise to 5th normal form require more code and maintenance?

If your database is not in fifth normal form and you want to ensure there can never be any update anomalies then you need to write some triggers. If it is in fifth normal form then you don't.
Exactly. You'll need more lines of code if the database is denormalized. You'll create more headaches for application developers. You'll also spend much more time refactoring code as the data model changes because you'll have to update some things multiple times.

Denormalization violates the principle of DRY. If you want to protect yourself against change, support good development practice or use iterative development methods then Normal Form really is an essential discipline. There's not much excuse for not doing it.
Reply With Quote