Using application logic

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.

NoteUsing application logic to manage denormalized data is risky. The same logic must be used and maintained in all applications that modify the data.