Assignment 5 - Transactions

Objectives

Demonstrate understanding of ACID and transactions

Assignment

ACID is a set of rules, not an algorithm. For a database system to implement ACID requirements it must implement it using an algorithm 

You will submit a one page maximum limit paper with information comparing how databases implement transaction management to meet the ACID requirements. One of these databases must be SQL Server, you can select any other database for the comparison. You should specifically discuss the differences in algorithms used.

Be sure to cite references (this must be done on the one page) - you should have at least 2 references (since you are comparing 2 databases).

Submit the assignment in pdf or doc format.

Information

You will want to Google Search on implementing database ACID

Estimated Completion Time

5-10 hours to watch video, research requirements - and write the one page paper.

Supporting Lectures 

Lecture - Getting Started with Transactions in T-SQL

Questions and Answers

This will require some web research into the algorithms used.

External Resources

Grading Criteria