Donate SIGN UP

Fixed Booking System

Avatar Image
faith_scott | 16:02 Fri 21st Apr 2006 | Technology
6 Answers

Hi,


I was just wodnreing whether anybody knew how to design a fixed booking system for a database, as I ahve no clue how to do it,


Thanks in advance,


Faith

Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by faith_scott. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Define 'fixed booking system' a bit more. Something like a court booking system at a sports centre?
Question Author

Sorry, what I mean is, a fixed booking system for say a small company booking for say rooms etc. The booking has to be made via slots, and I have no idea how I can go about doing it!


Thanks so much for replying,


Faith

So, a table for the Rooms :

RoomID - uniqueidentifier (or AutoNumber) - Primary Key
RoomDescription - varchar(255)

A table for Bookings :

BookingID - uniqueidentifier (or Autonumber) - Primary Key
RoomID - uniqueidentifier - Foreign Key on Rooms table
BookingStart - datetime
BookingEnd - datetime

And that's about it, apart from checking the BookingStart and BookingEnd fields each time you try and create a new booking to ensure no bookings clash.

if you use exchange you are probably better off setting up a public folder called Meeting Rooms (or something) and then having a diary for each room.


Question Author
Thank you so much for your help!
Access has a "Resource Booking" template that you could work on and modify...

1 to 6 of 6rss feed

Do you know the answer?

Fixed Booking System

Answer Question >>