Construct a Data Model for the following situation. Do not show attributes or identifiers. Do show entity types (including supertypes and subtypes, if appropriate), relationships and relationship labels, and cardinalities (maximum and minimum) and optionalities (mandatory/optional). State any assumptions you make. Upload an image of your answer to this question. Green Acres Real Estate Inc. wants a database system to track listings of properties that have been or are currently being sold by Green Acres real estate agents. Each property has a unique identifier (property ID), a description, and an address. A property may or may not have a house on it. If there is a house, then information such as the number of bathrooms and bedrooms is stored. A property is owned by exactly one seller. The seller has a name, phone number, and address (which may be different from the property address). A seller may own more than one property. When a seller asks Green Acres to sell a property, a listing is created. A listing is for exactly one property, although a property can be listed many times. (For example, the seller may list the property at one price for several months, and then decide to take the property off the market because of poor demand, and then re-list it a year later when demand is better.) Green Acres tracks information about each listing, such as the listing (or asking) price, the listing date, and the terms of sale. Buyers make offers for listed properties. An offer consists of the amount and terms a buyer is willing to pay for a listed property. A prospective buyer may not make an offer on any listing, or he/she can make many offers (on the same or different listings). Every offer is made by exactly one buyer and is for exactly one listing. Green Acres tracks the amount and date of each offer. A listing may receive many offers or no offers. Information about prospective buyers is kept, such as the buyer's social security number, name, and phone number. Construct a Data Model for the following situation. Do not show attributes or identifiers. Do show entity types (including supertypes and subtypes, if appropriate), relationships and relationship labels, and cardinalities (maximum and minimum) and optionalities (mandatory/optional). State any assumptions you make. Upload an image of your answer to this question. Green Acres Real Estate Inc. wants a database system to track listings of properties that have been or are currently being sold by Green Acres real estate agents. Each property has a unique identifier (property ID), a description, and an address. A property may or may not have a house on it. If there is a house, then information such as the number of bathrooms and bedrooms is stored. A property is owned by exactly one seller. The seller has a name, phone number, and address (which may be different from the property address). A seller may own more than one property. When a seller asks Green Acres to sell a property, a listing is created. A listing is for exactly one property, although a property can be listed many times. (For example, the seller may list the property at one price for several months, and then decide to take the property off the market because of poor demand, and then re-list it a year later when demand is better.) Green Acres tracks information about each listing, such as the listing (or asking) price, the listing date, and the terms of sale. Buyers make offers for listed properties. An offer consists of the amount and terms a buyer is willing to pay for a listed property. A prospective buyer may not make an offer on any listing, or he/she can make many offers (on the same or different listings). Every offer is made by exactly one buyer and is for exactly one listing. Green Acres tracks the amount and date of each offer. A listing may receive many offers or no offers. Information about prospective buyers is kept, such as the buyer's social security number, name, and phone number
