Computers and Technology, 19.04.2021 15:50 ryansingl19

Write a PL/SQL procedure that assigns a reviewer to a paper in a certain round of review. The input includes a paper ID, reviewer ID, round, and due date. The procedure does ALL of the following: a. First check whether there is a paper with the given paper ID, if not, print an error message 'Wrong paper ID' and stop;
b. Next check whether there is a reviewer with the input reviewer ID. If not, print an error message 'wrong reviewer ID' and stop.
c. Next check whether there is already a row in paper_review with given paper ID, reviewer ID, and round. If so, print a message 'Already assigned' and stop.
d. Now check whether there is a conflict of interest, i. e., whether any author of the paper and the input reviewer has the same affiliation. If a conflict exists, print a message 'X and Y have conflict of interest' where X and Y are the names of author and reviewer with the same affiliation and stop. Please note that a paper may have multiple authors with the same affiliation with the reviewer.
e. If none of the above happens, insert a row to paper_review with given paper ID, reviewer ID, round, due date, and give null values to receive_date, decision and comment. Please use a sequence to generate new prid and print out the new prid. Please include the drop sequence and create sequence command before the procedure creation code such that your procedure can be created correctly.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 07:00

Robots with telescoping arms are sometimes used to perform tasks (e.g., welding or placing screws) where access may be difficult for other robotic types. during a test run, a robot arm is programmed to extend according to the relationship r = 3 + 0.5cos(4θ) and the arm rotates according to the relationship θ=−π4t2+πt , where r is in feet, θ is in radians, and t is in seconds. use a computer program to plot the path of tip a in x and y coordinates for 0 ≤ t ≤ 4s.

Answers: 2

Answer

Computers and Technology, 22.06.2019 22:00

Consider the following declarations (1, 2, 3, 5, 7)class bagtype{public: void set(string, double, double, double, double); void print() const; string getstyle() const; double getprice() const; void get(double, double, double, double); bagtype(); bagtype(string, double, double, double, double); private: string style: double l; double w; double h; double price; }; a.) write the definition of the number function set so that private members are set according to the parametersb.) write the definition of the member function print that prints the values of the data membersc.) write the definition of the default constructor of the class bagtype so that the private member variables are initialized to "", 0.0, 0.0, 0.0, 0.0, respectively d.) write a c++ statement that prints the value of the object newbag.e.) write a c++ statement that declares the object tempbag of type bagtype, and initialize the member variables of tempbag to "backpack", 15, 8, 20 and 49.99, respectively

Answers: 3

Answer

Computers and Technology, 24.06.2019 08:30

Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.

Answers: 1

Answer

Computers and Technology, 24.06.2019 11:30

Why is body language an important factor in a business meeting

Answers: 1

Answer

You know the right answer?

Write a PL/SQL procedure that assigns a reviewer to a paper in a certain round of review. The input...

Questions