write SQL code (including the constraints) for this question

A real estate firm keeps track of the houses for sale and customers looking to buy houses. A house for sale can be listed with the firm or with a different one. Being "listed with a firm means that the house owner has a contract with an agent who works for that firm. Each house on the market has price, address, owner, and a list of features, such as the number of bedrooms, bathrooms, type of heating, appliances, size of garage, and the like. This list can be different for different houses, and some features can be present in some houses but missing in others. Likewise, each customer has preferences that are expressed in the same terms (the number of bedrooms, bathrooms, etc.) Apart from these preferences, customers specify the price range of houses they are interested in and areas. You can make any additional assumption that you want but you have to clearly state it in your answer. Turn the E-R diagram into tables (relational model schema). Indicate primary and foreign keys. Give the SQL statements to create the corresponding relations in a relational DBMS