# Thread: availabiltiy for a car park booking system

1. Registered User
Join Date
Jul 2008
Posts
2

## availabiltiy for a car park booking system

hi,

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. www.gvee.co.uk
Join Date
Jan 2007
Location
UK
Posts
11,445
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.

#### Posting Permissions

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