Determine the output of the following program segments when they are executed: DECLARE-main PROCEDURE p (sales NUMBER) IS bonus NUMBER:-0; BEGIN IF sales > 50000 THEN bonus : 1500; ELSIF sales > 35000 THEN bonus := 500; ELSE

Determine the output of the following program segments when they are executed: DECLARE-main PROCEDURE p (sales NUMBER) IS bonus NUMBER:-0; BEGIN IF sales > 50000 THEN bonus : 1500; ELSIF sales > 35000 THEN bonus := 500; ELSE

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: After the information is entered for each floor, the program calculates the following: - Hotel…

A: do while is a loop that check condition at the exit time Syntax do { //statements to be executed…

Q: hallenge Problem (pyhton) T E S T S C O R E S Write a program that…

A: Program Approach: 1- As mentioned in the assignment created the main function. 2- def keyword used…

Q: A software company sells a package that retails for $99. Quantity discounts are given according to…

A: Program: #get the input from the user num = float(input("Enter the number of packages purchased: "))…

Q: paython programing question Write the following program without using the break statement. You may…

A: Program explanation - In this program , when the value of i gets first odd number,then it will print…

Q: Problem Statement Create a program that will determine whether a triple can generate a triangle and…

A: The python program is given below:

Q: Guessing Game in Matlab . When the program starts, a random whole number , n , is selected where…

A: Algorithm: Start Generate a random whole number in the range 1-200 and store it in r Initialize n…

Q: PROGRAM 6: Three Zero Game Write an HLA program that reads a number. Then by subtracting off a…

A: error 404

Q: Write a program using a Loop structure that takes Five inputs of sales for item 1 – item 5 from the…

A: C++ code with output

Q: The pseudocode below is supposed to determine a student�s letter grade based on the student's exam…

A: Pseudocode: Pseudocode is writing the program instructions in a simple English language. Pseudocode…

Q: Determine the output of the given program segment. Assume the following initialization: int x =5, y…

A: Solution - In the given question, we have to determine the output of the given program segment.

Q: oblem: Calculate movie charges for each customer attending a movie, use a sentinel value, -1, to…

A: Note: Since no programming language is mentioned. I am attempting this in python. if you need it in…

Q: This function determines the winner of the match based on the score totals for all the rounds. The…

A: Explanation: In below program, input for the final score has been taken by the user and passed it to…

Q: Write a program that uses an if-elif-else statement to determine a traveling schedule. 1) request…

A: 'date'print ("Enter the your_date between(1-31).")date = int(input())if (date<1): print…

Q: Write a program that displays an appropriate message for a given employee based on the criteria…

A: The syntax of the if...else if...else statement is: if (condition1) { // code block 1 } else if…

Q: ) Guessing Game in Matlab . When the program starts, a random whole number , n , is selected…

A: The answer to the following question:-

Question

Determine the output of the following prograrm segments when they are executed:
DECLARE-main
PROCEDURE p (sales NUMBER)
IS
bonus NUMBER: 0;
BEGIN
IF sales> 50000 THEN
bonus :- 1500;
ELSIF sales > 35000 THEN
bonus := 50%3B
ELSE
bonus := 10%3B
END IF:
DBMS OUTPUT.PUT_LINE ('Sales =' || sales ||', bonus ='|| bonus ||');
%3D
%3D
END p;
BEGIN - main
p(55000):
p(40000);
p(30000):
END3:
Use the edito tomeo

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

4. Follow the debugging exercise given below and write the correct pseudocode for the problem.
in phython language Write the following program without using the break statement. You may use conjunction of conditions (and). i = 0 while i <= 5 : if i % 2 == 1: break print("*") i += 1
Quèstion 25 By default the compiler is always responsible to set the step-size for a loop variable in a counting iterative statement. True False
The Salary Program: Modify the program from the textbook (Program 1-1,see below) which reads the number of hours an employee works reads the pay rate per hour computes the pay for the employee. Add the following steps: a) Read an amount of bonus paid to the employee.b) Compute the total pay as pay plus bonus.c) Compute the tax at 30% of the total pay.d) Compute the net pay as total pay minus tax, and e) Print a report showing: total pay, tax deduction, and net pay. Algorithm: 1. Prompt the user for number of hours.2. Read the value for hours.3. Prompt the user for hourly rate.4. Read the hourly rate.5. Prompt the user for amount of bonus.6. Read the value for bonus.7. Compute the pay.8. Compute the totalPay by adding bonus to pay.9. Compute the tax deduction by multiplying 30% times totalPay.10. Compute the netPay by subtracting tax from totalPay.11. Neatly print and label the following: a. totalPay b. tax c. netPay Put your…
Please answer in matlab code.
Inputs of mortgage calculator that determines a monthly payment for loans and produces an amortization schedule for the life of the loan(10-15-20) years fixed loan with 4.5% interest rate and Principal 100000$. The program should initially prompt the user for 1) the principal of the loan. 2)It should then ask him or her to enter an annual interest rate for the loan. 3)The final input should be the number of years that the loan will be outstanding. Because the company only offers three different terms (10-, 15-, and 30-year loans), the program should ensure that no other terms are entered. P = $100,000 r = 4.50% per year / 12 months = 0.375% (or 0.00375) per period n = 15 years * 12 months = 180 total periods A = 100,000 * (.00375 * (1 + .00375)180)/((1+.00375)180 – 1) Using these numbers in the formula above yields a monthly payment of $764.99. Amortization schedule: The Interest portion of the payment is calculated as the rate (r) times the previous balance and should be rounded to…