Assume that we have the database schema for table Occupant and Rental for a House Rental management system. Rental (Rent
Posted: Fri Jul 08, 2022 6:35 am
Assume that we have the database schema for table Occupant andRental for a House Rental management system.
Rental (RentalID, OccupantID, Rental_AgentID,Rental_startDate, monthlyRental)
Occupant (OccupantID, RentalID, OccupantName, Gender,DateofBirth, PhoneNo)
WRITE the SQL query to create and executea procedure to give a 3% reduction from the amount of monthlyrental for all rentals when the years of stay have exceeded 5years.
(9 marks)
Rental (RentalID, OccupantID, Rental_AgentID,Rental_startDate, monthlyRental)
Occupant (OccupantID, RentalID, OccupantName, Gender,DateofBirth, PhoneNo)
WRITE the SQL query to create and executea procedure to give a 3% reduction from the amount of monthlyrental for all rentals when the years of stay have exceeded 5years.
(9 marks)