SYM WK7

ACID Explanation and Demonstration Paper

Assessment Description

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.

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.

1. 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.

2. Explain "collateral damage" in an update query.

3. Explain why locking prevents dirty reads.

4. 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.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Rubric Criteria

Expand All Rubric CriteriaExpand All

Word Count/Length

3.25 points

Mechanics of Writing

3.9 points

Documentation of Sources

3.25 points

Preventing "Dirty Reads"

13.65 points

Part 1 Question 4

13.65 points

The ACID Test: Components and an Example

13.65 points

Collateral Damage in Update Query

13.65 points

Total65 points