Hotel management system in a DBMS project

Hostel management system

1. C.BYREGOWDA INSTITUTEOFTECHNOLOGY
AnISO90012015Certified Institute
DepartmentofComputerScienceandEngineering
SrinivaspuraRoad,Kolar–563101
2023-2024
VisvesvarayaTechnologicalUniversity
“JnanaSangama,”Belagavi-590018
DBMSMiniProjectReporton
“HOTELMANAGEMENT SYSTEM"
SubmittedinpartialfulfilmentofrequirementfortheIV semester
BachelorofEngineeringinComputerScience andEngineeringSubmitted
By
ABHILASH.N-1CK22CS001
ARAVINDA.HN-1CK22CS013
AVINASH-1CK22CS018
Undertheguidanceof
Prof.VANITHALB
AsstProfessor,DeptofCSE,CBIT-KOLAR

2. CERTIFICATE
ThisisCertifiedthattheminiprojectreportentitledwith“HOTELMANAGEMENT
SYSTEM”isaBonafideworkcarriedoutbyABHILASH.N&ARAVINDA.HN,
AVINASH bearingtheuniversityseatnumber1CK22CS001&1CK22CS013,
1CK22CS018partialfulfilmentfortheawardofBachelorofEngineeringin
ComputerScience&EngineeringoftheVisvesvarayaTechnologicalUniversity,
Belagaviduringtheyear2023-2024.Itiscertifiedthatallcorrections/suggestionsindicated
fortheinternalassessmenthavebeenincorporatedintheminiprojectreport.Themini
projectreporthasbeenapprovedasitsatisfiestheacademicrequirementsprescribedfor
theIVsemesterBachelorofEngineeringDegree.
C.BYREGOWDA INSTITUTEOFTECHNOLOGY
AnISO90012015CertifiedInstitute
DepartmentofComputerScienceandEngineering
(Srinivaspura Road,Kolar(T&D)Kolar–563101)
NameofExaminers SignatureofExaminar
SignatureofGuide
Prof.VANITHALB
Asst.Professor
Dept.ofCSE,CBITKolar
SignatureoftheHOD
Dr.VASUDEVAR
Assoc.Professor&HOD
Dept.of CSE,CBITKolar

3. ABSTRACT
ThisprojectaimsatcreatingonHotelManagementSystemwhichcanbeusedby Admin
andCustomers.Theadmintoadvise/publishtheavailabilityofroomsin differenthotels
andcustomersarecheckingtheavailabilityofroominrequired hotel.Customersshould
beabletoknowtheavailabilityoftheroomsona particulardatetoreserveinhotel.They
shouldbeabletoreservetheavailable roomsaccordingtotheirneedinadvancetomake
theirstaycomfortable.The Adminhandsthebookinginformationofcustomers.The
userscanregisterand logintothesystem.
Theadministratorwillknowthedetailsofreservationanddailyincome.Thehotel
departmentmaintaintheseatavailabilityandbookingdetailsincertaindatabase.This
projectprovideshighsecuritytoAdminanduserinformation.
i

4. DECLARATION
ABHILASH.N-1CK22CS001
ARAVINDA.H.N-1CK22CS013
AVINASH-1CK22CS018
WeABHILASH.N&ARAVINDA.H.N,AVINASHbearingUSN1CK22CS001&
1CK22CS013,1CK22CS018studentof4thsemesterB.E,ComputerScienceand
EngineeringofVTU,declarethatthisreportentitled“HOTELMANAGEMENT”,
embodiesthereportoftheminiprojectcarriedoutundertheguidanceofProf.
VANITHALBDept.ofCSE,CBITaspartialfulfilmentoftherequirementoftheawardofthe
degreeinBachelorofEngineering,ComputerScienceandEngineering,affiliatedto
VisvesvarayaTechnologicalUniversity,Belagaviduringtheacademicyear2023-2024.Further
thecontentembodiesintheminiprojectreporthasnotbeensubmittedpreviouslybyanybody
fortheawardofanyotherdegree.
ii

5. ACKNOWLEDGEMENT
Thecompletionofanyworkis ashowcaseofconstantdedicationandco-operationofmany people
wholenttheirhandswhichwentseenorunseen.
WearegratefultoourInstitutionandManagement,C.BYREGOWDA INSTITUTEOF
TECHNOLOGY withitsidealsandinspirationsforhavingprovideduswiththe
facilities,whichhasmadethisprojectasuccess.
WewouldliketothankourbelovedPrincipalDr.SNCHANDRASHEKARA ,CBITforhis
kinddispositionforcompletingthisundertakingsuccessfully.
WeexpressourheartfullgratitudetoDr.VASUDEVA R,ProfessorandHOD,
DepartmentofComputerscience&Engineering,CBIT,forgivingusguidance,valuableadvice
andsupport.
Weextendourgratitudetoourcoordinator&guideProf.VANITHALB,Asst.
Professor,DepartmentofComputerScience&Engineering,CBITforhervaluableadvice,
supportandconstructivesuggestions.
WealsothanktoallourprofessorsandtheentiredepartmentofComputerScience&
Engineeringfortheirco-operationandsuggestions.
ThereportwouldbeincompleteifIdonotthankourparentsandfriendsfortheircontinuous
encouragementandmoralsupport.
ABHILASH.N-1CK22CS001
ARAVINDA-1CK22CS013
AVINASH-1CK22CS018
iii

6. TABLEOFCONTENTS
1
2
CHAPTERNO
ASBTRACT
DECLARATION
ACKNOWLEDGMWNT
TABLEOFCONTENTS
LISTOFFIGURES
CHAPTERNAME
INTRODUCTION TODBMS
1.Introduction
2.Applicationsof DBMS
3.IntroductiontoSQL
4.BasicSQLoperations
5.BenefitsofusingSQL
HOTELMANAGEMENT SYSTEM
1.Introduction
2.Objective
3.Scopeofproject
4.Methodology
5.Projectframework
6.Systemanalysis
1
2
3
4
4
5
5
6
6
6
6
PAGENO
i
ii
iii
iv
vi
3 LITERATURESURVEY
1.Overview
2.Existingsystem
3.Proposedsystem
7
7
7
iv

7. 3
4
5
6
7
CHAPTERNO CHAPTERNAME
LITERATURESURVEY
1.Overview
2.Existingsystem
3.Proposedsystem
HARDWARE ANDSOFTWARE REQUIREMENTS
1.Hardwarerequirements
2.Softwarerequirements
DESIGNPHASE
1.Introduction
2.Usecasedesign
3.Schemadiagram
4.ER-diagram
IMPLEMENTATION
1.Introduction
2.Platform
3.Language
4.Tables
5.Implementationofcode
6.SQLqueries
CONCLUSIONANDFUTURE ENHANCEMENT
1.Conclusion
2.Futureenhancement
7
7
7
8
8
11
11
11
12
13
15
9
9
10
10
19
19
PAGENO
REFERENCES
20
8
9
SNAPSHOTS
21
v

8. FIGURE NO FIGURE NAME PAGE NO
5.1 Usecase diagram 10
5.2 Schema diagram 11
5.3 Entity Relationship
diagram
12
6.4 Tables 14-15
S.1 Homepage 25
S.2 Login page 25
S.3 User dashboard 26
S.4 Reservation details 26
S.5 Admin status 27
S.6 Contactus 27
S.7 Payment details 28
VI
LIST OF FIGURES

9. CHAPTER1
INTRODUCTIONTODBMS
1.1INTRODUCTION
ADatabaseManagementSystem(DBMS)isasoftwaresuitedesignedtofacilitatethe
creation,organization,retrieval,andmanipulationofdatainastructuredformat.Itserves
asanintermediarybetweenusersanddatabases,providinganinterfaceforuserstointeract
withthedatawhileensuringitsintegrityandsecurity.DBMSarecrucialcomponentsof
moderninformationsystems,utilizedacrossvariousindustriesandapplications,including
banking,healthcare,education,e-commerce,andmore.Theyofferseveralkeyfunctionalities:
1.DataOrganization:DBMSsenabletheefficientorganizationofdataintological
structuressuchastables,rows,andcolumns.Thisorganizationallowsforeasystorageand
retrievalofinformationbasedonpredefinedrelationshipsanddatamodels.
2.DataRetrievalandManipulation:UserscanqueryDBMSstoretrievespecificinformation
fromthedatabaseusingstructuredquerylanguages(SQL)orotherinterfaces.DBMSsalso support
datamanipulationoperations,includinginsertion,deletion,andmodificationof records.
3.ConcurrencyControl:DBMSmanageconcurrentaccesstothedatabasebymultipleusersor
applications,ensuringdataconsistencyandintegrity.Throughmechanismssuchaslocking
andtransactionmanagement,DBMSspreventconflictsandmaintaintheaccuracyofdataduring
simultaneousoperations.
4.DataSecurityandIntegrity:DBMSimplementsecuritymeasurestoprotectsensitive
datafromunauthorizedaccess,ensuringcompliancewithprivacyregulationsandorganizational
policies.Theyalsoenforcedataintegrityconstraintstomaintaintheaccuracyandconsistencyof
informationstoredinthedatabase.
5.ScalabilityandPerformance:DBMSsaredesignedtoscalewithgrowingdatavolumes
anduserdemands,providingefficientstorageandretrievalmechanisms.Theyoptimizequery
processingandresourceutilizationtodeliverhighperformanceevenunderheavyworkloads.
Databasescalabilityistheabilitytoexpandorcontractthecapacityofsystemresourcesin
ordertosupportthechangingusageofyourapplication.Thiscanreferbothtoincreasingand
decreasingusageoftheapplication.
1

10. 1.2APPLICATIONSOFDBMS
DatabaseManagementSystems(DBMS)findapplicationacrossvariousdomainsduetotheir
abilitytoefficientlymanage,organize,andretrievelargevolumesofdata.Herearesomecommon
applicationsofDBMS:
1.EnterpriseResourcePlanning(ERP)Systems:ERPsystemsintegratevarious
businessprocessesanddepartmentswithinanorganization,suchasfinance,humanresources,
inventorymanagement,andcustomerrelationshipmanagement(CRM).DBMSsstoreand
managedatarelatedtotheseprocesses,enablingseamlesscoordinationandinformation
sharingacrosstheenterprise.
2.CustomerRelationshipManagement(CRM)Systems:CRMsystemshelpbusinesses manage
interactionswithcurrentandpotentialcustomers.DBMSsstorecustomerinformation, includingcontact
details,purchasehistory,preferences,andfeedback,allowingorganizations
topersonalizemarketingstrategies,improvecustomerservice,andenhancecustomerretention.
3.E-commercePlatforms: E-commerceplatformsrelyonDBMSstostoreproduct catalogues,
customerorders,paymenttransactions,andinventorydata.Byefficiently managingthis
information,DBMSsenablesmoothonlineshoppingexperiences,secure paymentprocessing,
andreal-timeinventorymanagementfore-commercebusinesses.
4.HealthcareInformationSystems:HealthcareinstitutionsutilizeDBMSstomanagepatient records,
medicalhistories,diagnosticreports,treatmentplans,andbillinginformation.DBMSs
ensuretheconfidentiality,integrity,andaccessibilityofsensitivehealthcaredata,facilitating
efficientpatientcare, medicalresearch,andregulatorycompliance.
5.BankingandFinancialSystems:BanksandfinancialinstitutionsrelyonDBMSstostore and
managecustomeraccounts, transactions,loanportfolios,credithistories,and regulatory
compliancedata.DBMSssupportsecureandreliablebankingoperations,includingonline
banking,ATMtransactions,frauddetection,andriskmanagement.
6.TelecommunicationsSystems:TelecommunicationscompaniesuseDBMSstostore
subscriberinformation,callrecords,networkconfigurations,billingdetails,andservice
provisioningdata.DBMSs enableefficientmanagementoftelecommunications
infrastructure,networkoptimization,andbillingaccuracyfortelecomproviders.
7.SupplyChainManagement(SCM)Systems:SCMsystemstracktheflowofgoods,
materials,andinformationacrosssupplychains,fromrawmaterialsourcingtoproductdelivery.
DBMSsstoredatarelatedtoinventorylevels,supplierrelationships,orderfulfilment,
logistics,anddistributionnetworks,facilitatingefficientsupplychainoperationsand
collaborationamongstakeholders.
2
HOTELMANAGEMENT SYSTEM CHAPTER1
DeptofCSE-CBIT-KOLAR 2023-24

11. 3
8.EducationalInstitutions:EducationalinstitutionsleverageDBMSstomanagestudent records,
courseschedules,academicperformance,facultyinformation,libraryresources,and administrative
operations.DBMSssupportstudentenrolment,grading,courseplanning,and institutionalresearch
efforts,enhancingeducationalqualityandadministrativeefficiency.
1.3INTRODUCTIONTOSQL
SQL,whichstandsforStructuredQueryLanguage,isapowerfulandstandardized programming
languageusedformanagingandmanipulatingrelationaldatabases.Itprovidesa comprehensivesetof
commands andsyntaxfor performingvariousoperationsondatastoredinarelationaldatabase
managementsystem(RDBMS).
KeyComponentsofSQL:
1.DataDefinitionLanguage(DDL):
DDLstatementsareusedtodefine,modify,anddeletedatabaseobjectssuchastables, indexes,
andviews.
Common DDLcommandsincludeCREATE,ALTER,DROP,andTRUNCATE.
2.Data ManipulationLanguage(DML):
DMLstatementsareusedtoretrieve,insert,update,anddeletedataindatabasetables.
CommonDMLcommandsincludeSELECT,INSERT,UPDATE,andDELETE.
3.DataControlLanguage(DCL):
DCLstatementsareusedtocontrolaccesspermissionsandprivileges ondatabase objects.
CommonDCLcommandsincludeGRANTand REVOKE.
4.TransactionControlLanguage(TCL):
TCLstatementsareusedtomanagetransactionswithinadatabase. Common
TCL commandsincludeCOMMIT,ROLLBACK,andSAVEPOINT.
1.4BASICSQLOPERATIONS:
1.CreatingTables:
CREATETABLEtable_name(
column1datatype,
column2datatype,…
);
2.InsertingData:
INSERTINTOtable_name(column1,column2,...)
VALUES(value1,value2,...);
HOTELMANAGEMENT SYSTEM CHAPTER1
DeptofCSE-CBIT-KOLAR 2023-24

12. 3.QueryingData:
SELECTcolumn1,column2,
...FROM table_nameWHERE
condition;
4.UpdatingData:
UPDATEtable_name
SETcolumn1=value1,column2=value2,...
WHEREcondition;
5.DeletingData:
DELETEFROMtable_name
WHEREcondition;
1.5BENEFITSOFUSINGSQL
FasterProcessingSpeed Minimal
RequirementofCoding
EasierDataManipulation
BetterDataMining
RestrictedAccess
ReliableforComplicatedQueries
4
HOTELMANAGEMENT SYSTEM CHAPTER1
DeptofCSE-CBIT-KOLAR 2023-24

13. CHAPTER2
HOTELMANAGEMENT SYSTEM
INTRODUCTION
HotelManagementSystemisahotelreservationsitescriptwheresiteuserswillbe ableto
searchroomsavailabilitywithanonlinebookingreservationssystem.Site
userscanalsobrowsehotels,viewroominventory,checkavailability,andbook reservationsin
real-time.Siteusersentercheckindateandcheckoutdatethen searchforavailabilityand
rates.Afterchoosingtherightroominthewantedhotel-all bookingandreservationprocessis
doneonthesiteandanSMSissenttoconfirmthe booking.
AdministerPanel
Administrator-Administratorcanmanageadministratoraccountsandconfirmtherooms.
RoomTypes-Administratorcandefinethetypeofroomsinthehotels,room’spricesand
upload
animageforeachroom.
Bookings-Allbookingandreservationsmadeonthesitearedisplayedwith allbooking
details:
arrivaldate,departuredate,hotelname,roomtype,numberofpassengers,price.
2.2OBJECTIVE
Themainobjectiveofhotelorganizationcouldbeimprovedbyintegratingservice-oriented operations
service-orientedoperationswithprojectmanagementprinciples.Suchintegration
wouldinstillinnovation,proactiveattitudesandregulatedrisk-takingneededtopursueongoing
improvementandproactiveresponsetochange.Bymanagingeachchangeasprojectembedded
in smoothlyrunningoperations,hotelswouldextendtheirlifespan bycontinuouslyreinventing
themselves.Duetowhichthecustomerscaneasilybookthehotelsrooms.
NeedsofHotelManagementSystem
Thissystemwillhelpadministrationtowork easily.Becauseofitseasyaccessandless time
consumingadministrationcangettheinformationoftheUsers,Rooms,Payments,
etc.Theydonothavetosearchinthepaperfileforthelogtime.Membersaneasily handle
thesystem.
5

14. HOTELMANAGEMENT SYSTEM CHAPTER2
1.SCOPEOFPROJECT
Thisactivityisalsoknownasthefeasibilitystudy.
Performandevaluatefeasibilitystudieslikecost-benefitanalysis,technicalfeasibility,time
feasibilityandoperational feasibilityfortheproject.ProjectSchedulingshouldbemadeusing chats.
Feasibilitystudyiscarriedouttodecidewhethertheproposedsystemisfeasibleforthe company.It
beginswitharequestfromtheuserforanewsystem.Itinvolvesthefollowing:
Identifytheresponsibleuserforanew system Clarify theuserrequest
Identifydeficienciesinthecurrentsystem
Establish goalsandobjectivesforthenewsystem Determinethefeasibility forthenewsystem
PrepareaprojectcharterthatwillbeusedtoguidetheremainderoftheProject
2.METHODOLOGY/PROCEDURE
ForthedevelopmentoftheprojectthedesigningisdoneonPHPMYADMIN, backendwas
codedinbasisofphpandsamefrontendweusethesamephpcodes.Softwaremethodologies
areconnectedwiththeprocessofcreatingsoftware-notsomuchthetechnicalsidebut
organizationaspects.Severalsoftwaredevelopmentapproachessincehaveusedtheoriginof
informationtechnology.
3.PROJECTFRAMEWORK:
Aframeworkisastandardizedsetofconcepts,practices,andcriteriafordealingwitha
commontypeofproblem,whichcanbeusedasareferencetohelpusapproachand
resolvenewproblemsofsimilarnature.Theaimofframeworkistoprovideacommon
structuresothatdevelopersdon’thavetoredoitfromscratchandcanreusethecode
provided.Inthisway,frameworksallowsustocutoutmuchoftheworkandsavealotof
time.
4.SYSTEMANALYSIS
SystemAnalysisisadetailedstudyofthevariousoperationsperformedbyasystemandtheir
relationshipswithinandoutsideofthesystem.Herethekeyquestioniswhyallproblemsexist
inthepresentsystem?Whatmustbedonetosolvetheproblem?Analysisbeginswhenauser
ormanagerbeginsastudyoftheprogramusingexistingsystem.Thecommonlyusedtools
inthesystemareDataFlowDiagrammatic.Training,experienceacommonsenseare
requiredforcollectionofrelevantinformationneededtodevelopthesystem.The
successofthesystemdependslargelyonhowclearlytheproblemisdefined,thoroughly
investigatedandproperlycarriedoutthroughthechoiceofsolution.Agoodanalysismodel
shouldprovidenotonlythemechanismsofproblemunderstandingbutalsotheframe
workofthesolution.
DeptofCSE-CBIT-KOLAR 6 2023-2024

15. CHAPTER3
LITERATURESURVEY
3.1OVERVIEW
HotelManagementprojectprovidesroombooking,meals,andothernecessaryhotel
managementfeatures.Thesystemallowsthemanagertopostavailableroomsinthesystem.
Customerscanviewandbookroomonline.Adminhasthepowerofeitherapprovingor
disapprovingthecustomers’sbookingrequest.
3.2EXISTINGSYSTEM
ExistingSystemmeansthecurrentsystemonwhichallcalculationsaredone
manually.Theexistingsystemusespaperworkanddirecthumanlanguage
communicationbymouthtomanagethehotel.Thisdelaysinformationtransmissioninthe
hotel.Bookingisdonethroughphonecallsorthroughvisittothehotelbookingoffice.The
guest’spersonaldetailssuchasName,Age,NationalityandDurationofstay,areinputduring
bookingin.Thebookingofficeordersforpreparationoftheguest’sroombeforehis/hercheck
indate.Someofthelimitationsoftheexistingsystemcanbeconcludedasfollows:
Intheexistingsystem,allthedataismaintainedindifferentfilesandregisters.Thatoften
leadstodataduplicationandredundancyinthestoreddata,thusendingtowastagesof
storageofspace.
Intheexistingsystem,dataofcustomersareenteredintovariouslongregisteredthatis
customersregisteretc.whichresultintoslowaccesstothedesiredinformation.
Intheexistingsystem,sinceeverythingisrecordandstoredintheregister.Itisquitedifficult
andtimeconsuming.Themajorproblemismodificationthatmustbereflectedinalltheentire
andsummariesalsoneededtobeupdate.
3.3PROPOSEDSYSTEM
Implementinganautomatedsystemformanagingreservationscanstreamlinethebooking
processforguest’sandreducemanualerrors.Developingauserfriendlyonlinebookingportal
canenhancecutomerexperienceandattractmoreguestbyallowingthemtobookrooms
andservicesconvenintely.Implementingacentralizeddatabasesystemcanfacilitateefficient
managementofguestinformation,reservations,billingandotheroperations.Recorded
maintainanceiseasybecauseallrecordsarestoredinspecificfile.Datacaneasily
secured,securityrestrictionscaneasilybeapplied.Errordetectioniseasy.
7

16. CHAPTER4
HARDWARE ANDSOFTWARE REQUIREMENTS
4.1HARDWARE REQUIREMENTS
OperatingSystem:Windows7orlater
Processor:IntelPentium4orlater
Memory:4GBminimum,8GBrecommended
Screenresolution:1280*1024orlarger
ApplicationWindowSize:1024*680orlarger
InternetConnection:Notrequired
CacheMemory:512KB
MicrosoftCompatible101ormoreKeyBoard
4.2SOFTWARE REQUIREMENTS
Client:OperatingSystem(Windows)
WebServer:ApacheWebServer
Language:PHP
Front-End:HTML,CSS,JAVASCRIPT,BOOTSTRAP
Back-end:MySQL
8

17. CHAPTER5
DESIGNPHASE
Designisthecreationofaplanorconventionfortheconstructionofanobjectorasystem(asin
architecturalblueprints,engineeringdrawings,businessprocesses,circuitdiagramsandsewing
patterns).Designhasdifferentconnotationsindifferentfields(seedesigndisciplinesbelow).Insome
cases,thedirectconstructionofanobject(asinpottery,engineering,management,codingandgraphic
design)isalsoconsideredtobedesign.Aspecificationofan
object,manifestedbyanagent,intendedtoaccomplishgoals,inaparticularenvironment,usingasetof
primitivecomponents,satisfyingasetofrequirements,subjecttoconstraints.Anotherdefinitionfordesign
isaroadmaporastrategicapproachforsomeonetoachieveauniqueexpectation.Itdefinesthe
specifications,plans,parameters,costs,activities,processesandhowandwhattodowithinlegal,political,
social,environmental,safetyandeconomicconstraintsinachievingthatobjective.Designingoften
necessitatesconsideringtheaesthetic,functional,economicandsocio-politicaldimensionsofboththe
designobjectanddesignprocess.Itmayinvolveconsiderableresearch,thought,modelling,interactive
adjustment,andre-design.
Meanwhile,diversekindsofobjectsmaybedesigned,includingclothing,graphicaluser
interfaces,skyscrapers,corporateidentities,businessprocessesandevenmethodsofdesigning.
9

18. HOTELMANAGEMENT SYSTEM
10 2023-2024DeptofCSE-CBIT-KOLAR
USECASEDIAGRAM
Usecasediagramsmodelbehaviorwithinasystemandhelpsthedevelopersunderstandofwhat
theuserrequire.Thestickmanrepresentswhat’scalledanactor.Usecasediagramcanbeuseful
forgettinganoverallviewofthesystemandclarifyingwhocandoandmoreimportantlywhatthey
can’tdo.Usecasediagramconsistsofusecasesandactorsandshowstheinteractionbetweenthe
usecaseandactors.Thepurposeistoshowtheinteractionsbetweentheusecaseandactor.To
representthesystemrequirementsfromuser’sperspective.Anactorcouldbetheend-userofthe
systemoranexternalsystem.
CHAPTER5
FIG:5.1USECASEDIAGRAM

19. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 2023-2024
11
CHAPTER5
5.2SCHEMADIAGRAM

20. 5.3ENTITYRELATIONSHIPDIAGRAM
ER-DIAGRAMDEFINITION
AnEntityrelationshipdescribesinter-relatedthingsofinterestinaspecificdomainof knowledge.An
ERmodeliscomposedofentitytypesandspecifiesrelationshipsthatcanexist betweeninstancesof
thoseentity types.InsoftwareengineeringanERmodeliscommonly formedtorepresentthingsthata
businessneedstorememberinordertoperformbusiness processes.Consequently,theERmodel
becomesanabstractdatamodelthatdefinesadataor informationstructurethatcanbeimplementedina
database,typicallyarelationdatabase.
FIG:5.2ENTITYRELATIONSHIP DIAGRAM
HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 12 2023-2024
CHAPTER5

21. 6.3LANGUAGE
PHPisageneral-purposescriptinglanguagegearedtowardswebdevelopment.Itwasoriginally
createdbyDanish-CanadianprogrammerRasmusLerdorfin1993andreleasedin1995.
ThePHPreferenceimplementationisnowproducedbythePHPGroup.PHPisaself-
referentiallyacronymforPHP:HypertextPreprocessor.Originalitsupposedlymeantpersonal
homepage.Itisanopensource,server-side,HTMLembeddedscriptinglanguageusedto
createdynamicWebpages.
CHAPTER6
IMPLEMENTATION
6.1 INTRODUCTION
Theimplementationistheprocessofassuringthattheinformationsystemoperationand
thenallowinguserstakeoveritsoperationsforuseandevaluation.Implementation
includesthefollowingactivities:
Obtainingandinstallingthesystemhardware
Providinguseraccesstothesystem.
Creatingandupdatingthedatabase
Trainingtheusersinthenewsystem.
advantagesofwindows11are:
Improvedperformance.
Enhancedsearchingcapabilities.
Locationawareprinting.
Virtualharddisksupport.
Expandedsecurity.
Getbettersecuritybuilt-in.
Hasslefreebackups.
Haveallofyourfilesinstantlyathand.
6.2PLATFORM
Windows11isthelatestmajorreleaseofMicrosoft'sWindowsNToperatingsystem,
releasedinOctober2021.Itisafreeupgradetoitspredecessor,Windows10(2015),
and isavailableforanyWindows10 devicesthatmeet the
newWindows11systemrequirementsareavailableforretailsaletoconsumers.The
13

22. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 2023-2414
CHAPTER6
LOGIN
CONTACT
PAYMENT
6.4TABLES
NEWSLETTERLOG

23. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 2023-2415
CHAPTER6
6.5IMPLEMENTATI ONOFCODE
<?php
include('db.php');?><!DOCTYPEhtml><htmllang="en"><head><title>SUNRISE
HOTEL</title><!--for-mobile-apps--><metaname="viewport"content="width=device-width,
initial-scale=1"><metahttp-equiv="Content-Type"content="text/html;charset=utf-8"/>
<metaname="keywords"content="ResortInnResponsive,
SmartphoneCompatibleweb
template,Samsung,LG,SonyEricsson,Motorolawebdesign"/>
<scripttype="application/x-javascript">addEventListener("load",function(){
setTimeout(hideURLbar,0);},false);
functionhideURLbar(){window.scrollTo(0,1);}</script>
<!--//for-mobile-apps-->
<link href="css/bootstrap.css"rel="stylesheet"type="text/css"media="all"/>
ROOM
ROOMBOOK

24. HOTELMANAGEMENT SYSTEM CHAPTER6
<linkhref="css/font-awesome.css"rel="stylesheet">
<linkrel="stylesheet"href="css/chocolat.css"type="text/css"media="screen">
<linkhref="css/easy-responsive-tabs.css"rel='stylesheet'type='text/css'/>
<linkrel="stylesheet"href="css/flexslider.css"type="text/css"media="screen"
property=""/>
<linkrel="stylesheet"href="css/jquery-ui.css"/>
<linkhref="css/style.css"rel="stylesheet"type="text/css"media="all"/>
<scripttype="text/javascript"src="js/modernizr-2.6.2.min.js"></script>
<!--fonts-->
<linkhref="//fonts.googleapis.com/css?family=Oswald:300,400,700"rel="stylesheet">
<linkhref="//fonts.googleapis.com/css?family=Federo"rel="stylesheet">
<linkhref="//fonts.googleapis.com/css?family=Lato:300,400,700,900"rel="stylesheet">
<!--//fonts-->
</head>
<body>
<!--header-->
<divclass="banner-top">
<divclass="social-bnr-agileits">
<ulclass="social-icons3">
<li><ahref="https://www.facebook.com/"class="fafa-facebookicon-
border facebook"></a>
<li><ahref="https://twitter.com/"class="fafa-twittericon-border
twitter"></a></li>
<li><ahref="https://plus.google.com/u/0/"class="fafa-google-plus icon-
bordergoogleplus"></a></li>
</ul>
</div>
<divclass="contact-bnr-w3-agile">
<ul>
<li><iclass="fafa-envelope"aria-hidden="true"></i><a
href="mailto:[email protected]">[email protected]</a></li>
<li><iclass="fafa-phone"aria-hidden="true"></i>[phone]</li>
<liclass="s-bar">
<divclass="search">
<inputclass="search_box"
DeptofCSE-CBIT-KOLAR 2023-2416

25. HOTELMANAGEMENT SYSTEM
type="checkbox"id="search_box">
DeptofCSE-CBIT-KOLAR 2023-2417
CHAPTER6
<labelclass="icon-search"for="search_box"><spanclass="glyphicon
glyphicon-search"aria-hidden="true"></span></label>
<divclass="search_form">
<formaction="#"method="post">
<inputtype="search"name="Search" placeholder=""
required=""/>
<inputtype="submit"value="Search">
</form>
</div>
</div>
</li>
</ul>
</div>
<divclass="clearfix"></div>
<divclass="w3_navigation">
<divclass="container">
<navclass="navbarnavbar-default">
<divclass="navbar-headernavbar-left">
<buttontype="button"class="navbar-toggle collapsed"
data-toggle="collapse"data-target="#bs-example-navbar-collapse-1">
<spanclass="sr-only">Togglenavigation</span>
<spanclass="icon-bar"></span>
<spanclass="icon-bar"></span>
<spanclass="icon-bar"></span>
</button>
<h1><aclass="navbar-brand"href="index.php">SUN
<span>RISE</span><pclass="logo_w3l_agile_caption">Your DreamyResort</p></a></h1>
</div>
<!--Collectthenavlinks,forms,andothercontentfortoggling-->
<divclass="collapsenavbar-collapsenavbar-right"id="bs-example-navbar-collapse-1">
<nav class="menumenu--iris">
<ulclass="navnavbar-navmenulist">
<liclass="menuitemmenuitem--current"><ahref=""class>

26. HOTELMANAGEMENT SYSTEM CHAPTER6
<li class="menuitem"><ahref="#about"class="menulink
scroll">About</a></li>
<li class="menuitem"><ahref="#team" class="menulink
scroll">Team</a></li>
<liclass="menuitem"><ahref="#gallery"class="menulink
scroll">Gallery</a></li>
<liclass="menuitem"><ahref="#rooms"class="menulink
scroll">Rooms</a></li>
<liclass="menuitem"><ahref="#contact"class="menulink scroll">Contact
Us</a></li>
</ul>
</nav>
</div>
</nav>
<!--//Modal1-->
<divid="availability-agileits">
<divclass="col-md-12book-form-left-w3layouts">
<ahref="admin/reservation.php"><h2>ROOMRESERVATION</h2></a>
</div>
<divclass="clearfix"></div>
</div>
!--//team -->
<!--Gallery-->
<sectionclass="portfolio-w3ls"id="gallery">
<h3class="title-w3-agileitstitle-black-wthree">OurGallery</h3>
<divclass="col-md-3gallery-gridgallery1">
<ahref="images/g1.jpg"class="swipebox"><img
src="images/g1.jpg"class="img-responsive"alt="/">
<divclass="textbox">
<h4>SUN RISE</h4>
<p><iclass="fafa-picture-o"aria-
hidden="true"></i></p>
</div>
DeptofCSE-CBIT-KOLAR 18 2023-24

27. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 19 2023-24
INSERTINTO`login`(`id`,`usname`,`pass`)VALUES (1,
'Admin','1234'),
(2,'Prasath','12345');
CREATETABLEIFNOTEXISTS`login`(
`id`int(10)unsignedNOTNULL,
`usname`varchar(30)DEFAULTNULL,
`pass`varchar(30)DEFAULTNULL
)ENGINE=InnoDBDEFAULTCHARSET=latin1AUTO_INCREMENT=3
;
6.6SQLQUERIES
SETSQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SETtime_zone="+00:00";
CREATETABLE IF NOTEXISTS`contact`(
`id`int(10)unsignedNOTNULL,
`fullname`varchar(100)DEFAULTNULL,
`phoneno`int(10)DEFAULTNULL,
`email`text,
`cdate`dateDEFAULTNULL,
`approval`varchar(12)DEFAULTNULL
)ENGINE=InnoDBDEFAULTCHARSET=latin1AUTO_INCREMENT=1
;
CREATETABLEIFNOTEXISTS`newsletterlog`(
`id`int(10)unsignedNOTNULL,
`title`varchar(52)DEFAULTNULL,
`subject`varchar(100)DEFAULTNULL,
`news`text
)ENGINE=InnoDBDEFAULTCHARSET=latin1AUTO_INCREMENT=1
;
CHAPTER6

28. HOTELMANAGEMENT SYSTEM
CREATETABLEIFNOTEXISTS`payment`(
`id`int(11)DEFAULTNULL,
`title`varchar(5)DEFAULTNULL,
`fname`varchar(30)DEFAULTNULL,
`lname`varchar(30)DEFAULTNULL,
`troom`varchar(30)DEFAULTNULL,
`tbed`varchar(30)DEFAULTNULL,
`nroom`int(11)DEFAULTNULL,
`cin`dateDEFAULTNULL,
`cout`dateDEFAULTNULL,
`ttot`double(8,2)DEFAULTNULL,
`fintot`double(8,2)DEFAULTNULL,
`mepr`double(8,2)DEFAULTNULL,
`meal`varchar(30)DEFAULTNULL,
`btot`double(8,2)DEFAULTNULL,
`noofdays`int(11)DEFAULTNULL
)ENGINE=InnoDBDEFAULTCHARSET=latin1;
DeptofCSE-CBIT-KOLAR 20 2023-24
CREATETABLEIFNOTEXISTS`room`(
`id` int(10)unsignedNOTNULL,
`type`varchar(15)DEFAULTNULL,
`bedding`varchar(10)DEFAULTNULL,
`place` varchar(10)DEFAULTNULL,
`cusid`int(11)DEFAULTNULL
)ENGINE=InnoDBDEFAULTCHARSET=latin1AUTO_INCREMENT=16 ;
INSERTINTO`room`(`id`,`type`,`bedding`,`place`,`cusid`)VALUES
(1,'SuperiorRoom','Single','Free',NULL),
(2,'SuperiorRoom','Double','Free',NULL),
(3,'SuperiorRoom','Triple','Free',NULL),
CHAPTER6

29. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 21 2023-24
(4,'SingleRoom','Quad','Free',NULL),
(5,'SuperiorRoom','Quad','Free',NULL),
(6,'DeluxeRoom','Single','Free',NULL),
(7, 'DeluxeRoom','Double','Free',NULL),
(8,'DeluxeRoom','Triple','Free',NULL),
(9,'DeluxeRoom','Quad','Free',NULL),
(10,'GuestHouse','Single','Free',NULL),
(11,'GuestHouse','Double','Free',NULL),
(12,'GuestHouse','Quad','Free',NULL),
(13,'SingleRoom','Single','Free',NULL),
(14,'SingleRoom','Double','Free',NULL),
(15,'SingleRoom','Triple','Free',NULL);
CREATETABLEIFNOTEXISTS`roombook`(
`id`int(10)unsignedNOTNULL,
`Title`varchar(5)DEFAULTNULL,
`FName`text,
`LName`text,
`Email`varchar(50)DEFAULTNULL,
`National`varchar(30)DEFAULTNULL,
`Country`varchar(30)DEFAULTNULL,
`Phone`text,
`TRoom`varchar(20)DEFAULTNULL,
`Bed`varchar(10)DEFAULTNULL,
`NRoom`varchar(2)DEFAULTNULL,
`Meal`varchar(15)DEFAULTNULL,
`cin`dateDEFAULTNULL,
`cout` dateDEFAULTNULL,
`stat`varchar(15)DEFAULTNULL,
CHAPTER6

30. `nodays`int(11)DEFAULTNULL
)ENGINE=InnoDBDEFAULTCHARSET=latin1AUTO_INCREMENT=2
;
ALTERTABLE`contact`
ADDPRIMARYKEY(`id`);
DeptofCSE-CBIT-KOLAR 22 2023-24
ALTERTABLE`login`
ADDPRIMARYKEY(`id`);
ALTERTABLE`newsletterlog`
ADDPRIMARYKEY(`id`);
ALTERTABLE`room`
ADDPRIMARYKEY(`id`);
ALTERTABLE`roombook`
ADDPRIMARYKEY(`id`);
ALTERTABLE`contact`
MODIFY`id`int(10)unsignedNOTNULLAUTO_INCREMENT;
ALTERTABLE`newsletterlog`
MODIFY`id`int(10)unsignedNOTNULLAUTO_INCREMENT;
HOTELMANAGEMENT SYSTEM
ALTERTABLE`login`
MODIFY`id`int(10)unsignedNOTNULLAUTO_INCREMENT,AUTO_INCREMENT=3;
ALTERTABLE`room`
MODIFY`id`int(10)unsignedNOTNULLAUTO_INCREMENT,AUTO_INCREMENT=16;
CHAPTER6

31. CHAPTER7
CONCLUSION ANDFUTUREENHANCEMENT
1.CONCLUSION
Bycentralizingcrime-relateddataintoasingledatabase, thesystemeliminates data
silosandenablesseamlessaccesstoinformationacrossdifferent departmentsandunits
withinlawenforcementagencies.
Thesystemallowsfortheefficientstorageandorganizationofvarioustypesofcrime
data,includingincidentreports,suspectinformation,witnessstatements,andcase
details,therebyfacilitatingeffectivedatamanagementpractices.
Throughuser-friendlyinterfacesandintuitivequerymechanisms,authorized personnel
caneasilyaccessrelevantcrimedatabasedontheirspecificneeds, therebyenabling
timelydecision-makingand investigativeprocesses.
Thesystemsupportsadvanceddataanalysistechniques,suchasdataminingand statistical
analysis,toidentifypatterns,trends,andcorrelationswithinthecrimedata.
Robustsecurity measuresareimplementedtosafeguardsensitivecrimedataandensure
compliancewithprivacyregulationsandpolicies.
Accesscontrolsandencryptiontechniquesareemployedtopreventunauthorized access
andmaintaindataintegrity.
2.FUTUREENHANCEMENT
IntegrationofArtificialIntelligence(AI)andMachineLearning(ML)
Real-timeDataAnalysisandAlerts
MobileApplicationSupport
GeospatialAnalysisandMapping
DataSharingandInteroperability
EnhancedSecurityMeasures
UserTraining andSuppor
23

32. REFERENCES
FORXAMPP:
https://www.apachefriends.org/download.html[2]Wangkhem.K&Joshi.KIOTFOR
HEALTHCAREANDITSCHALLENGES
InternationalEducationalJournalofScienceandEngineering(IEJSE)–Volume,1.
[3]Kaur,J.S.Ganjoo, P.Vaqur,M.,&Joshi.K.AReview:ImageFusionusingDCTand
DWT.
7In0t7e.rn[4a]tionalJournalofScientific&EngineeringResearch(IJSER)-Volume,10,702-Joshi,
K.,Kashyap,D.,Bisht.B,&Bagwari.A.GPSbasedLocationTracker:A
Review.
EInntgeirnneaetrioinngalJournalofAdvancedResearchinComputerandCommunication
(IJARCCE)-Volume,8.
[5]Joshi.K.N,Diwakar.M.ImageFusionusingCrossBilateralFilterandWavelet
Transform
Domain.InternationalJournalofEngineeringandAdvancedTechnology(IJEAT)-
Volume,8,
110-115.[6] Kumar,R.,Singh,G.,Joshi,K. EmotionRecognitionSystemusingLocal
Binary
Pattern.InternationalJournalofInventiveEngineeringandSciences(IJIES)-
AWBEBBRREEFVEIRAETNICOESN:S
1.https://www.wikipedia.org
ER:EntityRelationship
2.https://studocu.com.
SR:SoftwareRequirements
3.www.sourcecodeandproject.
SQL:StructuredQuery Language
DBMS:DatabaseManagementSystem
PHP:HypertextPre-processor
CSS:Cascadingstylesheets
HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 24 2023-24
CHAPTER7

33. SNAPSHOTS
S.1HOMEPAGE
S.2LOGINPAGE
HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 25 2023-24
SNAPSHORTS

34. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 26 2023-24
SNAPSHOTS
S.3USERDASHBOARD
S.4RESERVATIONDETAILS

35. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 27 2023-24
SNAPSHOTS
S.6CONTACTUS
S.5 ADMINSTATUS

36. HOTELMANAGEMENT SYSTEM
DeptofCSE-CBIT-KOLAR 28 2023-24
SNAPSHOTS
S.7PAYMENTDETAILS