ACID properties of a relational model

A database built using a relational model is a relational database. A relational database management system manages relational databases. A relational database has ACID properties for its transactions.

A transaction in a relational database is atomic, which means it is just one activity that cannot be divided into smaller activities.

If a user transfers money from one account to another, this activity either does not happen or happens completely.

If the money is deductedfrom one account, the other account must receive the money.

A: Atomicity- Every Transaction is atomic. It either happens completely or not at all.

C: Consistent- All the three properties makes the data in a relational database consistent.

I: Isolation- Any two transactions cannot take place at the same time.

D: Durability- If the transaction is completed, changes made to the database due to that transaction remains.