A Database Design for the Brazilian Air Force Military Personnel Control System.
Wagner Mussato · 1987
Abstract : This thesis addresses a database design with partial implementation for the Brazilian Air Force Military Personnel Control System. After defining the problem and specifying requirements, the conceptual design was performed using Entity Relationship Model. After defining the Entities and Relationships, the Normalization Theory was used to ensure that all relations met the constraints of the Fourth Normal Form (4NF). During the implementation phase, a prototype was implemented using Oracle DBMS, with SQL as a query language, and Cobol as a host language. The decision to use this environment for the implementation was made because SQL and Cobol are languages used in the Brazilian Air Force. Finally, recommendations were proposed for future research in this area, along with an optimal environment for a database user, combining mainframe and personal computers. Keywords: Theses; Systems requirements; Prototypes.