Home/ Questions/Q 7191
Next
Answered

SIKSHAPATH Latest Questions

pratyush
  • 0
  • 0
Asked: 2021-11-20T07:53:03+05:30 In:

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which form a transaction will it be? …

  • 0
  • 0

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which form a transaction will it be? Explain.

database management systemdbms
Share

    1 Answer

    2. SUMIT
      Best Answer
      account-A to account-B:
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)


account-B to account-A:


B’s Account

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


A’s Account

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

    Leave an answer

    You must login to add an answer.

    Need An Account,