Durability

hi! To Perform a successful transfer between two accounts and commit the transaction, first creating a table accounts, CREATE TABLE accounts (id SERIAL PRIMARY KEY,name TEXT NOT NULL,balance INT NOT NULL CHECK (balance >= 0),last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP); the table contains attributes id as peimary key, name,balance >=0,last_updated.next to insert values to the table accounts INSERT INTO accounts (name, balance) VALUES ('Alice', 1000),('Bob', 500); To ensuring that the changes are reflected in the database. BEGIN; UPDATE accounts SET balance = balance - 300 WHERE name = 'Alice'; UPDATE accounts SET balance = balance + 300 WHERE name = 'Bob'; COMMIT; here the amount deduction and the amount added is done successfully. After simulating a system restart or database crash to check whether the reconnect to the database account balance is successful.And to verify whether the committed changes persist even after the restart. SELECT name, balance FROM accounts; how th