Create a conceptual schema for SQL (MySQL) from this "The purpose of the CTC acres real estate system is to assist agents as they sell houses. Sellers contact the agency, and an agent is assigned to help the seller complete a listing request. Information about the house and lot taken from that request is stored in a file. Personal information about the sellers is copied by the agent into a sellers file.

When a buyer contacts the agency, he or she fills out a buyer request. Every two weeks, the agency sends prospective buyers area real estate listings and an address cross reference listing containing actual street addresses. Periodically, the agent will find a particular house that satisfies most or all of a specific buyer’s requirements, as indicated in the buyer’s requirements statement distributed weekly to all agents. The agent will occasionally photocopy a picture of the house along with vital data and send the multiple listing statements to the potential buyer.

When the buyer selects a house, he or she fills out an offer that is forwarded through the real estate agency to the seller, who responds with either an offer acceptance or a counteroffer. After an offer is accepted, a purchase agreement is signed by all parties. After a purchase agreement is notarized, the agency sends an appraisal request to an appraiser, who appraises the value of the house and lot. The agency also notifies its finance company with a financing application. "