Normalize to the max then denormalize till you achieve the performance trade-offs you want. That's the rule in relational schema design. Adding JSON traversal

Normalize to the max then denormalize till you achieve the performance trade-offs you want. That's the rule in relational schema design. Adding JSON traversal operators and functions helps a lot when you end up denormalizing bits of the schema. It's not hard.