Answered: For this problem create a table called…

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

I cannot figure out this problem/question. Can someone help me solve this?

I must use use postgreSQL to answer the question.

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 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 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:
Morabito_05__insCourseNumsProc