Design and coding of a database solution for controlling for a publishing house, based on previously used Excel spreadsheets and formulas. Compared to Excel the transformation to a an SQL-Server database performs better particularly in higher data consistency and protection against erroneous user input of data.
- flexible object-oriented data model, extensibility via custom front-end administration interface
- development of a formula machine within the SQL-database to calculate special client-supported formulas
- comprehensive data consistency safeguarding, multilevel privilege system
- archiving functions in accounting periods
- extensive statistics and reporting functionality for next level management
- import modules interfacing to accounting and financial departments
- testing mode database extension for case studies
- client/server solution based on MS-Access/SQL-Server
