Personnel management database design for the Republic of Korea Air Force

Abstract

In this thesis we present a conceptual database for ROKAF's Personnel Management, based upon the relational data model. The objective of this thesis is to apply the computerized personnel information system to the area of military officer personnel management. A database design methodology which utilizes miltiple levels of conceptual and logical database design structure is presented. We discuss the logical schema design in terms of a stepwise, interactive process of specification and refinement. We present operations to manipulate the relational data model for endusers data base processing during the integration process. The logical database is intended for use within a relational database system. This model has been tested using ORACLE, a relational database management (DBMS) running on the VMS operating system of a VAX 11/780 computer.