the low down on the date requirements :
Three tables Staff, Departments and Courses
Each department may offer many courses, each course has a course leader and adminstrator.
A course is leader and adinstrator is a member of Staff.
A member of staff can be theleader and adminstrator of more than on course, but they must come from the same department
The bit underlined i presume would either require a constraint, or some special database design .. but its totally got me confused
Muz[/i]