Initially, a seller contacts Green Acres to discuss house selling details which culminates in establishing an account and signing a sales contract. The seller provides Green Acres with listing information which contains house and property specifications, and it is used for setting the selling price for the house.
When a buyer contacts Green Acres, a salesperson creates a buyer's requirements record and then scans the database to select a few listing that match the requirements of the buyer. The salesperson maintains in the database buyer's data on site showing and any offers/counter offers that the buyer makes on a specific property.
When the buyer and seller agree on an offer, a closing date is scheduled. Not all offers lead to a closing. After the closing the seller, buyer and listing information are removed from the database and compiled in a separate file.
Systems Analysis reveals
Entities are:
| Seller | Buyer | Listing | House | Offer |
| Property | Showing | Closing | Room |
Attributes are:
| Seller Name | Square foot size | Seller Address |
| House Style | Closing Location | Listing Price |
| Number of bathrooms | Garage size | Showing date |
| Garage location | Buyer Name | Basement size |
| House heating method | Offer amount | Listing date |
| Property description | Offer date | Room type |
| Property size | Showing time | Room size |
| Elementary school zone | Buyer phone number | Closing date |
| Sales terms |
The information system will support the following operational needs of Green Acres sales staff and management.
1. Green Acres is in the business of assisting property owners to find buyers and help the two parties to close the transaction.
2. When potential property sellers decide to put their property on sale with Green Acres, the sales person uses the information system to record information about the property in its listing database.
3. The sales person also uses the listing database to select a set of listings of property that were sold within the last six to twelve months and are comparable to the seller's property. This helps the sales person and the seller to settle on a sale price for the property
4. When a potential buyer visits Green Acres, the sales person uses the information system to record the buyer's specifications of the desired property.
5. Using the buyer's specification, the sales person selects and prints the listings of a set of properties on sale from the listing database.
6. The sales person schedules a showing of these selected properties, and maintains a record of each showing in the Green Acres information system's database.
7. The sales person uses the information system to create an offer form, which is used for recording all the negotiations between the seller and the buyer.
8. When an offer is finalized, a closing date is specified on the offer sheet.
9. Management uses the system to extract weekly reports that show