Re:A Simple Guide to Five Normal Forms in Relational Databas...
by davidw on Monday September 29, 2014 @04:50AM
(#8382111)
I am an ardent fan of Postgres, and think it's important to properly store data for all the reasons mentioned elsewhere.
That said, there are cases where people get a bit too architecture astronaut with the DB relations, making simple things difficult before those complications are really necessary.
I think this is perhaps the biggest problem with 3NF and above: People construct sloppy queries (such as confusing "sells" with "has ever sold in the past"), verify that they give the expected results on a seven-row test table, and then deploy them in production. 3NF and above demand clear thinking.