外文翻译 - 酒店管理系统模型研究与设计

0外文原文外文一：ResearchandDesignofHotelManagementSystemModelJingdaYangJilinBusinessandTechnologyCollege,Changchun,130062,ChinaKeywords:HotelManagement;SystemModeling;DemandAnalysis;Database;Design.Abstract.Inordertomakethehotelmanagementworksystematic,standardizationandautomation,achievetheaimofimprovingtheefficiencyofhotelguestroommanagement.Thispaperdesignsthehotelmanagementsystem,theoverallmissionofsystemdevelopmentistomaketheofficestaffcanquicklyandeasilycompletethehotelguestroommanagementtask.FromtheAngleofactualapplicationtosystemillustratethebasicsituation;Andthenintroducedthesystemanalysisandmodeling,focusingonthefunctionalrequirementsofthehotelmanagementsystemwasanalyzed,atthesametimeonthesystemdesigngoal,thesystemusecasediagramandsoonseveralaspects,Hotelmanagementsystemismainlyintroducedthethreelayersofframestructure,andthedatabasedesign,etc.Applicationofthissystemcanbeflexiblyandconvenientlyonthecomputermanagementhotelrooms,thusgreatlyimprovestheprocessingspeed,makethemanagementmoremodern.IntroductionHotelindustryisfacingtheincreasinglyfiercecompetitiveenvironment,ontheonehand,thetraditionalhotelindustryisdifficulttogetridoflowprices,lowoccupancyrateandlowprofitthreelowstrangecircle;Studyhotelmanagementintheinformationservice,roominformationquery,bookingandmanagementfunctions,forbusinessprocesseseffectiveintegrationofhotelmanagement,completeinformationsharingintheprocessofmanagement,toprovidecustomerswithconvenientandefficienthotelservice.Throughthissystemcanbeinthehotelcustomers,servicepersonnel,managersandownerstobridgetheinterconnection,thefullapplicationofinformationmanagementtechnology,combined1withtheactualbusiness,improvinghotelservicequality,standardizedservicestandards.TheRequirementsAnalysisofSystemFunctionalHotelmanagementsystemismainlyusedinthehoteldailyinformationset,entryandquery,atthesametimeinbetweencustomers,waiter,administrators,ownerssetupaninteractiveplatformforthevisit1.Intermsofdataquery,forsystemadministrators,whowilltakecareofthehotelguestroominformation,passengeroccupancy,statisticsandanalysisforallkindsofotherinformationtocustomizethequery,tocompletethemanualmonitoringfunctionsofthedatabasedata2.Intermsofdatabasemaintenance,meetthedemandofsystemadministratorstodatabasedailymanagement,mainlytothelocaldatabasesystemformanagementandcustom,includingthemanagementofthedatatable,guestroomdatachange,passengercheck-ininformationinputandratedatacalculation,etc3.TheCustomerInformationManagementNeeds.Customerinformationmanagementisthroughthein-depthanalysisofcustomerinformation,toimprovecustomersatisfaction,soastoenhancetheenterprisethecompetitiveability.Goalistoreducesalescycleandcostofsales,increasetheirincome,seekingtoexpandbusinessfornewmarketsandchannels,andimprovecustomervalue,satisfaction,profitabilityandloyalty.TheHotelInformationManagementNeeds.Thehotelinformationmanagementincludesthefollowingfunctionalrequirements,suchaspersonnelinformationrelatedtomaintenance,countermanagement,buildingmanagementandbusinessinformationmanagementandanalysis,etc4.SystemUseCaseModelUseCaseDiagramiswidelyappliedinallkindsofsystemdevelopmentisthefirststepinthesoftwarerequirementsanalysis.Ittellsyouhowtouseasystem,whichishowtounderstandthesysteminsomefunctionalpurposes.Usecasediagramshowstherelationshipbetweenusersandsystemrequirestheusertoprovidewhatkindofservice,anduserneedtoprovidewhatkindofservicesystem.SystemOverallUse-caseDiagram.2BackgroundmanagementsubsystemandCustomerservicesubsystemisdisplaysystemwhichisdividedintotwosubsystems,Customerandserverthroughthesystemactivityandgeneratedata,managerscanthroughthissystemtomanagedatabetweentheclientandwaiter,asshowninFigure1.Fig.1.SystemusecaseUMLdiagramCustomerServiceSubsystemUseCaseDiagrams.Thisusecasediagramsmean,whenacustomerhasorder,consultation,checkoutasneededbythecorrespondingservicecalls,andtoldthewaiteryouraccordinglydemand.Waiterfirstonthecomputeroperatingsystemtothecustomerrequirementsintermsofregistration,andthenaccordingtothetelephonenumberinformationforclientshomes,andupdatethemanagementcustomerinformation,finallyplacingorderforthisservice.Managerscanalsousethissystemtotheabovebetweenthecustomerandwaitresswhathappenedmanageserviceactivity5,asshowninFigure2.3Fig.2.CustomerservicesubsystemusecasediagramUseCaseDiagramofBackgroundManagementSubsystem.Thisusecasediagrammeans,throughthesystemmanagementfunction,theadministratortothecustomerofconsumptionrecord,thecustomerdetails,roomnumber,floornumber,diningtables/seats,managebusinessanalysisfunctionandsoon,asshowninFigure3.Fig.3.UsecasediagramofcustomermanagementsubsystemSystemOverallframeDesignHotelmanagementinformationsystemadoptsthreelayersofsystemdesign;itdealswithinthemiddletierofbusinessrules,dataaccess,andthecheckoflegitimacy5.ThissystemusetheMicrosoftDNAstructure,thedefinitionofthreelayersrespectivelyis:thepresentationlayer,thebusinesslogiclayeranddataaccess.Thesystemusersaremainlyincludingsystemadministrators,foremanusersandwaiter.Amongthem:thesystemwheninitializationdefaultAdminsystemadministratoruser,intheprogramdesignisaddedtothedatabase.TheAdminuserhastocreateusers,deleteusers,andmodifyuserinformationsystemsuchasalltheotherfunctions.Foremanuserscanmanagetheserveruser,includingthecreationoftheuser,modifytheuserinformation,anddeleteuserinformation,etc.Buthecannotmanageotherforemanusers.Foremanuserscanuseinadditiontothestatisticsofalltheotherfunctions.Ordinaryuserpermissionsarelow;hecanonlymanageuserinformation.Ordinaryuserscanonlyaccessthereceptionistsandfrontdeskcashierfunctionoftwomodules,asshowninFigure4.4Fig.4.SystemfunctionmodulediagramTheDesignoftheDatabaseInthehotelmanagementsystem,databasedesignworkmainlyincludesthedatabasemanagementsystem,neededtocreatetables,canalsodesignrelatedviewsandstoredprocedures.AllthedesignworkisinSQLServer2008environmentoperationandimplementation6.DatabaseHotelcontainsthefollowingseventables:UsersInfo,CustomersInfo,RoomCategory,Roominfo,RoomStatus,RoomOperation,History,TheUserInformationTable.Userinformationtable(UsersInfo)usedtostorethesystemuserbasicinformation,thetableUsersInfostructureasshownintable1.Table1.userinformationtable(UsersInfo)NumberFieldNameDatastructure1UserIdInt2NameVarchar(50)3PasswordVarchar(50)4GenderVarchar(50)5EmailVarchar(50)6AddressVarchar(50)7TelephoneVarchar(50)8DepartmentVarchar(50)9TypeIntTheCustomerInformationTable.Customerinformationtable(CustomersInfo)isusedto5storethebasicinformationofthehotelcustomers,tableCustomersInfostructureasshownintable2.Table2.thecustomerinformationtable(CustomersInfo)NumberFieldNameDatastructure1CIdentitiIdVarchar(50)2CnameVarchar(50)3CphoneGuestRoomTypesTable.Roomtypetable(RoomCategory)isusedtostorethebasicinformationofthehotelalltheroomtypes,tableRoomCategorystructureasshownintable3.Table3.GuestroomtypestableNumberFieldNameDatastructure1RCategoryIdInt2NameVarchar(50)3AreaFloat4BedNumInt5PriceMoney6AirConditionInt7TVIntGuestRoomInformationTable.Guestroominformationtable(RoomsInfo)isusedtostorethehotelguestroominformation,tableRoomsInfostructureasshownintable4.Table4,guestroominformationNumberFieldNameDatastructure1RoomIdInt2RCategoryIdInt3RpostitionVarchar(50)4DescriptionVarchar(50)ConclusionsInthispaper,thesystemoveralldesignwasdescribed;thesystemframeworkdesignpartofthesystemusesathree-tierarchitectureanalysisandelaboration.Intheintroductiontothedesignofthedatabase,thesysteminvolvedinthemaintablestructureandstorageprocesseswereintroduced.Thehotelmanagementsystemmainlytovariousinternalmanagementofthe6hotelautomation,computerizationandinformationtechnology,improvethehoteleachdepartment,allkindsofpersonnelofficeefficiency,toprovidecustomerswithhighqualityhotelservices.References1XuWenyuan,HeXianghui:Hotellobbymanagementpractices,GuangdongEconomicPress,2005.102HeXianghui,thehotellobbyManagementPractice(thirdedition),GuangdongEconomicPressLimited,2011.093DongHongchun.Starhoteldeskmanagersafetymanagementmanual,Chemicalindustrypress,2010.014PengWeimin.hotelmanagementsystembasedontheneedsoftheModelingandImplementation.managementinformationsystems,2000.95JiGenBao,editorchief.thehotelmanagementpractices,Tsinghuauniversitypress,2011.086ChenYueguo,WangjingChundataintegrationoverview,ComputerScience,2004(5)7中文翻译外文一：酒店管理系统模型研究与设计关键词：酒店管理;系统建模;需求分析;数据库;设计。摘要：为了使酒店的管理工作系统化，规范化和自动化，达到提高酒店客房管理效率的目的。本文设计的酒店管理系统，系统开发的总体任务是使办公人员可以轻松快捷地完成酒店客房管理任务。从实际应用的角度来系统阐述的基本情况;然后介绍了系统的分析和建模，专注于酒店管理系统的功能需求进行了分析，同时对系统设计目标，系统用例图等几个方面，酒店管理系统，主要介绍了框架结构，数据库设计等三层此系统的应用可以灵活，方便地在电脑上管理的酒店客房，从而大大提高了处理速度，使管理更加现代化。介绍酒店业正面临着日益激烈的竞争环境中，一方面，传统的酒店行业难以摆脱低价格，低入住率，低利润的“三低”怪圈;学习酒店管理的信息服务，客房信息查询，预订和管理功能，为业务流程有效整合酒店管理的，完整的信息在管理的过程中共享，为客户提供方便快捷的酒店服务。通过此系统可以在酒店客户，服务人员，管理人员和业主弥合互联，信息管理技术的全面应用，结合企业实际，提高酒店服务质量，规范服务标准。系统功能的需求分析酒店管理系统，主要用于酒店日常信息集，录入和查询，同时在客户之间，服务员，管理员，业主设置了访问的互动平台。在数据查询，为系统管理员，谁照顾的酒店客房信息，客运出租，统计和分析各种其他信息自定义查询，以完成数据库数据的人工监测功能方面。在数据库维护方面，满足系统管理员对数据库的日常管理的需求，主要是本地数据库系统，用于管理和自定义，包括数据表的管理，客房内的数据变化，旅客办理登机手续的信息输入和速率数据计算等。客户信息管理需求。客户信息管理是通过对客户信息的深入分析，来提高客户满意度，从而提升企业的竞争能力。目标是减少销售周期和销售成本，增加收入，寻找扩展业务，新市场和新渠道，提高客户的价值，满意度，盈利能力和忠诚度。酒店信息管理需求。酒店信息管理包括以下功能要求，如与维护，柜台管理，建设管理和业务信息管理和分析等人员信息。系统用例模型用例图被广泛应用于各种系统的开发是在软件需求分析的第一步。它会告诉你如何使用系统，这是如何理解系统中的一些功能性的目的。用例图显示了用户和系统之间的关系，需要用户提供什么样的服务，以及用户需要提供什么样的服务体系。系统总体用例图。后台管理子系统，客户服务子系统是显示系统分为两个子系统，客户和服务器通过系统的活性和生成数据，管理人员可以通过该系统在客户端和服务员之间的管理数据，如图1所示。（见原文）客户服务子系统用例图。这个用例图的意思是，当需要由相应的服务电话，并告诉服务员你的相应要求客户有订单，咨询，结账。服务员先上电脑操作系统在注册方面的8客户需求，然后根据客户端的家庭电话