Solved: SQL. Professor: ID, NAME, DEPARTMENT_ID, SALARY. D
A university maintains data on professors, departments, courses, and schedules in four tables: DEPARTMENT, PROFESSOR, COURSE, and SCHEDULE. The university's new Dean is streamlining their scheduling and wants to know which changes would be necessary to ensure that each professor only teaches courses within their own department.