Hello,I am working on the stored procedure. However, I am stuck a little and cannot figure out how to get my procedure to run.I did the first part of the question, which is to create the table instructor_course_nums. Then I went on to write the second portion, but I am stuck.Could someone please take a look the stored procedure and help me to get it to run?Code---created table here as first part of the problemCREATE TABLE instructor_course_nums (ID_Number INTEGER,name VARCHAR(30),tot_courses VARCHAR(30),CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (ID_Number));--- second part of the problem. See procedure belowCREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$DECLAREins_name VARCHAR(35);BEGINSELECT name INTO ins_name FROM instructor WHERE instructor.id = i_id;SELECT COUNT(*) INTO instructor_course_nums FROM teaches WHERE teaches.id = i_id;SELECT COUNT(*) INTO instructor_course_nums FROM instructor_course_nums WHERE instructor_id= i_id;END;$$;Thank you so much! 4. For this problem create a table called instructor_course_nums. Write a procedure thataccepts an instructor ID as input. The procedure calculates the total number of coursesections taught by that instructor, and adds a tuple to the instructor_course_nums tableconsisting of the instructors ID number, name, and total courses taught - call theseattributes: 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 theinstructor_course_nums table is up-to-date. You must name your procedure:__insCourseNumsProcWhere is your last name and is the day of the monthyou were born. Below is an example of how I named my procedure:Morabito 05 inscourseNumsProc ---created table here as first part of the problemCREATE TABLE instructor_course_nums (13ID_Number INTEGER,4name VARCHAR (30),5tot_courses VARCHAR (30),6CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (ID_Number)7) ;9--- second part of the problem. See procedure below10CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc (INOUT i_ID VARCHAR (5))11LANGUAGE PLPGSQL12AS13$$14DECLARE15ins_name VARCHAR (35);16 VBEGIN17SELECT name INTO ins_name FROM instructor WHERE instructor.id = i_id;18SELECT COUNT (*) INTO instructor_course_nums FROM teaches WHERE teaches.id = i_id;...........................................19SELECT COUNT (*) INTO instructor_course_nums FROM instructor_course_nums WHERE instructor_id= i_id;20END;21$$;2223Data OutputExplainMessagesNotificationsERROR:"instructor_course_nums" is not a known variableLINE 9:SELECT COUNT (*) INTO instructor_course_nums FROM teaches W...SQL state: 42601Character: 235

Hi, I analysed the code already written and can find some issues there. 1) The below statement…

Answered: Hello, I am working on the stored…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Hello,

I am working on the stored procedure. However, I am stuck a little and cannot figure out how to get my procedure to run.

I did the first part of the question, which is to create the table instructor_course_nums. Then I went on to write the second portion, but I am stuck.

Could someone please take a look the stored procedure and help me to get it to run?

Code

---created table here as first part of the problem
CREATE TABLE instructor_course_nums (
ID_Number INTEGER,
name VARCHAR(30),
tot_courses VARCHAR(30),
CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (ID_Number)
);

--- second part of the problem. See procedure below
CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))
LANGUAGE PLPGSQL
AS
$$
DECLARE
ins_name VARCHAR(35);
BEGIN
SELECT name INTO ins_name FROM instructor WHERE instructor.id = i_id;
SELECT COUNT(*) INTO instructor_course_nums FROM teaches WHERE teaches.id = i_id;
SELECT COUNT(*) INTO instructor_course_nums FROM instructor_course_nums WHERE instructor_id= i_id;
END;
$$;

Thank you so much!