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

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

《马六甲驾驶学校管理系统外文翻译可编辑文档格式.docx》由会员分享，可在线阅读，更多相关《马六甲驾驶学校管理系统外文翻译可编辑文档格式.docx（10页珍藏版）》请在冰豆网上搜索。

////0>

.&

gid3347&

Itemid208Author:

SITIHAJARSINTIZAINAL

ABSTRACT

TheMalaccaDrivingSchoolManagementSystemMDSMSisdevelopedmainlyfordrivingschooltomanagetheoperationmoreefficient,easilytofinddata,recordkeepingmoreefficientandretrievedatafaster.Thissystemwillbemanagedbytheadministratorandtheclerkofthedrivingschoolcompany.ThemethodologyofthissystemisDatabaseLifeCycleDBLC.Ananalysisstudyhasbeendonebasedonthecurrentmanualsystemandalltheproblemsstatementsandrequirementshavebeenidentified.Moreover,interfaceMDSMShavebeendesignedaccordingtotherequirementandneedofthecompany.Onlytheadministratorandtheauthorizedstaffonlycanaccessthissystem.ThisMalaccaDrivingSchoolManagementSystemwillhelptoimprovetheperformanceofcurrentsituationandovercometheproblemsthatarisenowadays.

1.1ProjectBackground

MalaccaDrivingSchoolManagementSystemisacomputerizedsystem

thatisdevelopsfordrivingschoolcenter.Itmanagesvariousfunctionsinmanagingandhandlingthedrivingschoolcenter.Thedrivingschoolcenterprovidesthedrivingclassformotorcycle,car,lorry,busandothers.Thissystemismanagedbyastafforadminatthecenter.Thestaffisresponsibletoregisterthenewstudents,newstaffsorinstructor,calculationsandpaymentsandsalaryforthestaffsTheproblemcomeswhentherecordsofstudentsandstaffsareincreasinganditisnotsystematicanymoretokeepallthedatainthefilesystemsanymore.Therearedataon5yearsoperationofthedrivingschoolcenterkeptinfilesthatfillhalfoftheroomandmaybethereare5yearsofdatatocomeandallthefileshavetobekeep.Arethecompaniesgoingtoenlargeitsbuildingjusttoaddroomtostoreallthisfiles?

Andhowtokeepitinorderandsecurelywhereonlytheauthorizestaffcanaccessit.Furthermore,ifanyunexpectedincidentordisasterhappens,istheanybackupforallthisimportantinformationSo,theMalaccaDrivingSchoolManagementSystemwillbedevelopedasasolutionfortheentireproblem.TheMalaccaDrivingSchoolManagementSystemwillkeepalltheinformationofthedailydrivingschoolcenteroperationwhichisfromtheinstructor'

srecords,staffsrecordstopaymentofthestaff'

ssalary.TheMalaccaDrivingSchoolManagementSystemwillkeeptrackalloftheoperationinformationsecurelyandorderlyandevenwithbackup.Itiseasyforsearchingandretrievingdata,andmakingchangestoallstoreddata1.2

ProblemStatementsAscurrentsystemisamanualfilingsystem,thereareseveralproblemsthatarestateforthecurrentsystem:

iLowdataretrievalinsearchingThroughthemanualfilingsystem,thedatawillbekeptinfileaccordingtotheyearorcompanyalphabetically.Thismaytaketimetosearchfortheinformationneededintimeasthestaffmayhavetolookthefileonebyoneandotherrelatedfilejusttosearchforsomeinformation.Forexample,ifthestaffwantstosearchtheaddressordetailsoftheirstudents,heorshehastosearchoneveryfile,onebyone.ItwilltakealongtimeiiTheredundancyofdataandnotconsistencyofdataInamanualfilesystemusuallytherearedataredundancyandinconsistency.Thisisbecausethesamedatamaybestoredinvariousfilesastheyarerelatedwitheachother.Thisalsocausesofdataanomaliesandtheninconsistencybecausetheredundantdataarechangedinonefilebutnottheothers.Forexample,repetitivedatamighthappeninarecordofthestudentsbecauseofunsystematicdatamanagement.Suchasifastudentorinstructorschangetheirtelephonenumber,thestaffmaychangetheinformationinonefilebutnottheotherwhichmayalsocontaininformation,thismaycausedataanomaliesiiiThelackofsecurity

Usuallyfornormalfilingsystemthereislackofsecurityasthereisnolimitationonwhocanaccessthefiles.Anyonecanchangetherecordsandthismaycauseserioustroubleinthefuture.Forexample,

intruderscaneasilystealtheimportantinformationabouttheinstructor'

sdetailsorevenastaffthatmaynothavetheauthorityontheinstructor'

sinformationmaystealtheinformationandsellittootherpersonivNobackupandrecoveryforthedataManualfilessystemhasnobackupandifthefileofalltheinformationlostordamage,thedrivingschoolcenterwilllostallit'

svaluableinformation.Forexample,themostimportantdataofthedrivingschool'

scenteristhedetailsofthestudents,staffsandhistory'

sinformation,ifthatdatalost,thedrivingschoolcenterwillfaceabadimpactwheretheymaylosetheirimportantinformationforafutureanalysis1.3Objective

iTomakefasterdataprocessingandaccessing

Tobefastindataprocessingandaccessingbyusingqueryandindexarerequired.Thisisbecausequeryandindexwillhelptoimprovedataretrievalandperformancespeed.Forthesolutionprimaryandforeignkeyarecreatedeachtimetoretrievethedatafromdatabase.Forexample,thedetailsofthestudentsshouldbeeasilyretrievedbythestaffformakingapaymentorforupdatingtherecordiiToimplementthedataintegrityDataintegrityenforcedthroughfortheproperuseofprimaryandforeignkeyrule.Theprimarykeywillhelptoavoiddataredundancyandinconsistency.So,therewouldnotbearedundantdatawhileusingthesystemforsearchingoraddinganewdata.Foranexample,inMalaccaDrivingSchoolManagementSystem,everystudentandinstructorswillhave

theirownrecordsusingcomputerizedsystem.So,therewouldnotberedundancydataespeciallyininstructor'

stimetableiiiToavoidthesystemfrombeingaccessbyunauthorizedperson

Datastoredinthedrivingschool'

scenterdatabasemustbeprotectedfrombeingaccessbyunauthorizedusers.Inthissystem,usersareprovidedwithpasswordthatallowstheassignmentofaccessrightstospecificauthorizedusers.PasswordusuallyenforcedatlogontimeivTomakedatabackupandrecoveryofthedataDatabackupandrecoverycreateasafetyvalues,allowingthedatabaseadministratortoensuretheavailabilityofconsistentdata.Thesystemwillusedthecentralizeddatabaseandwillmakeeasytobackupthedata.Forexample,alltheinformationofthecenter,studentsandstaffswillbebackupintheexternalharddisc.So,ifthedatabasecorrupts,westillcanusethedatabaseintheexternalharddisc1.4Scope

ScopesofthisMalaccaDrivingSchoolManagementSystemincludedthetargeteduserandfunctionthatincludedinthesystem1.4.1User

TheuserofthisMalaccaDrivingSchoolManagementSystemwillbedividedintohigh-levelstaff,low-levelstaffandothersusersiHigh-levelstaff

Theadministratoristhehigh-levelstaff.Theyhavehighlevelauthorityofusingthesystem.Besidethat,theyknowalltheflowofthesystemandalsocanviewallthedetailsofthesystemTheadministrator

willsetthedatapoliciesforthecompany,setthestandardforcontrolandusageofdataTheadministratorsalsohavetomaketheback-up,maintenanceandtuningofthesystemBesidesallthecommonfunctionsofthesystem,themostobviousauthoritytheyhaveareviewthereportofthecenter'

sprogress,andfinancialiiLow-levelstaff

Staffhastoplacefortheregistrationofnewstudentsorstaff,suchaspersonaldetailsandothersThestaffalsocanadd,updateandsearchfortherelateddataBytheway,low-levelstaffcannotdeletethedatathatrelatedtotheregistrationLow-levelstaffalsocannotviewthereportinformation1.4.2Function

Thissystemincludesseveralfunctionswhichare:

1.4.2.1Registration

iAdd

TheusercanaddnewstudentsorstaffintothedatabaseThisfunctioncandobytheauthorizestaffofthiscompanyiiDelete

Theusercandeletethedataofthestudentsandstaff.ItisincludethedetailsofthemiiiEdit

TheyalsocaneditthechangesofthestudentsorinstructorsandsaveitasupdatedataivSearch

ThisfunctionisfortheusersearchtherelateddataoranyinformationTheusercansearchinformationaboutthestudents,andstaffdetailsThestaffcansearchthedatabyidnumber,nameof

studentsandinstructors1.4.2.2LogIn

Beforetheyusethissystem,thehigh-levelstaffandlow-levelstaffneedtobeloginTheywillentertheuseridandthepasswordAftersuccesstologin,theycanproceedtousethesystem1.4.2.3LogOut

Aftertheuserfinishingusethesystemandtheywanttoexit,theyneedtologoutfromthesystem1.4.2.4Searching

ThisfunctionisfortheusersearchtherelateddataoranyinformationTheusercansearchinformationaboutthestudentsandstaffThestaffcansearchthedatabyIDnumberofstudentsorstaff1.4.2.5Payment

ThestaffcanaddthenewpaymentofthestudentsintothesystemThelow-levelstaffwillalwaysusethisfunctioniiDelete

ThestaffcandeletetheunneededdataofthepaymentiiiEdit

ThestaffcanmakethechangesofthepaymentdataivSearch

TheyalsocansearchtheunpaidortotalpaymentTheycansearchtherelateddatabytheIDnumberofstudents.

1.5ProjectSignificance

Theprojectssignificantofthisprojectare:

iDatastoragemanagement

Thedatathatarestoredindatabasewillbeeasilymanageand

access.ThetopLevelmanagementcanprovideadhocqueryforthedatabase.Forexample,thestudent'

sdetailscanbearchivebythestudent'

sICNumber;

thisisalsofortheupdating,paymentandsearchingiiDecreaseTime

Itwilldecreaseprocessingtimebecausewehavethedatabase.Theusercansearchinformationfastandaccurately.Misinformationwillbeavoidedbecausethedatabase