• Discuss the ACID properties of transactions in the context of a banking system. Provide examples of SQL transactions that demonstrate atomicity, consistency, isolation, and durability. Explain how concurrency control mechanisms such as locking and timestamping can be used to prevent issues like dirty reads, non-repeatable reads, and phantom reads.