Problem
1. Explain how locking could be used to prevent the lost update in your answer.
2. Is it possible for deadlock to occur between two Service Update Transactions? Why or why not? Is it possible for deadlock to occur between a Service Update Transaction and a Service Update for New Employee Transaction? Why or why not?
3. Do you think optimistic or pessimistic locking would be better for the Service Update Transactions?
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.