Database Systems (Transaction Management) Make a solution to handle two transactions where the initial BalanceX is 1,000,000, if: Transaction Ta reads balanceX at time t1, reduces balanceX by 100,000...

Database Systems

(Transaction Management) Make a solution to handle two transactions where the initial BalanceX is 1,000,000, if:

1. Transaction Ta reads balanceX at time t1, reduces balanceX by 100,000 at time t2, writes balanceX at time t3, and performs rollback at time t5


2. Transaction Tb reads balanceX at time t4, reduces balanceX by 50,000 at time t5, writes balanceX at time t6, and commits it at time t7