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;