Convert all relations to third normal form, if necessary, and draw a revised relational schema

Suggest an integrity constraint that would ensure that no property is rented twice during the same time interval.

PROPERTY Property ID Street Address City State Zip RENTER Renter ID First Name Middle Initial Last Name Address Phone# E Mail RENTAL AGREEMENT Agreement ID End Date Rental Amount Nbr Rooms BooksBase Rate Property Type Property Type = M" BEACH PROPERTY MOUNTAIN PROPERTY Blocks to Beach (Activity)