onsider the modeling of a real estate agency. Every real estate agent is assigned a car for their business use. To ensure accountability, the car can be driven by one and only one agent. The car has a vehicle identification number, a manufacturer, a model, and a license plate number. A real estate agent can serve many clients, but clients can only be served by one agent. Clients may be interested in many different properties. Properties have a property type, address, city, state, and zip code. The properties that the agency represents can be shown to many clients. An agent has a first name, last name, date hired, and on office phone number. Every client has a first and last name, an email, and a phone number. An agent at a real estate firm may show a client many properties, and each property may be shown to many clients. Suppose that the agent’s commission percentage (if the property shown is actually sold to the client) is a variable, and changes depending upon which client is seeing which property. For example, if client Sam sees and buys property 01, then agent Mary gets a 6% commission, but if client Sam sees and buys property 02, then she gets a 10% commission. Note that these commission percentages are set based on the client and the property. Draw an appropriate ERD model in order to properly keep track of the commissions. Include appropriate identifiers and attributes for each entity. Suppose that that there are different types of properties. For example, a house is a type of property and for a house the agency keeps track of the number of bedrooms as well as other attributes to form the listing. The agency also handles commercial properties, which have so many units and a total floor space for the property listing. The agency also provides showings for duplexes that have so many parking spaces, and apartment houses, that have so many units and the contact name of the manager. • (30 points) Develop an ERD model for this situation. • (30 points) Design a relational schema for this situation. Also, write the appropriate DDL statements to implement your relational schema.