Example of Fund Transfer Transaction to transfer $50 from account A to account B: 1.read(A) 2.A:=A-50 3.write(A) 4.read(B) 5.B:=B+50 6.write(B) Atomicity requirement-if the transaction fails after step 3 and before step 6,the system should ensure that its updates are not reflected in the database,else an inconsistency will result. Consistency requirement-the sum of A and B is unchanged by the execution of the transaction. Database System Concepts-5th Edition,Sep 10,2005. 15.5 @Silberschatz,Korth and SudarshanDatabase System Concepts - 5 15.5 ©Silberschatz, Korth and Sudarshan th Edition, Sep 10, 2005. Example of Fund Transfer Transaction to transfer $50 from account A to account B: 1. read(A) 2. A := A – 50 3. write(A) 4. read(B) 5. B := B + 50 6. write(B) Atomicity requirement — if the transaction fails after step 3 and before step 6, the system should ensure that its updates are not reflected in the database, else an inconsistency will result. Consistency requirement – the sum of A and B is unchanged by the execution of the transaction