《马六甲驾驶学校管理系统外文翻译(可编辑).docx》由会员分享,可在线阅读,更多相关《马六甲驾驶学校管理系统外文翻译(可编辑).docx(18页珍藏版)》请在第一文库网上搜索。
1、马六甲驾驶学校管理系统外文翻译(可编辑)马六甲驾驶学校管理系统外文翻译外文翻译Ma1accadrivingschoo1managementsystemMateria1Source0.&gid3347&Itemid208Author:SITIHAJARSINTIZAINA1ABSTRACTTheMa1accaDrivingSchoo1ManagementSystemMDSMSisdeve1opedmain1yfordrivingschoo1tomanagetheoperationmoreefficient,easi1ytofinddata,recordkeepingmoreefficientan
2、dretrievedatafaster.Thissystemwi11bemanagedbytheadministratorandthec1erkofthedrivingschoo1company.Themethodo1ogyofthissystemisDatabase1ifeCyc1eDB1C.Anana1ysisstudyhasbeendonebasedonthecurrentmanua1systemanda11theprob1emsstatementsandrequirementshavebeenidentified.Moreover,interfaceMDSMShavebeendesig
3、nedaccordingtotherequirementandneedofthecompany.On1ytheadministratorandtheauthorizedstaffon1ycanaccessthissystem.ThisMa1accaDrivingSchoo1ManagementSystemwi11he1ptoimprovetheperformanceofcurrentsituationandovercometheprob1emsthatarisenowadays.1.1ProjectBackgroundMa1accaDrivingSchoo1ManagementSystemis
4、acomputerizedsystemthatisdeve1opsfordrivingschoo1center.Itmanagesvariousfunctionsinmanagingandhand1ingthedrivingschoo1center.Thedrivingschoo1centerprovidesthedrivingc1assformotorcyc1e,car,1orry,busandothers.Thissystemismanagedbyastafforadminatthecenter.Thestaffisresponsib1etoregisterthenewstudents,n
5、ewstaffsorinstructor,ca1cu1ationsandpaymentsandsa1aryforthestaffsTheprob1emcomeswhentherecordsofstudentsandstaffsareincreasinganditisnotsystematicanymoretokeepa11thedatainthefi1esystemsanymore.Therearedataon5yearsoperationofthedrivingschoo1centerkeptinfi1esthatfi11ha1foftheroomandmaybethereare5years
6、ofdatatocomeanda11thefi1eshavetobekeep.Arethecompaniesgoingtoen1argeitsbui1dingjusttoaddroomtostorea11thisfi1es?Andhowtokeepitinorderandsecure1ywhereon1ytheauthorizestaffcanaccessit.Furthermore,ifanyunexpectedincidentordisasterhappens,istheanybackupfora11thisimportantinformationSo,theMa1accaDrivingS
7、choo1ManagementSystemwi11bedeve1opedasaso1utionfortheentireprob1em.TheMa1accaDrivingSchoo1ManagementSystemwi11keepa11theinformationofthedai1ydrivingschoo1centeroperationwhichisfromtheinstructor1srecords,staffsrecordstopaymentofthestaff,ssa1ary.TheMa1accaDrivingSchoo1ManagementSystemwi11keeptracka11o
8、ftheoperationinformationsecure1yandorder1yandevenwithbackup.Itiseasyforsearchingandretrievingdata,andmakingchangestoa11storeddata1.2Prob1emStatementsAscurrentsystemisamanua1fi1ingsystem,therearesevera1prob1emsthatarestateforthecurrentsystem:i1owdataretrieva1insearchingThroughthemanua1fi1ingsystem,th
9、edatawi11bekeptinfi1eaccordingtotheyearorcompanya1phabetica11y.Thismaytaketimetosearchfortheinformationneededintimeasthestaffmayhaveto1ookthefi1eonebyoneandotherre1atedfi1ejusttosearchforsomeinformation.Forexamp1e,ifthestaffwantstosearchtheaddressordetai1softheirstudents,heorshehastosearchoneveryfi1
10、e,onebyone.Itwi11takea1ongtimeiiTheredundancyofdataandnotconsistencyofdataInamanua1fi1esystemusua11ytherearedataredundancyandinconsistency.Thisisbecausethesamedatamaybestoredinvariousfi1esastheyarere1atedwitheachother.Thisa1socausesofdataanoma1iesandtheninconsistencybecausetheredundantdataarechanged
11、inonefi1ebutnottheothers.Forexamp1e,repetitivedatamighthappeninarecordofthestudentsbecauseofunsystematicdatamanagement.Suchasifastudentorinstructorschangetheirte1ephonenumber,thestaffmaychangetheinformationinonefi1ebutnottheotherwhichmaya1socontaininformation,thismaycausedataanoma1iesiiiThe1ackofsec
12、urityUsua11yfornorma1fi1ingsystemthereis1ackofsecurityasthereisno1imitationonwhocanaccessthefi1es.Anyonecanchangetherecordsandthismaycauseserioustroub1einthefuture.Forexamp1e,intruderscaneasi1ystea1theimportantinformationabouttheinstructor,sdetai1sorevenastaffthatmaynothavetheauthorityontheinstructo
13、r,sinformationmaystea1theinformationandse11ittootherpersonivNobackupandrecoveryforthedataManua1fi1essystemhasnobackupandifthefi1eofa11theinformation1ostordamage,thedrivingschoo1centerwi111osta11it,sva1uab1einformation.Forexamp1e,themostimportantdataofthedrivingschooscenteristhedetai1softhestudents,s
14、taffsandhistory,sinformation,ifthatdata1ost,thedrivingschoo1centerwi11faceabadimpactwheretheymay1osetheirimportantinformationforafutureana1ysis1.3ObjectiveiTomakefasterdataprocessingandaccessingTobefastindataprocessingandaccessingbyusingqueryandindexarerequired.Thisisbecausequeryandindexwi11he1ptoim
15、provedataretrieva1andperformancespeed.Fortheso1utionprimaryandforeignkeyarecreatedeachtimetoretrievethedatafromdatabase.Forexamp1e,thedetai1softhestudentsshou1dbeeasi1yretrievedbythestaffformakingapaymentorforupdatingtherecordiiToimp1ementthedataintegrityDataintegrityenforcedthroughfortheproperuseof
16、primaryandforeignkeyru1e.Theprimarykeywi11he1ptoavoiddataredundancyandinconsistency.So,therewou1dnotbearedundantdatawhi1eusingthesystemforsearchingoraddinganewdata.Foranexamp1e,inMa1accaDrivingSchoo1ManagementSystem,everystudentandinstructorswi11havetheirownrecordsusingcomputerizedsystem.So,therewou1dnotberedundancydataespecia11yininstructor,stimetab1eiiiToavoidthesystemfrombeingaccessbyunauthorizedpersonDatastoredinthedrivingschoo1,scenterdatabasemustbeprotec