Wage Slip System

Task

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
  • Connection to the existent SAP system
LabWindows/CVI application

Solution

Database design in MySQL. Programming 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.