CA37- Durability

Let’s understand durability using a simple accounts table
Initially, we have:

• Alice = 1000
• Bob = 500 let's perform a money transfer of 300 from Alice to Bob:

At this point we deducted money from Alice added it to Bob and committed the transaction. So, the updated balances become
Alice = 700
Bob = 800
this is durability

Now we simulate system restart reconnect and check data:
SELECT * FROM accounts;
Result:
Alice = 700
Bob = 800
even after restart data is still there

Conclusion:
Once a transaction is committed its changes are permanently saved in the database. That's exactly what durability means