Hi, This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? Please read all directions and don't just apply any SQL syntax as I must use postgreSQL.MUST USE postgreSQL - LANGUAGE plpgsqlThe tables instructor and teaches have been created as I am working with an existing database. (SEE SCREENSHOT WITH TABLES)CODECREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25));CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))LANGUAGE plpgsqlAS$$BEGINSELECT name INTO instructor_course_nums FROM instructorWHERE ID = instructor.ID;SELECT COUNT(*) INTO instructor_course_nums FROM teachesWHERE instructor_course_nums.ID = teaches.ID;END;$$; 1CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR (25), tot_courses VARCHAR (25));23CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR (25), name VARCHAR(25), tot_courses VARCHAR(25))4LANGUAGE plpgsqlAS$$BEGIN8SELECT name INTO instructor_course_nums FROM instructorWHERE ID =instructor.ID;Jext10SELECT COUNT ( *) INTO instructor_course_nust FROM teaches11WHERE instructor_cours_nums.ID = teaches.ID;12END;13$$;141516171819 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

Answered: 4. For this problem create a table…

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

Hi,

This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? Please read all directions and don't just apply any SQL syntax as I must use postgreSQL.

MUST USE postgreSQL - LANGUAGE plpgsql

The tables instructor and teaches have been created as I am working with an existing database. (SEE SCREENSHOT WITH TABLES)

CODE

CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25));

CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))
LANGUAGE plpgsql
AS
$$
BEGIN
SELECT name INTO instructor_course_nums FROM instructor
WHERE ID = instructor.ID;
SELECT COUNT(*) INTO instructor_course_nums FROM teaches
WHERE instructor_course_nums.ID = teaches.ID;
END;
$$;