Database system design and implementation for Marine air-traffic-controller training

Abstract

This project focused on the design, development, and implementation of a centralized electronic database for air-traffic-controller (ATC) training within the Marine Corps. The Marine Corps currently has individual electronic training database-management systems at the unit level. The existing training database-management systems are client based, unstandardized, and have significant data-entry redundancy. We developed a centralized system that is scalable and capable of supporting detailed training statistics. We identified several critical features required for successful implementation and developed a system capable of importing and processing existing training data. We analyzed an existing training database-management system used at the unit level and developed methods for accurately exporting the existing system's stored generic data. We processed the raw data and properly migrated the data to a prototype database-management system, which involved processing for proper data integrity, database normalization, and enforcing unique record-identifier usage. We developed a front-end graphical user interface to interact with the developed system and the stored training data. Future system improvements include migration to a military network, adaptation by additional units, and full integration with the Navy's Visual Information Display System. http://archive.org/details/databasesystemde1094555649 Captain, United States Marine Corps Approved for public release; distribution is unlimited.

Original document

The different versions of the original document can be found in:

• http://hdl.handle.net/10945/55649