Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DRAW ER Diagram of the following? Give a good complete answer. Otherwise, Don't answer please. Following the constraints below, construct an E/R diagram (including primary

DRAW ER Diagram of the following? Give a good complete answer. Otherwise, Don't answer please.

Following the constraints below, construct an E/R diagram (including primary keys) to model a residential real estate database, which contains home listings for multiple real estate agencies. Each agency employs multiple agents, and each agent is involved in listing properties (acting on behalf of sellers) and buying properties (on behalf of purchasers). Note that since the constraints are stated in plain english, some assumptions may be required in your interpretation of them; state any such assumptions. If you create any attributes beyond the ones listed below, include a brief description of the purpose of each. Remember to include primary keys for each entity in the diagram. *Each agency has a name, oce address, website and phone number. *Each real estate agent must be employed by an agency. Agents have a name, cell number and email address. *Clients (people who are looking to buy or sell) each have a name, primary address, phone number and email address. Clients may be buyers or sellers (or both). Each buyer has an associated maximum budget. *Each client (buyer or seller) has one associated real estate agent. It is not permitted for clients to have two agents simultaneously. *A property has an asking price, annual property tax, address, number of bedrooms and number of bathrooms. Note that addresses will include the appropriate apart- ment or suite number if necessary (so two apartments in the same building will be assumed to have distinct addresses). *Each property is listed by exactly one seller. *A property may be a condominium, in which case it will also have an associated monthly strata fee. Not all properties are condominiums. *A sale is a transaction between buyer and seller for a particular property. Each sale has a date and sale price.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions