(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 classroom and section. Also, think about a question that could be answered with your query.

PLEASE EXPLAIN!

create table classroom (building varchar(15), room_number numeric(7,0), capacity numeric(4,0), primary key (building, room_number) );

create table section (course_id numeric(8,0), sec_id numeric(8,0), semester varchar(6) check (semester in ('Fall', 'Winter', 'Spring', 'Summer')), year numeric(4,0) check (year > 1701 and year < 2100), building varchar(15), room_number numeric(7,0), time_slot_id varchar(4), primary key (course_id, sec_id, semester, year), foreign key (course_id) references course (course_id) on delete cascade, foreign key (building, room_number) references classroom (building, room_number) on delete set null );