Using the SQL script below, how can I do the following?

a. Modify the database to reflect that two new properties (property # 7 and 8) were added by the

renting company and two new renters (renter # 5 and 6) rented these new properties from Nov 1, 2010

[You can make up property and renter details]

b. Show property number, property rent, and renters’ name for all the properties that were rented in

any part of year 2010.

c. Show rental history (renter number, renter name, and rent start date, end date) of the properties

that are currently in rent.

Drop