Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume that you want to develop a software system for AREI. The information you have about the system is described by the scenario below: 1.

Assume that you want to develop a software system for AREI. The information you have about the system is described by the scenario below:

1. Create an EDR for this scenario?

A Real Estate, Inc. (AREI), sells houses. People who want to sell their houses sign a contract with AREI and provide information on their house and their contact information. The house information includes the location, size, how many bedrooms, how many bathrooms, desired price, a short description of their house. The seller information includes the name, phone, email, and mailing address. Such information is kept in a database by AREI, and a subset of the information (house information) is sent to the citywide multiple listing service used by all real estate agents.

AREI works with two types of potential buyers. When working with a new potential buyer, the buyer completes a buyer information form including his/her name, phone, email, mailing address. Some buyers have an interest in one specific house. In this case, AREI prints information from its database, which the real estate agent uses to help show the house to the buyer (a process beyond the scope of the system to be modeled). Other buyers seek AREIs advice in finding a house that meets their needs. In this case, the buyer provides a short description of the desired houses including the location, size, how many bedrooms, how many bathrooms, and desired price. The AREI real estate agents use such information to search AREIs database and the multiple listing service for houses that meet their needs. The results of these searches are printed and used to help the real estate agent show houses to the buyer.

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

Learn To Program Databases With Visual Basic 6

Authors: John Smiley

1st Edition

1902745035, 978-1902745039

More Books

Students also viewed these Databases questions

Question

2. Compare the sales and service departments at Auto World.

Answered: 1 week ago