For this problem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the temporary table is up-to-date.

student takes ID course_id sec_id semester year grade ID name dept_name tot_cred section course id sec id course course_id title dept_name credits department dept_name building budget advisor s_id i_id semester year building room_no time_slot_id time_slot time slot id day start_time end_time classroom building room no capacity prereq course id prereq id instructor ID name dept_name salary teaches ID course id sec id semester year