POSTGRESQL For this problem create a 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 instructor_course_nums table consisting of the instructor's 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 instructor_course_nums table is up-to-date. You must name your procedure: __insCourseNumsProc Where is your last name and is the day of the month you were born. Below is an example of how I named my procedure: Morab_05__insCourseNumsProc
POSTGRESQL
For this problem create a 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 instructor_course_nums table consisting of the instructor's 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 instructor_course_nums table is up-to-date. You must name your procedure:
<LastName>_<DOB_DayOfMonth>_insCourseNumsProc
Where <LastName> is your last name and <DOB_DayOfMonth> is the day of the month
you were born. Below is an example of how I named my procedure:
Morab_05__insCourseNumsProc
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
