|
rubyaim -> RE: Booking a Venue for a particular Date (3/23/2006 0:58:14)
|
Setting up booking / scheduling / timetable databases can be a bit tricky [&:] .
Basic suggestions to start with:
Venue Table (or is it only the one venue?)
Venue ID
Venue Description
Booking Table
Booking ID
Venue ID
Member ID
Start Date
End Date
Things to think about:
- Do you need a Start Time and End Time for bookings?
- Will the Venue be booked for an entire day or split into sessions (eg, a school would have bookings based on the timetabled periods - Period 1 may run from 9.00 am to 9.45 am etc).
- Do you need to know the resources of a Venue?
EG: if it's a room, does it have a Projector and Screen, TV, DVD, Whiteboard, how many tables and chairs?, if it's a sporting oval does it have lights?, if it's a hall how many people does it seat?
- Do you need to include any other information about your Venue(s)?
- Do you want to combine this with your current Membership table or do something like read that table into a new database?
- Are you happy with your Membership table or should you normalise it?
If you are using Access you may like to look at the 'Event Management' and 'Resource Scheduling' templates that come with it, they might give you some ideas on structure (>File >New >On My Computer >Databases).
I sometimes visit this site if I need ideas for set up: http://www.databaseanswers.org/data_models/index.htm
Ensuring that there are no duplicate bookings is not that hard once your database is set up and normalised. Do you plan on your members booking this via a webpage? If so you could simply only allow the venue(s) to be booked if available.
I'm sure you will get more help once you get started. [:)]
|
|
|
|
