Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008

    availabiltiy for a car park booking system


    I'm going to get a developer to create a new site for a car park which will include a booking system.

    I want to understand how availability or occupancy would typically be modeled for a car park in a database or booking system.

    Would you simply use count variable for each date, for example.

    If the total number of cars booked in the car park was
    4July08 = 9
    5July08 = 10
    6July08 = 4
    and you were booking in a car from 4th to 6th July would you simply add +1 to each date count? So you would then have
    4July08 = 10
    5July08 = 11
    6July08 = 5
    I assume you would have a maximum occupancy variable also.
    Is this typically how this type of thing would be modeled?

  2. #2
    Join Date
    Jan 2007
    You would not store something you can calculate like this.
    If your table stored the date a car was booked in, then ultimately, a count of the number of records with a specified date gives you this value.
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts