Select the ACID property violated in each example.$($a$)$

Pick

A transaction deletes an account with primary key of $5.$ A subscription references that primary key of $5$ as a foreign key.$($b$)$

Pick

A transaction removes expired subscriptions. The removals are written in the database, but due to a drive failure, the information is permanently lost.$($c$)$

Pick

A transaction removes expired subscriptions. Removes for only half of the subscriptions are written to the database due to a system failure.$($d$)$

Pick

Transaction $1$ slowly updates account A$\text{'}$s balance by a complex algorithm that reads the balance. Transaction $2$ quickly withdraws $5$ from account A$\text{'}$s balance. Transaction $2$ starts before $1$ finishes.