Database design and implementation for USMC Manpower Retention Survey
Smith, Horace Wayde
Haga, William J.
Dolk, Daniel R.
MetadataShow full item record
MCERC is a database design and implementation to support the survey instruments for the USMC Exit and Retention Censuses, which are administered over the Internet. The Retention Census is a longitudinal survey administered annually to all Marines. A review of commercially available survey software revealed a lack of support for longitudinal surveys. A semantic object model for survey instruments is developed that relates them to the response data they collect. The resultant database schema facilitates version management of survey instruments over their life cycle. The design supports the longitudinal aspect of the USMC Censuses by allowing the tracking of the instruments and response data over time. A relational model of the database design is prepared and implemented in Access (TM). A user interface is designed using Visual Basic, which integrates Cognos powerplay (TM) into the system for analysis of the data. The interface includes the capability to convert raw data into a matrix for analysis. Issues of database administration are discussed as they relate to scaling the system from a stand alone to a multiple user environment
Approved for public release; distribution is unlimited.
Showing items related by title, author, creator and subject.
Demurjian, Steven A.; Hsiao, David K. (Monterey, California. Naval Postgraduate School, 1986-02); NPS52-86-011In the past, the design and implementation of a database system has followed a rather conventional approach. First, a specific data model for the database system is chosen. Second, a corresponding model-based data language ...
Web-based information management system for the investigation, reporting, and analysis of human error in Naval Aviation maintenance Boex, Anthony R. (Monterey, California. Naval Postgraduate School, 2001-09);The purpose of this thesis is to examine the development of a Web application to display, analyze, and produce reports of human error involvement and patterns in aviation maintenance mishaps. The Human Factors Analysis and ...
Bourgeois, Paul Alan (Monterey, California: Naval Postgraduate School, 1993-03);The traditional approach to database-management-system (DBMS) designs focuses upon the implementation of a single data model and its corresponding data language in order to support applications for a given database task. ...