student takes ID ID cOurse_id sec_id semester year grade пате dept_name tot_cred section course department advisor course_id sec_id semester year building course_id title dept_name credits dept_name building budget s_id i_id time_slot time_slot_id_ day start_time end_time room_no time_slot_id prereq instructor classroom course_id prereg_ id ID building room_no сарасity пате dept_name salary teaches ID course_id sec_id semester уеar

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
icon
Concept explainers
Question
100%

For this problem create a (temporary) 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 temporary 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 temporary table is up-to-date. (Schema pic attached)

student
takes
ID
ID
course_id
sec_id
semester
year
grade
пате
dept_name
tot_cred
section
course
|department
course_id
sec id
semester
course_id
advisor
title
year
building
dept_name
credits
dept_name
building
budget
s_id
i_id
time_slot
time_slot_id
day
start_time
end_time
room_no
time_slot_id
prereq
instructor
classroom
course_id
prereg id
ID
building
room no
сараcity
пате
dept_name
salary
teaches
ID
course id
sec_id
semester
уеar
Transcribed Image Text:student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course |department course_id sec id semester course_id advisor title year building dept_name credits dept_name building budget s_id i_id time_slot time_slot_id day start_time end_time room_no time_slot_id prereq instructor classroom course_id prereg id ID building room no сараcity пате dept_name salary teaches ID course id sec_id semester уеar
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage