Expert Homework Help Online & Write My Essay Service

Hire best homework helpers for online homework help 24/7. Are you looking for online homework help? Try our excellent homework help who can help you get A+ grade in your assignment.

Order my paper
Calculate your essay price
(550 words)

Approximate price: $22

19 k happy customers
9.5 out of 10 satisfaction rate
527 writers active

Hi,  For this proble I need to create a table called instructor_course_nums within a university database schema. 1. I need to 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. 2. 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. Here is what I have that answers the first part of the question: CREATE TABLE instructor_course_nums (         id                varchar (10),         name            varchar (30),         tot_courses        integer,  CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (id));     CREATE OR REPLACE PROCEDURE Student_00_insCourseNumsProc(ID varchar(10), 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;       $$;          CALL Student_00_insCourseNumsProc(”); The code I have here  the prof in the new table with the total number of courses they’ve taught. My issue is that I am unable to figure out how to get the table to update when new information is added. Help is gratly appreciated! Thank you!

Hi, 

For this proble I need to create a table called instructor_course_nums within a university database schema.

1. I need to 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.

2. 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.

Here is what I have that answers the first part of the question:

CREATE TABLE instructor_course_nums (
        id                varchar (10),
        name            varchar (30),
        tot_courses        integer,
 CONSTRAINT instructor_course_nums_pkey PRIMARY KEY (id));   

CREATE OR REPLACE PROCEDURE Student_00_insCourseNumsProc(ID varchar(10), 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;
      $$;

CALL Student_00_insCourseNumsProc(”);

The code I have here  the prof in the new table with the total number of courses they’ve taught. My issue is that I am unable to figure out how to get the table to update when new information is added. Help is gratly appreciated! Thank you!

See also  C++ PROGRAMMING LANGUAGE FOR THE SOLUTION PLEASE!!!! Problem Statement You are to develop a program to define and test an object class whose instances will be used to store some data of a basketball player. We use this information to compute some statistics about our basketball players. A basketball player will have the following data: firstname lastname gamesplayed minsplayed fieldgoals threepoints freethrowsmade rebounds assists steals The 8 statistics are integers and must be stored in a single array within a Player object.   Your class needs to provide all the methods needed to: provide a default constructor for your Player class default first and last name are "unknown" default integer values are 0 read a player's data from a single line of input These will be used later when we start reading records of data from an input file. The next iteration of this program will read a player from a single line of input file, so we want to set this up to make that easier to reuse. You will pass a parameter that is a referenced to an istream. This function will assume the next line of input on that stream is valid. We will use cin as the stream to test it with. I will discuss this during the C++ review in class. The reader method MUST NOT print messages to or prompt the user for data. It is a utility only. Get methods for any data the test driver program might need to display on the screen later (at a minimum gets to retrieve each name and the values needed for this program’s output) compute the Player's Points per game and Minutes played per game Any other methods you need to solve the problem.   TEST DRIVER Once you have developed a good class definition, you need to write a "test" main program to test it out.  Your test program should declare a variable of type Player and then prompt the user for the data to be set into the object.  Use the player class reader method to retrieve the values from the input stream. Then, display the characteristics of the Player for the user to the screen. Note that all interactive prompts are coming from the main program.  The Player object itself is passive - it is not doing the prompting for values. All values are read into the object by using its methods.
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: