Discuss what is meant by a transaction in a relational database management system and expand on the benefits of the ACID set of properties in a database management system code example

Example: acid properties in dbms

Atomicity
The entire transaction take place at once or doesn't happen at all.

Consistency
Database must be consistent before and after the transaction.

Isolation
Multiple transactions occur independently without interference.

Durability
The changes of the successful transaction occurs even if the system 
failure occur.