News for hackers. Stuff that matters.
Re:5NF and Database Design by petalmind on Tuesday April 14, 2026 @01:32PM (#47768609)
Frankly I don't think that overcounting is solved by normalizing, because it's easy to write an overcounting SQL query over perfectly normalized data.

I tried to explain the real cause of overcounting in my "Modern Guide to SQL JOINs":

https://kb.databasedesignbook.com/posts/sql-joins/#understan...

Re:5NF and Database Design by estetlinus on Wednesday April 15, 2026 @03:32AM (#47775803)
Great read, thank you!
Re:5NF and Database Design by mickeyp on Wednesday April 15, 2026 @07:02AM (#47777392)
I'll go one further and say that if you're reaching for DISTINCT and you have joins, you may have joined the data the wrong way. It's not a RULE, but it's ALWAYS a 'smell' when I see a query that uses DISTINCT to shove away duplicate matches. I always add a comment for the exceptions.