Can you explain the main characteristics of transactions in databases?

The main characteristics of transactions in databases are described by the acronym ACID:

• Atomicity: The transaction is completed in full or not at all. If something goes wrong, all changes are rolled back.
• Consistency: After the transaction, the database remains in a correct state, satisfying all rules and constraints.
• Isolation: Parallel transactions do not affect each other, and the results of one transaction are not visible to another until it is completed.
• Durability: After a successful transaction, changes are saved in the database and are not lost even in case of failures.

For example, in transferring money between accounts, the transaction guarantees that the debit from one account and the credit to another will happen together or not at all.