Design and implementation of a NATOPS qualification database management system for Naval Aviation Safety Officers

摘要

The VFA-125 Safety Office located at NAS Lemoore is burdened with the enormous administrative responsibility of managing the NATOPS qualifications for over 200 pilots and passengers. During this period of military downsizing and operational funding cuts, this responsibility will require the increased attention of a smaller staff with a limited budget. The burden of paper file management could be eased through the introduction of automated record keeping while simultaneously increasing accuracy and efficiency. The potential for non-qualified personnel to fly squadron aircraft could be eliminated. Based on VFA-125 Safety Office requirements, this thesis designs and implements a database management system. The primary objective is to automate the currently utilized manual NATOPS filing system to allow the squadron Safety Officer immediate access to all NATOPS-related pilot qualification data. This system will store, sort and compare data relevant to all squadron pilots while minimizing the time spent verifying the previously-used manual filing system. Additionally, the staff will be able to query reports and generate memoranda with minimal effort. The system is also analyzed to determine possible enhancements in the future. The Aviation Safety Database System is designed using dBASE III Plus and dBASE for Windows 5.0.