Complex, Prevent lesson double booking

[2 Advanced]

Hi, i searched through some of the threads on how to prevent double booking but my concept is too much complex to prevent from double booking..which i think it is..nehow.


Right, my database is about client booking a driving lesson. One instructor can have many clients but one client can have one instructor. So i would need to prevent client booking with another instructor.. ne ideas?

If a client books a lesson, i have to prevent a lesson being double booked if the client's instructor already have a lesson been booked on the same day/time.

Also i made a seperate Theory and Practical tables. If a client book a normal lesson, e.g. 22/03/2008 Time: 01:00 and the same client books Theory/Practical on the same date and time as normal lesson.. i wondered is there a solution how i can go about with this and prevent several date and times from Theory, Practical and Lesson clashing.

It sound silly that a client would want to book lesson, and theory on same day and time but you never no..lol.

Ne help would be gr8ful, hope its clear to understand, if not, i have a relationship consisting 12 tables to explain it. lol.

Thanks and Much Appreciated!

 

[gemma-the-husky]

can a client REALLY not have a different instructor

what if his regular guy leaves/is ill etc etc

 

[2 Advanced]

can a client REALLY not have a different instructor

what if his regular guy leaves/is ill etc etc

Yeah, i can see your point, if the regular guy leaves..(most likely not, under a duty of contract they've signed), in other circumstances of regular guy leaves, he'll be assigned with another, if ill, then lesson will be cancelled and rescheduled, like in rl. Rather having another instructor to fill in for them.

If i allowed client to have different instructor, its difficult for instructors to assess the clients, where instructor assess differently to one of the other which would cause problems.

Generally..its best that a client sticks with one instructor, so a form of client to instructor relationship develops....i'm getting carried away now..

Nehow, i'm restricting limitations so it doesn't get carried away.