title: Venue/Event Booking Database Design
body: <p>I am task with designing a database for online bookings.</p>
  
  <p>I am not looking for a full design as we have had previous exp with online house rental.</p>
  
  <p>What i would like to know, is how do we design a db for booking of hotel, travel, events.</p>
  
  <p>We have some ideas.</p>
  
  <p>Basics...</p>
  
  <p>Have all venues/ events (once/reoccuring) register. That seems like the static data. </p>
  
  <p>But how do i manage a hotel with 100+ rooms?</p>
  
  <p>I am kinda stumped.</p>
  
  <p>Any recommedations would be helpfull, or just thoughts on how i should approach this idea.</p>
  
  <p>I want to design a prototype in acces to show the investor the design, but plan to do the backend in sql 2005/ 2008</p>