a.Explanation of the system design
The first step of the system design begins by creating four tables named property information, advertising, clients and other properties. Property information table includes information as the follows: property ID, property type, number of bedrooms, price, size...