If you're in this position, you have scale informing product requirements already and can denormalize up front. But this is uncommon for read/write transactiona

If you're in this position, you have scale informing product requirements already and can denormalize up front. But this is uncommon for read/write transactional workloads and an especially uncommon scenario for a beginner to find themself in.