Consider the modeling of a real estate agency. Every real estate agent is assigned a car for their business use. To ensu

[answerhappygod]

Consider the modeling of a real estate agency. Every real estateagent is assigned a car for their business use. To ensureaccountability, the car can be driven by one and only one agent.The car has a vehicle identification number, a manufacturer, amodel, and a license plate number. A real estate agent can servemany clients, but clients can only be served by one agent. Clientsmay be interested in many different properties. Properties have aproperty type, address, city, state, and zip code. The propertiesthat the agency represents can be shown to many clients. An agenthas a first name, last name, date hired, and an office phonenumber. Every client has a first and last name, an email, and aphone number. An agent at a real estate firm may show a client manyproperties, and each property may be shown to many clients. Supposethat the agent’s commission percentage (if the property shown isactually sold to the client) is a variable, and changes dependingupon which client is seeing which property. For example, if clientSam sees and buys property 01, then agent Mary gets a 6%commission, but if client Sam sees and buys property 02, then shegets a 10% commission. Note that these commission percentages areset based on the client and the property.
Draw an appropriate ERD model in order to properly keep track ofthe commissions. Include appropriate identifiers and attributes foreach entity. Suppose that that there are different types ofproperties. For example, a house is a type of property and for ahouse the agency keeps track of the number of bedrooms as well asother attributes to form the listing. The agency also handlescommercial properties, which have so many units and a total floorspace for the property listing. The agency also provides showingsfor duplexes that have so many parking spaces, and apartmenthouses, that have so many units and the contact name of themanager.