Demonstrate and describe the atomicity, consistency, isolation, and durability $($ACID$)$ test for transactions, including the meaning of each of the four components. Provide an example that illustrates the importance of adhering to the ACID test.Explain "collateral damage" in an update query.Explain why locking prevents dirty reads.Summarize the difference between an ordinary lock and a deadlock, what happens when you encounter a "deadlock," and provide an example of what can be done to correct a deadlock.