Database Systems:Procedures

Problem: Black list (Stored Procedure)

Create a store procedure to add clients to the Black list. The input parameters are C_ID and a string of characters for the reason. Insert all client information, the reason , and the USER NAME (STU.) and date/time. The procedure should also delete the client from the clients table

Problem: Displaying the details of reservation for a vehicle

V_id is passed and the details of all the reservations for that car needs to be displayed

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 2 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 NAE DOB CITY GENDER REASON ADDED BY ADDED_DATE STATS YEAR C ID AGE GENDER TOT_RESERVATIONS TOT DAYS OF RESERVATIONS TOT COST OF_RESERVATIONS 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 2 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 NAE DOB CITY GENDER REASON ADDED BY ADDED_DATE STATS YEAR C ID AGE GENDER TOT_RESERVATIONS TOT DAYS OF RESERVATIONS TOT COST OF_RESERVATIONS