Using the following Database Schema: branch ( branch_name, branch_city, assets ) customer ( I D, customer_name, customer_street, customer_city ) loan ( l oan_number, branch_name, amount ) borrower ( I D, l oan_number ) account ( a ccount_number, branch_name, balance ) depositor ( I D, account_number )

In postgresql 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.