Thread: constrains on two tables

Hi

Here is my table:

Table School
(
    id integer,
    name text
);

Table Department
(
    id integer,
    school_id integer reference school(id),
    name text
);

Table Course
(
    department_id integer references department(id),
    name text,
    course_number text
)

I would like to make the course_number unique, but not in the course
table, nor in department. I would like to make the course_number
unique in the scope of School. So, you may see the same course_number
in Course table, but (school_id, course_number) should be always
unique. How can I make the constrain?

Thanks,

ff