l 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: __insCourseNumsPro
Question-. For this problem create a table called instructor_course_nums within the university
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: Morabito_05__insCourseNumsProc
instructor table data: id character varying(5), name character varying(20) , dept_name character varying(20) , salary numeric(8,2)
teaches table data attributes : id character varying(5), course_id character varying(8), sec_id character varying(8), semester character varying(6), year numeric(4)
need to create table instructor_course_nums with attribute as per given in question. these are call these attributes: ID, name, and tot_courses
NOTE: language must be PLPGSQL and able to run in pgadmin.
i checked earlier answers from this site but those won't work. FYI
please explain answer as well so i can understand.
Step by step
Solved in 2 steps