Draw an entity-relationship diagram to represent the following information

Computer Science
Price: $5 USD

Question description

Draw an entity-relationship diagram to represent the following information.  If you need to make any assumptions you can do so, but clearly list all assumptions that you make. 

Bob Smith owns Smith Realty.  Smith Realty is an independent full service realty company that serves Washington, Greene, Carter, and Unicoi counties in Tennessee.  They list properties for sale in the MLS (Multiple Listing Service) and represent buyers as brokers.  Smith Realty has been in business for 10 years and has previously tracked all of their customers and sales using a purchased real estate business application.  Because it is proprietary software, Smith Realty can’t access its data directly, but must use the application.  The reports available to them are somewhat limited and the company that created the software no longer supports it.

  Currently, Smith Realty has 4 agents, including Bob.  Smith Realty is growing and is always looking for good agents.  There is also a high turn over with agents.  Good agents move from agency to agency looking for the best benefits.  Less productive agents quit frequently.  Agents have to be licensed and have to meet state requirements in order to renew their license.  It’s import for Smith Realty to keep track of agent licensure because if an agent’s license expires, the fines can be substantial.

  Smith Realty has different types of customers.  Some sell property, some buy property, or a customer can be both a buyer and a seller.  Smith Realty prides itself on its customer service and because of this has a high rate of return customers as well as referrals.  Smith Realty is satisfied with the way the current Customer Relationship Management application tracks customer information.  It allows them to correspond with their customers and keep in contact with them.  Because of this, your design will only need customer ID to represent a customer.

  Smith Realty represents customers wishing to sell real estate.  In order to list the property in the MLS, Smith Realty gathers information pertinent to the property such as address, features, sq ft, acreage, taxes, utility bills, listing price, and other information that a buyer would need to know to make an informed decision. 

  Some customers are in the market to buy real estate.  Smith Realty represents these customers as a brokerage firm.  They show buyers properties that meet the customer’s expressed needs.  When the customer sees a property in which they are interested, Smith Realty represents the customer by helping make the offer and any counter offers.  Once an offer is accepted, Smith Realty also represents the customer in the closing processes. 

Tutor Answer

(Top Tutor) Daniel C.
School: UC Berkeley
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors