Design and implementation of a database management system for a Navy Medical Administrative Unit

Abstract

The Navy Medical Administrative Unit (NMAU) for the Monterey Peninsula has a challenging mission which encompasses many administrative tasks. Medical readiness and occupational health requirements are tracked for all Navy and Marine Corps personnel in the region. In order to fulfill their mission satisfactorily, it was necessary for NMAU to get an automated database management system. The Flight Surgeon at the Naval Postgraduate School works very closely with NMAU. The Flight Surgeon's administrative responsibilities would also benefit from a database system. Based on the requirements for NMAU a database system was designed and implemented in their clinic. Based on the Flight Surgeon's requirements the data base system was further analyzed in order to assist future upgrades that would employ the flight surgeon's requirements. The primary objective, however, was to get a system on line for NMAU that would enable them to effectively and efficiently execute their mission. The Navy Medical Administrative Unit Database System (NMAUDS 1.0) was the result of the previously described endeavors; it was written in dBASE IV version 1.5.