Concurrent Transaction Integrity
Two cashiers processing orders simultaneously could read stale inventory counts, leading to overselling. MySQL transactions with row-level locking on the products table resolved this, ensuring stock deductions were atomic.

