what is transaction in dbms
A transaction can be defined as a group of tasks.
A single task is the minimum processing unit which cannot be
divided further.
EG:-
A’s Account
--------------------------
Open_Account(A)
Old_Balance = A.balance
New_Balance = Old_Balance - 500
A.balance = New_Balance
Close_Account(A)
B’s Account
---------------------------
Open_Account(B)
Old_Balance = B.balance
New_Balance = Old_Balance + 500
B.balance = New_Balance
Close_Account(B)