Answer:
The procedure in SQL is created as follows
Explanation:
--creating the procedure
CREATE OR REPLACE PROCEDURE prc_inv_amounts (W_IN IN NUMBER)
AS
--defining variables
W_CK NUMBER := 0;
W_SUBT NUMBER := 0;
W_TAX NUMBER := 0;
BEGIN
--Authentication process of the invoice
SELECT COUNT(*) INTO W_CK FROM INVOICE WHERE INV_NUMBER := W_IN;
--Transaction confirmation
IF W_CK = 1 THEN
SELECT SUM(LINE_TOTAL) INTO W_SUBT FROM LINE
WHERE
--checking the invoice for the desired invoice number
LINE.INV_NUMBER = W_IN;
W_TAX :=W_SUBT * 0.08;
--updating the invoice
UPDATE INVOICE
--setting the new values
SET INV_SUBTOTAL = W_SUBT,
INV_TAX = W_TAX,
INV_TOTAL =W_SUBT + W_TAX
WHERE INV_NUMBER = W_IN;
--ending the if statement
END IF;
--ending the procedure
END;
Try using at least one capital letter and multiple number and symbols
Example:
[email protected]#3
Answer:
while (userNum >=0) {...}
Explanation:
In a <u>while loop</u>, <u>the loop is executed until the condition is false</u>.
Since the loop will execute while the user enters a number greater than or equal to 0 (and that number is declared as <em>userNum</em>), we need to check if <em>userNum</em> is greater than or equal to 0.
Answer:
Previous decisions were flawed
Explanation:
An algorithm depends entirely on the data input into the system in the decision making process.
As such, when there are conclusions in the data set used by the algorithm for decision making which are distorted, such as the association of less individuals that drink and drive in the rich cities than can be found in poorer communities due to the presence of less bars uptown and as such drivers from uptown areas are given preference may include a bias that is due to conclusion on which the previous decisions were made and used in the algorithm which may have been flawed or need more detailed analysis
Answer:
public class SimpleSquare{
public int num;
private int square;
public SimpleSquare(int number){
num = number;
square = number * number;
}
public int getSquare(){
return square;
}
}
Explanation:
*The code is in Java.
Create a class called SimpleSquare
Declare two fields, num and square
Create a constructor that takes an integer number as a parameter, sets the num and sets the square as number * number.
Since the square is a private field, I also added the getSquare() method which returns the value of the square.