You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL.
The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, PropertyId, RentalPrice, Size),Customer (choose appropriate attributes), Rentals (choose attributes; this relationshould describe who rents what, since when, and until when), and Payments (shoulddescribe who paid for which unit, how much, and when).
Assume that a customer canrent more than one unit (in the same or different properties) and that the same unit can be co-rented by several customers.