170. Suppose that we wanted to drop all of the
tables. In what order must we do it (CAUTION:
REMEMBER THAT DEPARTMENT AND INSTRUCTOR BOTH REFER TO EACH OTHER)
drop table enrollment;
drop table student;
drop table major;
drop table class;
drop table classrooms;
drop table building;
drop table semester;
drop table course;
Alter table department drop constraint department_deptchair_fk;
alter table instructor drop constraint instructor_dept_FK;
drop table instructor;
drop table department;