NAVAL POSTGRADUATE SCHOOL Monterey, California THESIS CONCEPTUAL DATA MODEL FORADMINISTRATIVE FUNCTIONS OF A TYPICAL NAVAL SHIP, TO INCLUDE: DRUG AND ALCOHOL PROGRAM ADVISOR, WATCH QUARTERAND STATION BILL, SAFETY, MEDICAL, AND SECURITY by Daniel J. Montgomery September, 1991 Thesis Advisor: Magdi N. Kamel Approved for public release; distribution is unlimited 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 (//applicable) NavalPostgraduateSchool 55 6c ADDRESS(City,State,andZIPCode) 7b ADDRESS(City,State,andZIPCode) Monterey,CA 93943 5000 Monterey,CA 93943-5000 8a.NAMEOFFUNDING/SPONSORING 8b OFFICESYMBOL 9 PROCUREMENTINSTRUMENTIDENTIFICATIONNUMBER ORGANIZATION (//applicable) 8c ADDRESS(City,State,andZIPCode) 10 SOURCEOFFUNDINGNUMBERS ProgramElementNo ProjectNo WorkunitAccession Number 11.TITLE(IncludeSecurityClassification) CONCEPTUALDATAMODELFORADMINISTRATIVEFUNCTIONSOFATYPICALNAVALSHIP,TO NCLUDE:DRUGAND I ALCOHOLPROGRAMADVISOR,WATCH,QUARTERANDSTATIONBILL,SAFETY,MEDICALANDSECURITY 12 PERSONALAUTHOR(S) MONTGOMERY,DANIELJ. 13a TYPEOFREPORT 13b TIMECOVERED 14 DATEOF REPORT(year,month,day) 15 PAGECOUNT Master'sThesis From To SEPTEMBER1991 236 16.SUPPLEMENTARYNOTATION TheviewsexpressedinthisthesisarethoseoftheauthoranddonotreflecttheofficialpolicyorpositionoftheDepartmentofDefenseortheU.S. Government. 17.COSATICODES 18 SUBJECTTERMS(continueonreverseifnecessaryandidentifybyblocknumber) FIELD GROUP SUBGROUP DATA MODELING,ENTITYRELATIONSHIPDIAGRAMS,ENTITYCLUSTERING, DATABASEDESIGN,VIEWINTEGRATION 19 ABSTRACT(continueonreverseifnecessaryandidentifybyblocknumber) DatamanagementstandardizationhasbeenidentifiedbytheOfficeoftheSecretaryofDefenseasamethodtoachievesavings inthe$9billion spentannuallyoninformationtechnologyinDoDandtopromoteinteroperabilityandinformationexchangeamongsystems.Mosteffortshave beendirectedatstandardizingdataelements,thelowestlevelinthehierarchyofdata,asafoundationforstandardizingManagement InformationSystemswithinDoD.Inthisthesis,weproposeextendingthestandardizationefforttotheschemalevelofanorganizationalunit.We examinetheadministrativefunctionscarriedoutonboardagenericNavyshipanddevelopadatamodel(view)foreachfunction.The administartivefunctionsaddressedinthisthesisareDrugandAlcoholProgramAdvisor,Watch,QuarterandStationBill,Safety,Medicaland Security.Theseparateviewsareintegratedtoformaglobal,highlevelconceptualdatamodel.Thiscomplexviewisthensimplifiedbycreating higherlevelsofabstractionusinganentityclusteringtechnique. 20.DISTRIBUTION/AVAILABILITYOFABSTRACT 21 ABSTRACTSECURITYCLASSIFICATION ^UNCLASSIFIED/UNLIMITED ] SAMEASREPORT ] DTICUSERS UNCLASSIFIED 22a NAMEOFRESPONSIBLE INDIVIDUAL 22b TELEPHONE(IncludeAreacode) 22c OFFICESYMBOL MagdiN. Kamel (4081646-2494 AS/KA DD FORM 1473,84 MAR 83APReditionmaybeuseduntilexhausted SECURITYCLASSIFICATIONOFTHISPAGE Allothereditionsareobsolete UNCLASSIFIED Approved for public release; distribution is unlimited. Conceptual Data Model for Administrative Functions ofa Typical Naval Ship, to include: Drug and Alcohol Program Advisor, Watch Quarter and Station Bill, Safety, Medical, and Security by Daniel J. Montgomery Lieutenant Commaiider, United States Navy B.A., Ottawa University Submitted in partial fulfillment ofthe requirements for the degree of MASTER OF SCIENCE IN INFORMATION SYSTEMS from the