ACID + refernetial integ

Question 1

whats acid

Answer 1

Atomicity
consistency
isolation
durability

Question 2

whats atomicity

Answer 2

a transaction must be processed in its entirity or not at all

Question 3

whats consistency

Answer 3

transaction must maintain the referential integrity rules between linked tables.

Question 4

whats isolation

Answer 4

Simultaneous executions of transactions should lead to the same result as if they
were executed one after the other

Question 5

whats durability

Answer 5

Once a transaction has been executed it will remain so regardless of the
circumstances surrounding it, such as in the event of a power cut.

Question 6

what is referential integrity

Answer 6

Referential integrity is the process of ensuring consistency. This ensures that information
is not removed if it is required elsewhere in a linked database. If two database tables are
linked, one of these tables cannot be deleted as the other table requires its contents.