Discussion Post: Database
In a 250 to 500 words document, address the following questions:
• Describe the atomicity, consistency, isolation, and durability (ACID) test, 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 what happens when you encounter a "Deadlock," and provide an example of what can be done to correct a deadlock.
The response should include a reference list. Using double-space, Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.