
Member • Feb 14, 2008
Normalization
Do you remember all the different types of normalization we learnt? 1NF, 2NF, 3NF, 4NF, 5NF (yes there is one), BCNF ... are there any more?
If there are, why do we need so many? Can someone honestly tell me that they have made an application which is truly past 3NF?
The debate is open sires ...
My $0.02 -
So far, I have worked on 4 online live applications -
1. a finance portal, portfolio management
2. a CMS, news feed, et al
3. 2 e-commerce portals
All of them are handling a decent amount of traffic, and in all the 4 applications, trying for more than 2NF resulted in nightmares. Effectively, we had to stop just short of 3NF.
What are the real life applications of higher forms of normalization then?