News for hackers. Stuff that matters.
Re:A Simple Guide to Five Normal Forms in Relational Databas... by Arnt on Monday September 29, 2014 @03:25AM (#8381964)
That's not what the database says. It doesn't say "x has a current contract with every brand" or "x offers every brand for sale", it says "x has offered every brand at some point in history".

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.

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.