Help with my Helpdesk

i am after a little help with a database, for college.

i posted something a while back on the forum, it is referencing a helpdesk i now need to build it...

i have some tables that i need to link together, which i need some help with.....

table setup as follows



but i also need to work out how i am going to get this whole thing to work properly.


the main issue is, i need to be able to assign jobs to various technicians, and when the next technician becomes available he is then assigned the job...the trouble is i have no idea how i am going to

any suggestions, would be happy to forward my structure to you if ya want to see it??

i have attached the database below:-

cheers

Andy