If your schema is fully normalized then you never have two instances of the same data in more than one place therefore you never have to update two things simultaneously.

Anytime you need a transaction it is because you have the same data, or some calculated derivative of the same data, stored in different places, which is why they both have to be updated at the same time to maintain consistency.