Design and Implementation of Data Base Management System for the Organization Structure of the Egyptian Armed Forces.
AIR FORCE INST OF TECH WRIGHT-PATTERSON AFB OH SCHOOL OF ENGINEERING
Pagination or Media Count:
The organization structure system is part of the integrated information system of the Egyptian Armed Forces. It manipulates the units organization data department, unit level, type, balance, armament, personnel, plans, percentage of completeness, location and position in the armed force tree. An initial survey for the problem is done. The design of the system is done through the E-R model and the functional dependency is defined. We choose the relational data base model for its advantages like data independent and simple data manipulation, over the other two DBMS models hierarchical and network models. The system is designed in ten relations and the implementation is done through ingress using C programming language with equal embedded ingres in C. This thesis presents several examples of queries that the system can support. An algorithm for collecting the units commanded by a particular unit is presented. The implementation includes the data definition of the ten relations in ingres. The data base editing program is presented which consists of 23 modules. This program is able to perform the addition, modification, deletion, and retrieval of units data keeping the data base in consistent state. The problems of recovery, concurrency, security and data integrity are also discussed.
- Personnel Management and Labor Relations
- Computer Programming and Software
- Computer Systems