Re:5NF and Database Design
by hilariously on Tuesday April 14, 2026 @05:08PM
(#47771546)
It depends on if you are doing OLTP (granular, transactional) vs OLAP (fact/date based aggregates) - dates are generally not something you'd consider in a fully normalized flow to uniqify records.
[ Parent
| on HN ]
Re:5NF and Database Design
by estetlinus on Wednesday April 15, 2026 @03:32AM
(#47775799)
Makes sense. I’m an OLAP guy.
Re:5NF and Database Design
by hilariously on Wednesday April 15, 2026 @09:52AM
(#47778978)
Well you are in luck, if someone tells your to normalize you can tell them their source system can fuck right off.