Depends on the Situation

• No hard and Fast rule about which approach to take
• Determine if the new tables make sense

In the invoice scenario we could have made new tables like “completed_orders” and completed_orders_detail”, But what would this buy you?

It’s Your Call