CODE EXAMPLE FOR SQL

dbms transaction tutorialspoint

Open_Account(B)
Old_Balance = B.balance
New_Balance = Old_Balance + 500
B.balance = New_Balance
Close_Account(B)