Salvador Pérez - Real Estate Agency Database System
Real Estate Agency Database System
Customer Salvador Pérez (Denia, Spain)
Objectives
Development Status
  • Developed and delivered.

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.


Tags: Clientes


Return to the index