Repairs Managing Database
Customer's Requirement:
Database for repairs to record and manage modules and devices.
The customer needs a database to record the deliveries as well as the backtracking of repairs and upgrades.
Project Scope:
Implementation:
- Combining an existing Access application for recording deliveries and an existing Excel list of repairs
- Backtracking of modules and devices
- Integration of the repair management database into the existing orders database
- Statistics module for deliverance and complaints
Development Environments / Software:
- MySQL Community Server
- Visual Studio 2017 C#
- MySQL Visual Studio Plugin
- MySQL Connector 5.2
Tasks:
- Analysis of existing systems
- Development of an over-all concept
- Specification done in cooperation with hte customer (table definitions, GUI, outputs)
- Setup of a MySQL servers for the database
- Redesign of table definitions
- Joining and defining the module and device numbers being used
- Import of existing Access- and Excel-data through separate import program
- Verification and launch together with the customer