a. (7 pts) Formulate a SQL query: In the course table, remove all courses that do not have any corresponding course section. No screenshot is needed.

b. (6 pts) After the statement in a is executed, what will happen to rows in other tables (e.g., prereq) that has a foreign key to course.course_id and depend on the rows that were removed in a? why (be very specific)?

The enclosed.sql file defines the following university database where primary key for each table is underlined department.dept-name is primary key (i.?., unique) course.title is not unique instructor.name is not globally unique but is unique within the department student.name is not globally unique but is unique within the department student takes ID ID name dept name tot cred section course department advisor title dept name credits s id i id semester building budget time slot ilding room ?10 time slot id end time instructor classroom ID ame dept name teaches ID sec id ear capacity salary The enclosed.sql file defines the following university database where primary key for each table is underlined department.dept-name is primary key (i.?., unique) course.title is not unique instructor.name is not globally unique but is unique within the department student.name is not globally unique but is unique within the department student takes ID ID name dept name tot cred section course department advisor title dept name credits s id i id semester building budget time slot ilding room ?10 time slot id end time instructor classroom ID ame dept name teaches ID sec id ear capacity salary