Computers and Technology, 17.04.2020 01:04 shannaslaughter28

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.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 08:40

What are the three parts to physical security standards for various types of army equipment and the risk level

Answers: 2

Answer

Computers and Technology, 23.06.2019 04:00

Laire writes a letter to her grandmother, in which she describes an amusement park she visited last week. she adds pictures of that place in her letter. which feature of a word processing program will claire to remove unwanted parts of the pictures?

Answers: 3

Answer

Computers and Technology, 23.06.2019 11:00

This chapter lists many ways in which becoming computer literate is beneficial. think about what your life will be like once you’re started in your career. what areas of computing will be most important for you to understand? how would an understanding of computer hardware and software you in working from home, working with groups in other countries and contributing your talents.

Answers: 1

Answer

Computers and Technology, 23.06.2019 11:30

Me dangers of social media and the internetexplain what each means: 1) social media and phones have become an addiction.2) outside people have access to you all the time.3) cyberstalking4) cyberbullying5) catphishing6) viruses7) identity theft8) credit card fraud9) hacking10) money schemes

Answers: 1

Answer

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