https://kb.databasedesignbook.com/posts/5nf/
Article
-
Deep dive into Fifth Normal Form (5NF) and join dependencies
-
Explains when normalization beyond BCNF/4NF is theoretically justified
-
Argues normal forms are a teaching device more than an engineering spec
Discussion
-
Most stop at BCNF or 4NF in practice; 5NF rarely worth the complexity
-
Normal forms best internalized by feel after painful bugs, not memorized definitions
-
OLAP vs OLTP split missing from most normalization discussions — denorm is deliberate in warehouses
-
“Normalize till it hurts, then denormalize till it works” quoted as practical rule
Discuss on HN