Atomicity - Design a Reliable Wallet Transfer System with ACID Guarantees

hi! to Design a transaction that transfers money from one account to another using the accounts table, CREATE TABLE accounts ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, balance INT NOT NULL CHECK (balance >= 0), last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); create a table with attributes id,name,balance to check balance in account,and last_update .then insert values to the table using insert. INSERT INTO accounts (name, balance) VALUES ('Alice', 1000), ('Bob', 500); BEGIN; UPDATE accounts SET balance = balance - 200 WHERE name = 'Alice'; UPDATE accounts SET balance = balance + 200 WHERE name = 'Bob'; COMMIT; the balance from sender in deducted using update and again using update the balance of reciever is added then the transaction is commited to get the updated result. BEGIN; UPDATE accounts SET balance = balance - 100 WHERE name = 'Alice'; UPDATE accounts SET balances = balance + 100 WHERE name = 'Bob'; ROLLBACK; here to show Failed Transaction: Breaking the Credit Operatio