Suppose that you are writing a stored procedure to record new purchases. Suppose that
you know that while your procedure is running, another stored procedure that records
shipment data can be running, and a third stored procedure that updates shipper data
can also be running.
1. Give an example of a dirty read, a nonrepeatable read, and a phantom read among
this group of stored procedures.
2. What concurrency control measures are appropriate for the stored procedure that
you are creating?
3. What concurrency control measures are appropriate for the two other stored
procedures?