Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started