You have designed the database for a web site that is used to purchase concert tickets. During a ticket purchase, a buyer views a list of available tickets, decides whether to buy the tickets, and then attempts to purchase the tickets.
This list of available tickets is retrieved in a cursor. For popular concerts, thousands of buyers might attempt to purchase tickets at the same time.
Because of the potentially high number of buyers at any one time, you must allow the highest possible level of concurrent access to the data.
How should you design the cursor?