A DBMS interleaves the actions of different transactions instead of executing them one after the other. Briefly but clearly, explain the two reasons why a DBMS allows transactions to execute concurrently. code example
Example 1: dbms transaction tutorialspoint
Open_Account(B)
Old_Balance = B.balance
New_Balance = Old_Balance + 500
B.balance = New_Balance
Close_Account(B)
Example 2: dbms transaction tutorialspoint
Open_Account(A)
Old_Balance = A.balance
New_Balance = Old_Balance - 500
A.balance = New_Balance
Close_Account(A)