Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions