You arw given two tables, department and employee, with the following structure:

create table department$($ dept$\_$id integer not null, dept$\_$name varchar$(30)$ not null, dept$\_$location varchar $(30)$ not null, unique$($dept$\_$id$))$;