Database System Design and Implementation for Marine Air-Traffic-Controller Training

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 systems 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 Navys Visual Information Display System.