Iam working on a database and would like to write code to asign lecturers time ,and days of lecture automatically.I so far have this select stattement that matches the lecturers and their speciality.
(select Courseunits.courseunitcode,lect_skill.courseunitcode where
Courseunits.courseunitcode =lect_skill.courseunitcode;)
now my problem is :how can I assign them to various days of week and hours and different classes.for every lecture must take 2hrs lectures for a unit,not more than 2 classes per day.