Oracle Constraints

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mzfp2
Forum Contributor
Posts: 137
Joined: Mon Nov 11, 2002 9:44 am
Location: UK
Contact:

Oracle Constraints

Post by mzfp2 »

Hi this is pretty mind boggling so im wondering if anyone here can help.

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]
Post Reply