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

Pick

A transaction adds $1$ to each account's primary key to make room for a new account. The updated primary key does not cascade to foreign keys.$($b$)$

Pick

A transaction updates all accounts with a BalanceAmount of NULL to $0.$ The updates are written in the database, but due to a drive failure, the information is permanently lost.$($c$)$

Pick

Two transactions run in parallel to set an account's balance to different values.$($d$)$

Pick

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