Design of a distributed database system, based on MySQL, for
creating, acquiring, editing and evaluating wage slips. The goal is to completely
replace the old manual wage slip management and to significantly increase the
handling efficiency.
Requirements
Using MySQL as database system
Connecting to the database via ODBC
User management (3 levels)
Possible database access via Microsoft Access
Stand-alone frontend (no web interface)
Running under Windows NT, Windows 2000, Windows XP
Intuitive and easy-to-use graphical user interface
Automatic error detection and correction
Integrated search algorithms for quickly finding certain datasets
For high data throughput optimized user interface
Connecting to the existent SAP system
Solution
Database design in MySQL. Building the frontend with
LabWindows/CVI (National Instruments). Database access via ODBC.
File-based data export to the SAP system. Flexible user management, intuitive
user interface layout.
