Problems with Transaction Processing
Airline reservation system:
Step 1: check if a seat is empty.
Step 2: reserve the seat.
Bad scenario: (but very common)
Customer 1 - finds a seat empty
Customer 2 - finds the same seat empty
Customer 1 - reserves the seat.
Customer 2 - reserves the seat.
Customer 1 will not be happy; spends night in airport hotel.