robtyketto
Registered User.
- Local time
- Today, 21:51
- Joined
- Nov 22, 2006
- Messages
- 21
I am writing a booking simulation for a sports hall.
A customer makes a phone reservation for a date & timeslot (Book in 30minutes segments) in a facility (South Sports Hall, Swimming pool, Tennis Courts) and an area which determines which sport can be played.
A coach can be booked for a sport, typically a coach will only work xx number of days a week.
The coach rota can be the same for every single week.
Sports can be played in different areas in different facilities.
Ive started off my database model and applied normalisation (Though would appreciate if someone could check this)
The whole problem Im having is trying to prevent double booking, Im a newbie to access too.
Confustion comes with how to create the coach availability.
30mins timeslots for each day of the week? Using day & time fields i.e
Day 0 08:00
Day 0 08:30
Day 0 09:00
Day 1 08:00
Day 1 08:30
Day 3 09:00
etc..,
Also unsure of how to use the date on the booking form to work out date of week to be used for checking coach availability?
Another factor is do I need THREE fields in the booking table or sould I use TWO and include the date & time within start and end times?
The booking table is the table that requires updating, with all the other are just looksup.
Any advice would be greatly appreciated, im a student and deadlines creeping up on me in ALL modules
Thanks for your time
Rob
A customer makes a phone reservation for a date & timeslot (Book in 30minutes segments) in a facility (South Sports Hall, Swimming pool, Tennis Courts) and an area which determines which sport can be played.
A coach can be booked for a sport, typically a coach will only work xx number of days a week.
The coach rota can be the same for every single week.
Sports can be played in different areas in different facilities.
Ive started off my database model and applied normalisation (Though would appreciate if someone could check this)
The whole problem Im having is trying to prevent double booking, Im a newbie to access too.
Confustion comes with how to create the coach availability.
30mins timeslots for each day of the week? Using day & time fields i.e
Day 0 08:00
Day 0 08:30
Day 0 09:00
Day 1 08:00
Day 1 08:30
Day 3 09:00
etc..,
Also unsure of how to use the date on the booking form to work out date of week to be used for checking coach availability?
Another factor is do I need THREE fields in the booking table or sould I use TWO and include the date & time within start and end times?
The booking table is the table that requires updating, with all the other are just looksup.
Any advice would be greatly appreciated, im a student and deadlines creeping up on me in ALL modules
Thanks for your time
Rob
