You are tasked with managing three transactions in a database system involving the same checking bank

account.

$-$ Transaction $1$: Deposit $$500$

$-$ Transaction $2$: Deposit $$300$

$-$ Transaction $3$: Withdraw $$200$

a$)(30$ points$)$ Describe a sequence of multiple operations you would take to execute each of the three

transactions while ensuring compliance with the ACID properties $($Atomicity$,$ Consistency, Isolation, and

Durability$).$

b$)(10$ points$)$ Provide an example scenario where one of the above transactions does not comply with one or

more of the ACID properties. Explain which property $($or properties$)$ is violated and describe the potential

consequences on the database and the data integrity.