subject

Write a PL/SQL procedure that given a rental ID and time of returning the tool, compute and print out total due. Please handle the following cases: 1) in case the rental ID does not match any existing rental, print a message saying invalid rental ID; 2) if the return time is before due time, the total equals number of time units in the rental table * unit price of the tool. E. g., if a tool is rented for 5 hours and hourly rate is $6, the total is $30. 3) if the return time is after due time, you need to compute a late charge. The late charge is number of extra hours (from return time to due time) * hourly price. Any fraction of an hour will be rounded up. E. g., if someone suppose to return a tool by 2 pm but he returned at 3:30 pm. he needs to pay 2 extra hours. Finally please update the rental table to set the end time (due time), return time and total.

ansver
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 04:30, Lilabbychichi
Ryan is working on the layout of her web page. she needs to figure out where her header, navigation bar, text, and images should go. what technique can her?
Answers: 1
image
Computers and Technology, 22.06.2019 10:30, robert7248
You have a large, late-model pick-up truck with a rear seat. the pick-up truck weighs 6,500 pounds. the florida seat belt law
Answers: 1
image
Computers and Technology, 22.06.2019 13:50, juan3937
The instruction ishl (shift left integer) exists in jvm but not in ijvm. it uses the top two values on the stack, replacing the two with a single value, the result. the sec- ond-from-top word of the stack is the operand to be shifted. its content is shifted left by a value between 0 and 31, inclusive, depending on the value of the 5 least signifi- cant bits of the top word on the stack (the other 27 bits of the top word are ignored). zeros are shifted in from the right for as many bits as the shift count. the opcode for ishl is 120 (0x78).a. what is the arithmetic operation equivalent to shifting left with a count of 2? b. extend the microcode to include this instruction as a part of ijv.
Answers: 1
image
Computers and Technology, 23.06.2019 01:50, akornegay2
Write a program that uses a random number generator to generate a two digit positive integer and allows the user to perform one or more of the following operations: a. double the number. b. reverse the digits of the number. c. raise the number to the power of 2, 3, or 4. d. sum the digits of the number. e. if the number is a two-digit number, then raise the first digit to the power of the second digit. f. if the number is a three-digit number and the last digit is less than or equal to 4, then raise the first two digits to the power of the last digit. after performing an operation if the number is less than 10, add 10 to the number. also, after each operation determine if the number is prime. each successive operation should be performed on the number generated by the last operation. your program should not contain any global variables and each of these operations must be implemented by a separate function. also, your program should be menu driven. 7. (fraction calculator) write a program that
Answers: 1
You know the right answer?
Write a PL/SQL procedure that given a rental ID and time of returning the tool, compute and print ou...

Questions in other subjects:

Konu
Medicine, 17.07.2020 19:01