title: ASP.NET Event reservation application - Seats count issue
body: <p>Im about to create a very simple online event reservation application and currently have 3 tables:</p>
  
  <p><strong>User</strong> </p>
  
  <ul>
  <li>PK_UserID  </li>
  <li>UserName</li>
  </ul>
  
  <p><strong>Event</strong></p>
  
  <ul>
  <li>PK_EventID</li>
  <li>EventName</li>
  <li>EventDescription</li>
  <li>EventStartDate</li>
  <li>EventEndDate</li>
  <li>SeatsAvailable</li>
  </ul>
  
  <p><strong>BookedEvents</strong></p>
  
  <ul>
  <li>ID</li>
  <li>FK_UserID</li>
  <li>FK_EventID</li>
  </ul>
  
  <p>Do you have any experience of how to handle SeatsAvailable? I mean if SeatsAvailable is set to 5 and there are 5 users online and want to book event. And some user has started to fill out the form then changed his mind. Then seats in database can just leak. I was thinking about sessions - like to limit every user to 5 minutes to complete the booking but i dont really know if its good idea. Do you have any suggestions? </p>