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

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:30
Use the keyword strategy to remember the meaning of the following word. the meaning for the word has been provided. write your keyword and describe the picture you would create in your mind. centurion: a commander in the army of ancient rome. keyword: picture:
Answers: 2
question
Computers and Technology, 22.06.2019 15:00
I'm taking a class on how to make a movie, and it offers some apps that would be in the process. the thing is, i don't have any of those ha. if you have any tips on some apps i could use, that would be awesome. i don't have an iphone, so don't suggest any apps like imovie. i know that this is a weird question, but it would be super for me. : )
Answers: 2
question
Computers and Technology, 23.06.2019 16:00
Kenny works with an it company. his company is about to launch new software in the market. he has to ensure that this new software is functional and meets all of the quality standards set up at the planning stage. which job profile is kenny likely to have? kenny is likely to have the job profile of a blank .
Answers: 2
question
Computers and Technology, 23.06.2019 17:00
The camera still is bad even with the new iphone xr and especially in low light it is even worst because you can see the pixels more if its in low light. if all you apple customers want apple to fix this then lets fill there feedback with complaints about the
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
question
Social Studies, 02.09.2019 18:50
question
Mathematics, 02.09.2019 18:50
question
Social Studies, 02.09.2019 18:50
question
History, 02.09.2019 18:50
Questions on the website: 13722367