马六甲驾驶学校管理系统外文翻译(可编辑).docx

马六甲驾驶学校管理系统外文翻译（可编辑）马六甲驾驶学校管理系统外文翻译外文翻译MalaccadrivingschoolmanagementsystemMaterialSource0>.&gid3347&Itemid208Author:SITIHAJARSINTIZAINALABSTRACTTheMalaccaDrivingSchoolManagementSystemMDSMSisdevelopedmainlyfordrivingschooltomanagetheoperationmoreefficient,easilytofinddata,recordkeepingmoreefficientandretrievedatafaster.Thissystemwi11bemanagedbytheadministratorandtheclerkofthedrivingschoolcompany.ThemethodologyofthissystemisDatabaseLifeCycleDBLC.Ananalysisstudyhasbeendonebasedonthecurrentmanualsystemandalltheproblemsstatementsandrequirementshavebeenidentified.Moreover,interfaceMDSMShavebeendesignedaccordingtotherequirementandneedofthecompany.Onlytheadministratorandtheauthorizedstaffonlycanaccessthissystem.ThisMalaccaDrivingSchoolManagementSystemwillhelptoimprovetheperformanceofcurrentsituationandovercometheproblemsthatarisenowadays.1.1ProjectBackgroundMalaccaDrivingSchoolManagementSystemisacomputerizedsystemthatisdevelopsfordrivingschoolcenter.Itmanagesvariousfunctionsinmanagingandhandlingthedrivingschoolcenter.Thedrivingschoolcenterprovidesthedrivingclassformotorcycle,car,lorry,busandothers.Thissystemismanagedbyastafforadminatthecenter.Thestaffisresponsibletoregisterthenewstudents,newstaffsorinstructor,calculationsandpaymentsandsalaryforthestaffsTheproblemcomeswhentherecordsofstudentsandstaffsareincreasinganditisnotsystematicanymoretokeepallthedatainthefilesystemsanymore.Therearedataon5yearsoperationofthedrivingschoolcenterkeptinfilesthatfillhalfoftheroomandmaybethereare5yearsofdatatocomeandallthefileshavetobekeep.Arethecompaniesgoingtoenlargeitsbuildingjusttoaddroomtostoreallthisfiles?Andhowtokeepitinorderandsecurelywhereonlytheauthorizestaffcanaccessit.Furthermore,ifanyunexpectedincidentordisasterhappens,istheanybackupforallthisimportantinformationSo,theMalaccaDrivingSchoolManagementSystemwillbedevelopedasasolutionfortheentireproblem.TheMalaccaDrivingSchoolManagementSystemwillkeepalltheinformationofthedailydrivingschoolcenteroperationwhichisfromtheinstructor1srecords,staffsrecordstopaymentofthestaff,ssalary.TheMalaccaDrivingSchoolManagementSystemwillkeeptrackalloftheoperationinformationsecurelyandorderlyandevenwithbackup.Itiseasyforsearchingandretrievingdata,andmakingchangestoallstoreddatal.2ProblemStatementsAscurrentsystemisamanualfilingsystem,thereareseveralproblemsthatarestateforthecurrentsystem:iLowdataretrievalinsearchingThroughthemanualfilingsystem,thedatawi11bekeptinfileaccordingtotheyearorcompanyalphabetically.Thismaytaketimetosearchfortheinformationneededintimeasthestaffmayhavetolookthefileonebyoneandotherrelatedfilejusttosearchforsomeinformation.Forexample,ifthestaffwantstosearchtheaddressordetailsoftheirstudents,heorshehastosearchoneveryfile,onebyone.ItwilltakealongtimeiiTheredundancyofdataandnotconsistencyofdataInamanualfilesystemusuallytherearedataredundancyandinconsistency.Thisisbecausethesamedatamaybestoredinvariousfilesastheyarerelatedwitheachother.Thisalsocausesofdataanomaliesandtheninconsistencybecausetheredundantdataarechangedinonefilebutnottheothers.Forexample,repetitivedatamighthappeninarecordofthestudentsbecauseofunsystematicdatamanagement.Suchasifastudentorinstructorschangetheirtelephonenumber,thestaffmaychangetheinformationinonefilebutnottheotherwhichmayalsocontaininformation,thismaycausedataanomaliesiiiThelackofsecurityUsuallyfornormalfi1ingsystemthereislackofsecurityasthereisnolimitationonwhocanaccessthefiles.Anyonecanchangetherecordsandthismaycauseserioustroubleinthefuture.Forexample,intruderscaneasilystealtheimportantinformationabouttheinstructor,sdetailsorevenastaffthatmaynothavetheauthorityontheinstructor,sinformationmaystealtheinformationandsellittootherpersonivNobackupandrecoveryforthedataManualfilessystemhasnobackupandifthefileofalltheinformationlostordamage,thedrivingschoolcenterwilllostal1it,svaluableinformation.Forexample,themostimportantdataofthedrivingschooscenteristhedetailsofthestudents,staffsandhistory,sinformation,ifthatdatalost,thedrivingschoolcenterwillfaceabadimpactwheretheymaylosetheirimportantinformationforafutureanalysis1.3ObjectiveiTomakefasterdataprocessingandaccessingTobefastindataprocessingandaccessingbyusingqueryandindexarerequired.Thisisbecausequeryandindexwillhelptoimprovedataretrievalandperformancespeed.Forthesolutionprimaryandforeignkeyarecreatedeachtimetoretrievethedatafromdatabase.Forexample,thedetailsofthestudentsshouldbeeasilyretrievedbythestaffformakingapaymentorforupdatingtherecordiiToimplementthedataintegrityDataintegrityenforcedthroughfortheproperuseofprimaryandforeignkeyrule.Theprimarykeywillhelptoavoiddataredundancyandinconsistency.So,therewouldnotbearedundantdatawhileusingthesystemforsearchingoraddinganewdata.Foranexample,inMalaccaDrivingSchoolManagementSystem,everystudentandinstructorswi11havetheirownrecordsusingcomputerizedsystem.So,therewouldnotberedundancydataespeciallyininstructor,stimetableiiiToavoidthesystemfrombeingaccessbyunauthorizedpersonDatastoredinthedrivingschool,scenterdatabasemustbeprotec