I typically go for 3rd normal form, and selectively denoralize where it has true performance value.
“Normalize ’til it hurts, denormalize ’til it works.”
Just saying this feels like it elevates you above 80% of people who work with databases.
“Normalize ’til it hurts, denormalize ’til it works.”