CODE EXAMPLE FOR SQL

dbms transaction tutorialspoint

Open_Account(A)
Old_Balance = A.balance
New_Balance = Old_Balance - 500
A.balance = New_Balance
Close_Account(A)