Assume that we have the database schema for table Occupant and Rental for a House Rental management system. Rental (Rent

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Assume that we have the database schema for table Occupant and Rental for a House Rental management system. Rental (Rent

Post by answerhappygod »

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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”