编号:毕业设计(论文)外文翻译(原文)学院:专业:学生姓名:学号:指导教师单位:姓名:职称:2013年5月30日AbstractThisreportincludesadevelopmentpresentationofaninformationsystemformanagingthestaffdatawithinasmallcompanyororganization.ThesystemassuchasithasbeendevelopediscalledEmployeeManagementSystem.ItconsistsoffunctionallyrelatedGUI(applicationprogram)anddatabase.Thechoiceoftheprogrammingtoolsisindividualandparticular.KeywordsInformationsystem,Databasesystem,DBMS,parenttable,childtable,tablefields,primarykey,foreignkey,relationship,sqlqueries,objects,classes,controls.Contents1.Introduction......................................................................................................................................11.1Background............................................................................................................................................11.2ProblemStatement...............................................................................................................................21.3ProblemDiscussion.............................................................................................................................21.4ReportOverview..................................................................................................................................22.Problem’sSolution........................................................................................................................22.1Method....................................................................................................................................................22.2ProgrammingEnvironments..............................................................................................................32.3DatabaseAnalyzing,designandimplementation..........................................................................72.4Program’sStructureAnalyzingandGUIConstructing................................................................92.5DatabaseConnectionsandCode-Implementation.......................................................................122.5.1Retrievingdatafromthedatabase...............................................................................................162.5.2Savingdataintothedatabase.......................................................................................................192.5.3Updatingrecordsintothedatabase.............................................................................................222.5.4Deletingdatafromthedatabase...................................................................................................243.Conclusion........................................................................................................................................254.References.........................................................................................................................................26第1页共26页1.IntroductionThischaptergivesabrieftheoreticalpreviewuponthedatabaseinformationsystemsandgoesthroughtheessenceoftheproblemthatshouldberesolved.1.1BackgroundMostofthecontemporaryInformationsystemsarebasedontheDatabasetechnologyasacollectionoflogicallyrelateddata,andDBMSasasoftwaresystemallowingtheuserstodefine,create,maintainandcontrolaccesstothedatabase.Theprocessofconstructingsuchkindofsystemsisnotsosimple.Itinvolvesamutualdevelopmentofapplicationprogramanddatabase.Theapplicationprogramisactuallythebridgebetweentheusersandthedatabase,wherethedataisstored.Thus,thewell-developedapplicationprogramanddatabaseareveryimportantforthereliability,flexibilityandfunctionalityofthesystem.Thesodefinedsystemsdifferentiatetoeachotherandtheirdevelopmentcomprisesagreatvarietyoftaskstoberesolvedandimplemented.ThebasicideacanbedepictedonFigure1.1below:Informationsystemsuggestsacomputertechnologytobeusedinordertoprovideinformationtousersinanorganization(forinstance),asforthepurposesofdatatransformationintousefulinformation;computerhardwareandsoftwarearedesignedandused[2].AparticularcaseistheHumanResourcesInformationSystemdevelopment.Thiskindofsystemsareresponsibleforstoringdataofthestaffwithinanorganizationandgeneratingreportsuponrequest.SuchkindofsystemcouldbeintegratedwithotherInformationsystemsormodules:第2页共26页AccountingInformationSystem(AIS)–designedtotransformfinancialdataintoinformation,orManagementInformationSystem(MIS)thatprovidesdecision-orientedinformationtomanagers,andsoon…“OrganizationsdependonInformationSystemsinordertostaycompetitive.Productivity,whichiscrucialtostayingcompetitive,canbeincreasedthroughbetterInformationSystems.”[2].1.2ProblemStatementThisreport’sdocumentationgoesthroughthewholeprocessofbothapplicationprogramanddatabasedevelopment.Italsocomprisesthedevelopmenttoolshavebeenutilizedforthesepurposes.1.3ProblemDiscussionThissystemshouldconsistofanapplicationprogram,ononehand,andadatabase(repositoryofdata)ontheother.Theprogramshouldperformthebasicoperationsuponthedatabaseasretrieving,inserting,updatinganddeletingdata.Anyadditionalfunctionalityisagoalofafurthe