You are designing a database for a web-based ticket reservation application.
There might be 500 or more tickets available for any single event.
Most users of the application will view fewer than 50 of the available tickets before purchasing tickets.
However, it must be possible for a user to view the entire list of available tickets.
As the user scrolls through the list, the list should be updated to reflect that tickets have been sold to other users.
The user should be able to select tickets from the list and purchase the tickets.
You need to design a way for the user to view and purchase available tickets.
What should you do?