Problem-Tracking Database

Every system is doomed to experience the unexpected. However, analysis of a problem will allow you to make changes that will minimize future unexpected difficulties. It is also helpful to have a record of how you solved a problem, just in case it does happen again. There is an even bigger benefit when you work with a team of individuals who can record problems/solutions they experience. The problem/solution information can be more easily disseminated amongst the team members.

In this section, we take you through the process of setting up a basic problem-tracking database. Also, we help you create a few advanced scripts to record, update, and review the problems and their solutions.

Creating the Database

Planning the database structure will be the most important part of creating the problem-tracking database. You need to determine what kind of information you would like to track and who will have access to modify and use the data stored within the database.