Booking a Venue for a particular Date

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Booking a Venue for a particular Date

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Booking a Venue for a particular Date

Page: [1]


xcapade Posts: 3 Joined: 12/14/2005 Status: offline	Booking a Venue for a particular Date - 3/22/2006 12:12:12 Hello everyone some advice as Iv been itching my head loads and nearly lost my hair now. The Situation is: Im trying to empower a Member from a Members_tb to be able to book the venue for a particular date now then at the moment iv only got a Members_tb in my database. Member_I being the obvious primary key What tables do you suggest I have to ensure the member can book venue and also how do i go about ensuring no dupilcate date is bookd Please any help would be so much help


rubyaim Posts: 757 Joined: 6/22/2005 Status: offline	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. < Message edited by rubyaim -- 3/23/2006 1:08:21 > _____________________________ Sally (in reply to xcapade)