Assignment 2 Assume you are in charge of gathering information for a real estate agency which helps customers find houses and apartments they want to buy. You have interviewed the manager and collected a sample for presenting the data. Interview You: Can you tell me why you believe you need a database? Participant: think we need a database just to keep track of all the listed properties. I'd also like to keep track of all the sales done through our agency. You: I'm sure the database will address these issues. Now, what would you say is the single most important function of your business? Participant: To connect sellers and buyers through our sales associates. To allow sellers to list the properties they want to sell, and help our customers find the kind of home they want. You: What kind of homes does your agency help buyers find? Participant: single-family homes, town homes, and condos You: How does your agency help the customer find the home they are looking for? Participant: They can specify the criteria they are searching for: price range, number of bedrooms, location, number of bathrooms, year it was built, type of property, and the size of the property. Then, the customer sees a listing that matches the criteria. If the customer finds something they like, they click on it, and the property details will show up as well as the sales associate that they can contact. Back on the market with tons of improvements.. New Roof, New Carpet, New Tile, New Appliances, New Paint, New Trim, Large landscaped lot with privacy fence, wide open floor plan with bonus room upstairs. Address: 106 Main St, 64123 WA Price: $250,000 Type: Single Family House Bedrooms: 4 Bathrooms: 2 Size: 1,800 square feet. Year Built: 1998 Backyard: Yes Garage: 2-car garage. Sales Associate Adam Smith E-mail: smitha@abc.co Tel: 816-888-4422 Figure 1: Sample showing the details of a property Assignment 2 Assume you are in charge of gathering information for a real estate agency which helps customers find houses and apartments they want to buy. You have interviewed the manager and collected a sample for presenting the data. Interview You: Can you tell me why you believe you need a database? Participant: think we need a database just to keep track of all the listed properties. I'd also like to keep track of all the sales done through our agency. You: I'm sure the database will address these issues. Now, what would you say is the single most important function of your business? Participant: To connect sellers and buyers through our sales associates. To allow sellers to list the properties they want to sell, and help our customers find the kind of home they want. You: What kind of homes does your agency help buyers find? Participant: single-family homes, town homes, and condos You: How does your agency help the customer find the home they are looking for? Participant: They can specify the criteria they are searching for: price range, number of bedrooms, location, number of bathrooms, year it was built, type of property, and the size of the property. Then, the customer sees a listing that matches the criteria. If the customer finds something they like, they click on it, and the property details will show up as well as the sales associate that they can contact. Back on the market with tons of improvements.. New Roof, New Carpet, New Tile, New Appliances, New Paint, New Trim, Large landscaped lot with privacy fence, wide open floor plan with bonus room upstairs. Address: 106 Main St, 64123 WA Price: $250,000 Type: Single Family House Bedrooms: 4 Bathrooms: 2 Size: 1,800 square feet. Year Built: 1998 Backyard: Yes Garage: 2-car garage. Sales Associate Adam Smith E-mail: smitha@abc.co Tel: 816-888-4422 Figure 1: Sample showing the details of a property
