Home & Garden3 mins ago
Fixed Booking System
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
Answers
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.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.
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.