(MySQL)

-Write an inner join, natural join, left outer join, and exclusive left outer join, right outer join, exclusive right outer join, full outer join, and exclusive outer join for the tables DEPARTMENT and COURSE. Also, think about a question that could be answered with your query.

PLEASE EXPLAIN!

create table department (dept_name varchar(20), building varchar(15), budget numeric(12,2) check (budget > 0), primary key (dept_name) );

create table course (course_id numeric(8,0), title varchar(50), dept_name varchar(20), credits numeric(2,0) check (credits > 0), primary key (course_id), foreign key (dept_name) references department (dept_name) on delete set null );