If your application has to ensure data integrity, it must ensure that the inserts, deletes, or updates to both tables occur in a single transaction.
If you use application logic, be very sure that the data integrity requirements are well documented and well known to all application developers and to those who must maintain applications.
Using application logic to manage denormalized data
is risky. The same logic must be used and maintained in all applications
that modify the data.
