Database design and implementation for USMC Manpower Retention Survey
By: by Horace W. Smith
Publisher: Naval Postgraduate School; Available from National Technical Information Service
Published: 1999
Place of publication: Monterey, Calif; Springfield, Va
Language: eng
Number of pages: 128
Description: 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.
Notes: "September 1999"

Thesis advisor(s): Daniel R. Dolk, William J. Haga.

Thesis (M.S. in Information Technology Management) Naval Postgraduate School, September 1999.

Includes bibliographical references (p. 125)

Approved for public release; distribution unlimited.

Also Available online.

Mode of access: World Wide Web.

System Requirements: Adobe Acrobat reader.

US Marine Corps (USMC) author.

dk/dk cc:9116 03/01/00