Comment on Understanding database normalisation: a very short tutorialComments−zerovox14ySurprised to see no mention of BCNF or 4NF, as these are the two most commonly used in practice.−henrikschroder14yI suspect that 1NF or 2NF are the most commonly used forms, simply because most database schemas are made by people who don't really know or care, and are satisfied when it works.−hzy14yThe 3A/3B course has very little regard for modern best practises, just what was relevant 15 years ago when the course was written.
Comments
Surprised to see no mention of BCNF or 4NF, as these are the two most commonly used in practice.
I suspect that 1NF or 2NF are the most commonly used forms, simply because most database schemas are made by people who don't really know or care, and are satisfied when it works.
The 3A/3B course has very little regard for modern best practises, just what was relevant 15 years ago when the course was written.