One of the key advantages to any RDBMS is the ability to sup

One of the key advantages to any RDBMS is the ability to support transactions, but transactions can run into problems if the database is constantly changing too much. Transactional systems typically are said to provide ACIS properties. In your own words, describe what each letter in ACID stands for and means.

Solution

Answer:

_______

ACID describes,

A- Atomicity: In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are.

C- consistency: A transaction either creates a new and valid state of data, or, if any failure occurs, returns all data to its state before the transaction was started.

I- Isolation: A transaction in process and not yet committed must remain isolated from any other transaction.

D- Durability: Committed data is saved by the system such that, even in the event of a failure and system restart, the data is available in its correct state.