Design and Implementation of an Operational Database for the Fleet Area Control and Surveillance Facility, NAS North Island, San Diego, California

The Fleet Area Control and Surveillance Facility FACSFAC located at North Island, San Diego, Currently performs its data collection, storage and processing functions manually. Expected expansion of the scope of operations at FACSFAC will overwhelm the present system. This thesis develops an Oracle-based relational database system for use by FACSFAC. The system consists of two applications. In the scheduling application, inputs from various sources are compiled, allowing both a powerful query capability and the production of a weekly schedule of activities for the facilities and personnel assigned to FACSFAC. The exercise results application provides an automated method of gathering and querying pertinent tactical employment and range utilization data for required weekly, monthly and quarterly reports. Operational database, Relational database, Prototype, Oracle, Database management system.