ACID Explanation and Demonstration Paper
The purpose of this assignment is to explain how information systems can help companies make adequate use of data, how locking mechanisms function, how to clarify issues that may be encountered, and how to avoid bad transactions.
View the “Transactions, Concurrency Controls and Locks” video within the “Video Playlist: Relational Databases for Business Applications,” located in the topic Resources.
Imagine you have just been hired as a new junior database administrator (jDBA) for the Adventure Works Cycle Company and the department manager wants to verify your knowledge of transactions in SQL before you begin working with the database.
In a single Microsoft Word document, answer each prompt below with its own 200- to 250-word paragraph (four paragraphs total). Use your sandboxed copy of the database if appropriate. Be sure to properly cite your sources.
- 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.
Submit this assignment through the digital classroom.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.