DATABASE SYSTEMS:Functions

Problem 1 Calculating total for the reservation (Function)

The total cost for the rental is calculated based on the number of days and the cost of the vehicle. An additional tax of 12% is added to the total. If the rental is longer than 10 days a discount of 15% is subtracted from the total cost. Create a function to calculate TOTAL_COST for a specified reservation id (R_ID).

Problem 2 Offering a X-Mas discount for the reservation (Function)

Create a function to calculate TOTAL_COST for a new reservation in the month of December. A discount of 15% is offered on the total deal (before tax) if one of the days of booking is X-Mas.

VEHICLE V ID VIN V MAKE COST_PER_DAY RESERVATION R ID START_DATE END_DATE C ID V ID TOTAL_COST CLIENT C ID Name1 Name Z F NAME L NAME DOB CITY GENDER ARCHIVED RESERVATION R ID START_DATE END DATE C ID V ID TOTAL_COST ADDED BY ADDED DATE BLACK LIST C ID F NAME L_NAME DOB CITY GENDER REASON ADDED BY ADDED_DATE STATS YEAR C ID AGE GENDER TOT RESERVATIONS TOT_DAYS_OF_RESERVATIONS TOT COST_OF_RESERVATIONS