Have a look at some of the database projects we have under our belt in the listing below. We've built thin-client web-based databases, as well as thick-client distributed desktop databases, plus database-oriented web applications. Our next project could be yours!
For every database we build, we listen carefully to our clients. We've been known to go into the field with our clients (weather permitting) to see first-hand where the data they'd like to manage really comes from. A feel for the territory is, we think, very important.
We have plenty of hands-on experience building databases, but we don't forget our theory. Our databases are always properly normalized (third normal form), in order to avoid data duplication and redundancy. Speed, after all, is paramount, and data integrity is king.
COMMUNITY LANDS FUND
Distributed database for management of project funding for community land ownership, with Google Maps integration that allows iTC to record exact land delimitations, KML import, rule-based search and group-based user management. The database is in use in 8 iTC offices in various provinces of Mozambique.
MINISTRY OF INTERIOR
Web-based database used by the Ministry to record vehicle ownership information. The database is used by the department of motor vehicles and police units. The web interface allows powerful searches, extensive reporting and data export. Access is secured.
Distributed desktop database used in conjunction with a portable survey system (based on Palm handheld computers) that allows the Malaria Consortium to record information on malaria incidence in Mozambique. Hand-held devices are taken into Mozambique's provinces to interview the local populace, and the data is then integrated into the central database at the main office.
BANKING & FUNDING
Web-based public database containing extensive information on funding available in Mozambique, through banks and other institutions. The visitors can execute various queries, and there is integration with Google Maps to show the locations of institutions and the geographical coverage of their funding. The entire database content is managed on-line through a secure back-office.
Distributed desktop-based database for agricultural funding projects. MASC uses this database to store detailed project information, and projects go through a set approval workflow, where various users must provide input for a project to be accepted (or rejected). This database produces Microsoft Excel and Microsoft Word output through templates that are user-modifiable. Rule-based search allows quick, powerful search queries.
Desktop database used by the gymnasium to record member information, member access (using a fingerprint scanner), financial information and technical (training) information. The system produces various detailed reports used by the gymnasium for its financial management. The database is also connected to a personalized website ("MyPhysical") where members can login and see financial and training details. The same system is now in use at mCel and Clube Naval.