Question: Transactions and Concurrency Control

Database management systems have evolved over the years to be able to perform multiple transactions and enable multiple users to access databases simultaneously. However, database management systems must be able to manage transactions from multiple users and avoid potential problems associated with transaction management.

• Select one (1) of the transaction management or concurrency control methods, and explain the primary manner in which the chosen method is used in database management systems. Describe the impact and alternative of not having the chosen method available to manage concurrency.

• Describe one (1) scenario in which the selected transaction management or concurrency control method is needed. Examine the significant ways in which business operations would have to change if concurrency management methods were not available.