Salvador Pérez - Real Estate Agency Database System
| Real Estate Agency Database System |
| Customer |
Salvador Pérez (Denia, Spain) |
| Objectives |
|
| Development Status |
|
Project history
1998-1999
Highlighted features
The complete solution is composed of three different modules:
- Master database:
- For internal usage of the Real Estate Agency.
- Main functionalities:
- Choose language: Spanish, English and German.
- Add / edit properties
- Add / edit owners
- Add /pictures
- Search properties (multiple criteria)
- Print properties form (3 different formats: Normal, Confidential and for display)
- Distributable database:
- For periodical delivery to external international agents (in CD-ROM)
- Confidential information (owners, etc.) excluded
- Main functionalities:
- Choose language: Spanish, English and German.
- Search properties (multiple criteria)
- Print properties form
- Web query:
- For its integration in the Agency's Web site.
- Dynamic search on the database using ASP.
- Main functionalities:
- Choose language: Spanish, English and German.
- Search properties (multiple criteria)
- List of results
- Detailed property form (including photographs)
Sample screens
|
 Fig. 1: Main Menu and Toolbar Access to the main modules of the system: Property and house forms, menus, reports, property search form, etc. A special toolbar is active for all the system, permitting to access to the most frequently used functionalities.
|
 Fig 2: Search properties Permits to perform a search of properties based on multiple criteria (location, price, views, etc.). Results are listed below, and can be sorted on any column.
|
|
 Fig. 3: Property form - General description All the information of a property is edited with a unique form divided in four blocks (tab index). Related fields are grouped. Language independent menus of values.
|
 Fig. 4: Property form - Pictures Each property can have many photographs associated. The same photograph can be assigned to several properties. Photographs are stored as independent files.
|
|
 Fig. 5: Property form - Confidential data All internal data of the agency is maintained in a unique page. This is only available in the Master system
|
 Fig. 6: Owner form Detailed information for each owner is maintained using a separate form, independently on how many properties has in the database.
|
|
 Fig 7: Preview property printed form Three different formats of printable forms for the properties: Normal (to give to customers), For display in the Agency window or brochures, for Internal files (with confidential data).
|
 Fig. 8: Configuration panel Permits to select the language, the format of the property print form, the path of the photograph files. It also permits to maintain the auxiliar tables containing the values in field menus and the texts in different languages.
|
Volver al índice
|