Question: Write 1 procedure or 1 function for each question and test them; please give the correct run screenshot,,,, DO NOT give useless SQL codes..... 5.

Write 1 procedure or 1 function for each question and test them; please give the correct run screenshot,,,, DO NOT give useless SQL codes.....

5. When client is returning the car (can pass reservation ID or client ID): The reservation ID is given. If a reservation is for more than 10 days, a 10% discount is offered If the reservation in having Christmas day in between, a 20% discount is offered. Now calculate the cost and ask for the payment. If client is not paying, or car is broken by the client, the client is moved to black list table with the reason

6. At the end of every year, the reservation table is emptied out (Leaving the records without end_date), The data is moved to the archieved_reservation

8. Stats are generated and copied to the stats table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

hi, I want you to help me to continue my left problems, I did not know why shows 'no data found' in my SQL code run. please help me to finish questions 5 6 7 ,8,9. there is my left questions: and...

Write the SQL function with the question and test the function; please provide the correct run screenshot! write this function in SQL !!!!! 5. When client is returning the car (can pass reservation...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

This is from my Computer Networks and Data Communication Class: Please Provide me all the details as it asks in the assignment (If you fail to provide details i will loose massive points) I want...

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Please read chapter 8 and answer the questions and see the (guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and write...

Please read chapter 8 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

C++ Programming Problem. Please note the following: 1. Please go through ALL directions carefully. 2. This is a C++ programming problem, so please use C++ language, not C, Java, etc. Also note the...

Determine the force in each member of the truss and state if the members are in tension orcompression. 10 kN 8 kN 4 kN 3 kN 1.5 m 2 m

Consider the process of food orders delivery to the customers after online ordering through Uber Eats or a similar service provider. Please respond the following questions based on the information...

Assess the advantages and disadvantages of investing in property by considering the relationship between risk and return

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...