title: Rent A Car - How to check if car is available between two dates?
body: <p>I'm making a rent a car site and cars can be reserved for a given time period. For example a car is reserved between <code>01.01.2011 - 10.01.2011 and 15.01.2011 - 25.01.2011. (dd.mm.yyyy)</code></p>
  
  <p>So the car is available between <code>11.01.2011 - 14.01.2011.</code> </p>
  
  <p>How should I keep the records of reservations? If I make a table named <code>'reservations'</code> and create columns for <code>'carID' 'startDate' 'endDate'</code> how can I check if the car is completely available between two dates? Or how should I create the reservations table?</p>