Table Of Content

Unclassified SECURITYCLASSIFICATIONOFTHISPAGE REPORT DOCUMENTATION PAGE 1a.REPORTSECURITYCLASSIFICATION 1b.RESTRICTIVE MARKINGS Unclassified 2a.SECURITYCLASSIFICATIONAUTHORITY 3.DISTRIBUTION/AVAILABILITYOFREPORT Approvedfor publicrelease;distributionisunlimited. 2b.DECLASSIFICATION/DOWNGRADINGSCHEDULE 4.PERFORMINGORGANIZATIONREPORTNUMBER(S) 5.MONITORINGORGANIZATIONREPORTNUMBER(S) 6a.NAMEOFPERFORMINGORGANIZATION 6b.OFFICESYMBOL 7a.NAMEOFMONITORINGORGANIZATION NavalPostgraduateSchool (Ifapplicable) NavalPostgraduateSchool 37 6c ADDRESS(Crty,State,andZIPCode) 7b.ADDRESS{City,State,andZIPCode) Monterey,CA 93943-5000 Monterey,CA 93943-5000 8a.NAMEOFFUNDING/SPONSORING 8b.OFFICESYMBOL 9.PROCUREMENTINSTRUMENTIDENTIFICATIONNUMBER ORGANIZATION (Ifapplicable) 8c.ADDRESS(Crty.State,andZIPCode) 10.SOURCEOFFUNDINGNUMBERS ProgramElementNo ProjectNo. TaskNo WorkUnitAccession Number 11 TITLE(IncludeSecurityClassification) DEVELOPMENTOPAFACULTYRESEARCHANDPUBUCATIONDATABASESYSTEM 12.PERSONALAUTHOR(S) TANSEY,BRIAN,E. 13a.TYPEOFREPORT 13b.TIMECOVERED 14.DATEOFREPORT(year,month,day) 15.PAGECOUNT Master'sThesis From To JULY1992 110 16.SUPPLEMENTARYNOTATION TheviewsexpressedinthisthesisarethoseoftheauthoranddonotreflecttheofficialpolicyorpositionoftheDepartmentofDefenseortheU.S. Government. 17.COSATICODES 18.SUBJECTTERMS(continueonreverseifnecessaryandidentifybyblocknumber) FIELD GROUP SUBGROUP DEVELOPMENTOPAFACULTYPUBUCATIONDATABASEUSINGDBASEIV 19.ABSTRACT(continueonreverseifnecessaryandidentifybyblocknumber) TheAdministrativeSciences(AS)DepartmentoftheNavalPostgraduateSchoolMaintainsasubstantialamountoffacultyresearchand publicationdatathatisusedtosupportitsvastandvariedinformationalneeds. Thedataconsistsofalldepartmentalpublicationsthathave beenwrittenbyAdministrativeSciencefacultymembers. Thisdatabaserequiresconstantmaintenancetoensureaccurate,up-to-date publicationinformationthatcanberapidlyaccessedanytime. Thisthesiswilldefine,designandimplementadatabaseapplicationthatthe AdministrativeSciencesDepartmentcanusetosystematicallymanagetheirfacultypublicationdatabaseforautomaticretrievalandreporting. Thenewprototypesoftwareisnamed"FacultyResearchandPublicationDatabaseSystem(FPDS)",version1.0. Thisthesisprovidesanindepth outlinecoveringsoftwareanalysis,designandimplementation. ThesystemwaswrittenusingDbaseIV,version 1.1. 20.DISTRie'JTION/AVAILABILITYOFABSTRACT 21 ABSTRACTSECURITYCLASSIFICATION fl UNCLASSIFIED/UNLIMITED |*^ SAMEASREPORT ] OTICUSERS Unclassified 22a.NAMEOFRESPONSIBLEINDIVIDUAL 22b.TELEPHONE(IncludeAreacode) 22c.OFFICESYMBOL ProfessorShuLiao 408-646-2545 AS/LC DD FORM 1473.84MAR 83APReditionmaybeiiseduntilexhausted SECURITYCLASSIFICATIONOFTHISPAGE Allothereditionsareobsolete Unclassified TPRP7HA Approved for public release; distribution is unlimited. Development of a Faculty Research and Publication Database System by Brian E. Tansey Lieutenant, United States Navy B.S., Oregon State University, 1984 Submitted in partial fulfillment of the requirements for the degree of MASTER OF SCIENCE IN INFORMATION SYSTEMS from the NAVAL POSTGRADUATE SCHOOL July 1992 C.e SePil ABSTRACT The Administrative Sciences (AS) Department of the Naval Postgraduate School (NPS) maintains a substantial amount offaculty research andpublication data that is used to support its vast and varied informational needs. The data consists of all departmental publications that have been written by Administrative Science faculty members. This database requires constant maintenance to ensure accurate, up-to-date publication information that can be rapidly accessed at anytime. This thesis will define, design and implement a database application that the Administrative Sciences Department can use to systematically manage their faculty publication database for automatic retrieval and reporting. This new prototype software is named "Faculty Research and Publication Database System (FPDS)", version 1.0. Thisthesis provides an in depth outline covering software requirements analysis, design and implementation. The system was written using Dbase IV, version 1.1. ui 1 1. TABLE OF CONTENTS .................... I. INTRODUCTION 1 A. BACKGROUND 1 B. FACULTY RESEARCH AND PUBLICATION DATABASE SYSTEM OBJECTIVES 2 C. RESEARCH QUESTIONS 3 D. SCOPE AND LIMITATIONS OF THESIS 3 .....". E. METHODOLOGY . 3 ...... F. STRUCTURE OF THESIS 4 . II. DEFINITION/REQUIREMENTS PHASE 7 A. DEFINITION PHASE 7 1. Methodology 7 . 2. Scope of Application 7 .............. B. REQUIREMENTS PHASE 8 1. Methodology 8 2. Application Requirements 9 3. Data Requirements 10 4. Update, Display and Control Mechanisms 12 . . a. Faculty Member Publication Record Update Mechanisms 13 b. Faculty Member Publication Record Display Mechanisms 14 IV c. Faculty Member Publication Record Control Mechanisms 15 5. User Review 15 III. EVALUATION/DESIGN PHASE 17 . A. EVALUATION PHASE 17 ...... 1. Methodology 17 . 2. Approach 18 -. B. DESIGN PHASE 19 1. Logical Database Design 19 a. First Normal Form 21 b. Second Normal Form 21 c. Third Normal Form 21 2. FPDS Application Design 22 a. Menu Design 22 b. Screen Design 22 c. Materialization 23 . d. Logic 24 IV. IMPLEMENTATION PHASE 25 A. SYSTEM PROGRAMMING 25 1. SEEKMEM Program 26 2. SEEKLAST Program 26 3. SEEKAREA Program 26 4. SEEKTYPE Program 27 5. SEEKYEAR Program 27 v ............. 6. SKYRAREA Program 28 7. SKYRTYPE Program 28 8. SKYRMEM Program 28 ............. 9. SKYRMNTH Program 28 ..... B. PROGRAMMING LIMITATIONS OF DBASE IV 29 . C. TESTING 29 D. INSTALLATION 30 V. CONCLUSIONS 31 ...... A. REMARKS 31 APPENDIX A OBJECT DIAGRAMS 33 APPENDIX B 34 A. OBJECT DEFINITIONS 34 B. DOMAIN DEFINITIONS 35 ..... ...... APPENDIX C 37 ........ A. FPDS CONTEXT DATA FLOW DIAGRAM 37 B. FPDS SYSTEM DIAGRAM 38 APPENDIX D 39 A. SAMPLE FACULTY MEMBER/PUBLICATION DATA ENTRY FORM 39 B. SAMPLE FACULTY MEMBER PUBLICATION INPUT FORM 40 . C. SAMPLE PUBLICATION REPORT FORMAT 41 . vi