DELETE FROM dpt_trans;

  UPDATE ar SET department_id = 0;

  UPDATE ap SET department_id = 0;

  UPDATE gl SET department_id = 0;

  DELETE FROM department;

That is it.