robtyketto
Board Regular
- Joined
- Oct 25, 2006
- Messages
- 111
Greetings again,
Carrying on with my sports hall booking database Im looking to implement a method that checks when a coach is available to hire.
My table "Coach" looks as follows:
Coach
=====
Coach_Id
Coach_Name
Availabity_Monday
Availabity_Tuesday
Availabity_Wednesday
Availabity_Thursday
Availabity_Friday
The coaches will be assigned set days of work, i.e Coach 1 works Tues & Fris and Coach 2 works Mon & Thurs.
Also coaches are assigned specialised sports, which Ive implemented a Coach rates table to peform the lookup function.
Coach_rates
========
Coach_Id
Coach_price
Sport
I dont like the idea of having a field per day of the week.
The booking table contains fields
Date, Start_time and End_time.
Perhaps I could use a numeric value to represent day value and then workout day of the week in my booking form.
Another complication is that bookings are made in 30 min installments
and at the moment and this could change I havent catered for the coach to work anything other than a whole set day (as opposed to half days) and to work the same set day every single week. Maybe I could use a week field to allow flexability.
Ideally though I want to keep it simple and working, rather than complicated and not fully functional !!!
Any suggestions would be helpful, thanks again for those who helped on my previous query.
Carrying on with my sports hall booking database Im looking to implement a method that checks when a coach is available to hire.
My table "Coach" looks as follows:
Coach
=====
Coach_Id
Coach_Name
Availabity_Monday
Availabity_Tuesday
Availabity_Wednesday
Availabity_Thursday
Availabity_Friday
The coaches will be assigned set days of work, i.e Coach 1 works Tues & Fris and Coach 2 works Mon & Thurs.
Also coaches are assigned specialised sports, which Ive implemented a Coach rates table to peform the lookup function.
Coach_rates
========
Coach_Id
Coach_price
Sport
I dont like the idea of having a field per day of the week.
The booking table contains fields
Date, Start_time and End_time.
Perhaps I could use a numeric value to represent day value and then workout day of the week in my booking form.
Another complication is that bookings are made in 30 min installments
and at the moment and this could change I havent catered for the coach to work anything other than a whole set day (as opposed to half days) and to work the same set day every single week. Maybe I could use a week field to allow flexability.
Ideally though I want to keep it simple and working, rather than complicated and not fully functional !!!
Any suggestions would be helpful, thanks again for those who helped on my previous query.