Can you list the main properties of transactions in database management systems?

The main properties of transactions in DBMS are described by the acronym ACID:

• Atomicity: the transaction is completed entirely or not at all. If an error occurs, all changes are rolled back.
• Consistency: the transaction transfers the database from one consistent state to another, without violating rules and constraints.
• Isolation: concurrently executing transactions do not affect each other, and their results are not mixed.
• Durability: after a successful transaction, its changes are saved in the database even in case of system failures. These properties ensure reliability and predictability in data handling.