The Hotel Reservation System

The Hotel Reservation formation copThe Riviera fixing is a touring car revive. It is located in Greenwich, in the s verbotenheast east London of coupled Kingdom. This renovate was established in 2000.This resort has 38 dwell with each the facilities. in that location argon double, single and family consider ons with attached bath elbow modes. at that place argon indoor and forbidd abrogateoor games facilities with a swimming pool. Air-conditi integrityd rooms also be avail adequate to(p). Within a hold of a few yards the satisfying maritime mountain is attractive for the phaeton for enjoyment.As Hotel Riviera a customer based Comp either it is identified that providing an make up-effective customer service is a major(ip)(ip) factor that is considered in e genuinely customer based Companies, to remain competitive in the market. bingle major metrerier to this is the manual(a)(a) scheme does not result whatever adroitness for the Managers, Accountants a nd other employees to trace the routine expand on time and provide a quality of service. Which ultimately lead to a lot of problems and inefficiencies?In the aim of solving these problems and making the order interlock efficiently, the Hotel Reservation dust with online Environment to Hotel Riviera musical arrangement project was lowtaken. In here this arranging was beef up in web base meekness path as well as with a optic Basic comp angiotensin-converting enzyment that was used to track the qualifications with by the Employees each day. In this governing body the Administrators lead the chance to view their routine head as well as the qualification flesh out at the company. So the spoil byrs sight get a good predilection what sort of things they get under ones skin to do in array to improve their assembly line activitiesThe benefits of the dodge atomic number 18 numerous. The constitution bequeath help the company to operate efficiently by eliminating all the time consuming functionings and provide a expose service to their nodes.IntroductionHotel Riviera InformationThe Riviera resort is a tourist resort. It is located in Greenwich, in the south east London of United Kingdom. This resort was established in 2000.This resort has 38 rooms with all the facilities. There be double, single and family rooms with attached bathrooms. There are indoor and outdoor games facilities with a swimming pool. Air-conditioned rooms too are available. Within a distance of a few yards the real maritime view is attractive for the tourist for enjoyment.To maintain the resort thither are swear outing thirty employees as Managers, Accountant, Supervisors, Cashier, agency boys, Servants, Cleaners, and Cookers. E preciseday immaterial and local nodes visit and enjoy with the resort facilities. The resort owner is truly happy approximately the success of his resort.way Information20- A/C and 18 Non A/C rooms.12-Rooms with single bed facility A/C , 8 non A/C single bed rooms10-Rooms are the double bed A/C and 8-double bed non A/C. caper IdentifiedOut of survey done by me, I effect the numerous problems faced by the Owner and other employees of the company. The main drawback of their soon available formation is that for many affectes are actually time consuming. So the company required a placement that give produce out puts in on time. besides the time that takes to s leftover services to customers are quite in noble spirits. Next the company does not have an easy sort to trace the second-stringer swear out.Introduction of the Current Information carcassThe spa is one of the famous resorts in United Kingdom which is currently doing everything in a manual way. Although if they have a government issue of computers even they dont have any computerized system. Their lymph gland and staff are facing lots of problems in their day today activities. So I proposed them to carry out their resort employment system ex pand in a computerized manner.These are the major functions/ cultivatees occurring which is manual way. leaf node registrationRoom modestyFood order payment calculationsFunctions of the Existing brassHotel has four split1. Front officeThis department contains 2 employees Receptionist and Front Office Manager. of import functions1. Request mental reservation instruction2. Confirm schedule.3. Cancel booking.2. Kitchen department.This department contains 15 employees Chief cook, Cooks, Supervisor, and Supplier for groceries chief(prenominal) functionsPrepare meals according to the lymph node preference.2. Prepare food menu entropy.3. maintain department.This department contains 8 employees House keeper, Record keeper Supervisor and Cleaners. chief(prenominal) function1. Check the room approachability information and pass to the cause office.2. Reservation of room.4. Finance department.These departments contain 5 employees Accountant, Manager, Finance Manager, Account operat orsMain Functions1. gauge Guest payments.2. Prepare invoices.3. Salary functions.4. Profit and loss outline.Purposes and Objectives of This haveThe proposed computerized system purposes and objectives are as follows.With the earlier system the customers had to idle coin bank the receptionist filled all entropy. only, with the proposed system the customer related activities go forth be very quick and efficient.Less waste of resources, because except necessary info pass on be taken into HardCopy out puts.In the manual system entropy duplication was happening frequently. But, with the proposed system information redundancy will be reduced to a great extent. earnest measures will be introduced therefore information is 99% accurate and reliable.The company bunghole convert into sensitive trends of technology and give a give out competition with its competitors.The company profitability sewer be increased because the cost that was incurred for maintaining the system will b e cut down.Work load of the employee is lift off.The proposed system requires only a computer therefore there is no film of big room space. There is no need of grown storage cupboards because all data will be stored in one single database of the computer.The manual system did not have any back-up bills, tho with the computerized if any files have been missed up there is a back-up procedure to fix the problem.Issues of the Existing SystemThe data is not long-wearing for this hotel delinquent to the im comely system-The resort backlog System is maintaining their data and information in the files and well-nigh copies. So it is not secure for them. non only that further it can destroy in a particular period. It can be mis position somewhere. They have to buy the files and copies. So it is not proper system for them.It is time consuming -Very significant but this manual system is very slow and extremely time consuming. So that lymph gland time also wasting. When frequentl y than one lymph gland arrives in to the resort for booking, Receptionist affectation manage with the short time. The breaching go is very difficult in the guest departure time because, they cant easily find compulsory records in this manual system.The stationery costs are high -There is a lot of accountwork to be done and lots of records of guest, cash books, room detail, availability flesh out etc. that have to be well-kept, which makes it a very conf utilise job. Due to the large meter of paperwork that needs to be unplowed for later reference, there is also need for large storage space. not only should there be space to store all the records but it should be stored in easy way to find the records and very high cost.It occupies lot of space to locate the file and difficult to search collectable to the opposite locations -Currently, a large number of past and present guest and recruitment related information are stored in cabinets and racks. This way, files get detritu s collected and confidential papers get loose from the files with time.To maintain the paper in order, filing cabinets, nonmoving and employee is needed which comes with a cost. Some of these cabinets are kept inside the office congesting working areas and the others are kept in store rooms accruing valuable floor space.Calculation Process -Also, the reckon knead is very difficult such as customer channelise calculation (food, Room, facility charges), the resort ratio checking. In the manual system for every answer there should be needed to a greater extent workers. non only cant they work accurately and in the correct.System instruction MethodologyI have selected the Water fall method exemplification for exposeing a system for Riviera resort military reserve because these models demand a systematic and sequential approach to software increase.It presents a highly structured method of software ontogenesis that starts at the system levels and progress.I am going to de velop a resort reservation system which is more complex. This can be custodyd by employ this methodology. And this model decreases the gaps between substance ab exploiters and system developers and to increasing systems performance.Waterfall ModelThis is the most common and classic of livelihood cycle models, also referred to as a linear-sequential smell cycle model. It is very simple to understand and use. In a falls model, each soma must be completed in its entirety before the bordering phase can begin. At the end of each phase, a review article takes place to determine if the project is on the right path and whether or not to continue or dis circuit board the project. Unlike what I mentioned in the general model, phases do not overlap in a waterfall model.Waterfall Life Cycle take in 1.1Reasons for selecting waterfall methodology for Hotel Riviera whole kit and caboodle well for smaller projects where necessitys are very well understood.Easy to manage due to the rigidity of the model each phase has specific deliverables and a review process.Good progress tracking due to clear development stagesPhases are processed and completed one at a time.It is suited for real time and critical systemSuitable for small and large size projects.Simple and easy to use.System RequirementsFunctional RequirementTo develop a amply tested Guest up era, Room update process, it is asked that the act should allow the user to add, edit find elaborate and handle payments. To acquire this, it is required to create Access VB (Visual Basic) forms. It necessary to maintain reservation file, guest file, order dilate files payment file including registration fee in the database. So it is asked to design the necessary interfaces using VB to reach the to a higher place extremity.To fulfill the above requirements I have created a fully tested reservation system from the knowledge that I have on VB Access. I fictitious that resort reservation system need to computerize t he reservation process and I have directed my efforts and created a program which is coming out here.Front endWelcome ScreenWelcome screen with user verification facility. This screen will allow the user to type user name and password. This user name will be common for governing members and another username and password for Manager.Registration of new usersThis system should allow registering new users from this organization.Adding elaborate to databaseWhen a Guest comes to register, the system will be added his inside information to database. Such as name, address, designation, passport number, age, sex and nationality etc.CalculationsCalculations in the system will be found out the due amount. The due amount will be calculated from the requirement the reservation form.Rooms detailsinside information of rooms can be found in their database. And the system should be able to record their information. The system should assign unique number for each room and allow the user to enter d etails such as room number, room type, rate and status etc. junketeer detailsBanquet reservation also is another function of this resort. So details of feast can be found in this system. Also the system should be able to record their information. Such as ranch no, location and charges.Engineering detailsWhen customers reserve a hall for a function, they can be found what are the engineering facilities available in this resort for doing that function. Such as Sound system, Overhead Projector and Desktop computer.Foods detailsDetails of foods also can be found in this system with charges to customers to decide their favorite foods. Such as Egg w/ rice, Spaghetti, whiner Salad, Coke (Medium) and Fried chicken w/ rice etc. pot likker detailsHotel Riviera has a big bar for their customers. So liquor details are very important for this system. Mainly it should be included explanation of liquor, price and expiry date.Details of poolsThere are two types of pools available. One is adult pool and another one is child pool. Details of pools are most essential for this system.Order detailsWhen purchase orders are do by customers or guests, presently all of them are filed and placed into drawers. But it will be great if the hotel can save those details in the system and be able to retrieve them later if required. Order details will be included ordering meals, and ordering liquor.Room reservationThis requirement is the hearth of this entire system. It is for the purpose of fulfilling requirement that most of the above requirements are met. Fulfilling this requirement will be the key solution in the system to be developed. Once this requirement is sure-firely tackled, the older access registry room will become obsolete.This system should be able to record details of room reservation number, guest ID, room number, reservation date, date reserved, length of stay, and status.Banquet reservationThis requirement also a very important function of this system. This resort is doing not only the room reservation but also the banquet reservation for their customers. This part should be included banquet reservation no, reservation date, client name, address, contact no, date reserved, starting time, finishing time and status.SearchThe ultimate purpose of any database system its operableity to support retrieval of data in a way it is expected. This is the case here also. If any reservations details are required, the system will be allowed to find the details from related database and make reservation using search function.Printing facilitiesStaff should be provided full functionality to printing relevant documents when they needed.ReportsIn this computerized system, identifys will also be a part and dowery they are the means that help get printed outputs here. Staffs should be allowed to run reports and get prints.Common functionality requirementsThe system will be having a Multiple account Interface (MDI) through which all the screens and reports can be reached.Colors to be used in the screen should be consistent. Blue with black will be interesting to see. Also buttons on window should be placed in the top of the screen.One window should be used for generating reports i.e. the user should be able to run reports one by one indoors one window. It can be by clicking on a button, using menus or shortcuts keys.Calendar with one month displayed whenever there is a need for entering dates, the user should be given facility to pick it from a calendar.Short cut keys should be assigned to expedite the data entry work.There user should be allowed to backup the database to a certain location. This hold ensures the safety of updated data.Printer will be connected to one PC and others will share the printer.Non-Functional RequirementsAlthough these requirements are not directly with the system to be developed, they are very important factors to take into consideration for the development and successful implementation of the system. Under thi s section I identify non functional requirement within the projects scope.Product RequirementUsability and EfficiencySince the earlier version of Visual underlying (6.0) is going to be used, performance will be high and it is very fast. The system should be very much easy to handle. reliabilityUser should easily understand about the system. And they will find it very much handy.PortabilityDatabase should be maintained with much care and give the database to that system in correct format.Operational RequirementSecurity database access should be prevented from sight. In addition it should be impossible to access certain parts of the system without the proper logon procedure. This requirement should be strictly enforced at the log on single window or feature under this section.User Friendliness The system should not be possible for a non- authoritative user to enter a single window or feature under this section.Interoperability No other system could be intercepted small-arm this sys tem is running on the machine.Software Requirement for ImplementationFor the development of the new system, the spare-time activity software packages are recommended to be used.Microsoft Visual elemental (6.0) for the interfaces program coding. Visual basic data project will be used for the creation of this system. Is the data Environment, Data list control, Data jazz band Control, Data grid control, Microsoft- Calendar control and Date time selector switch control, etc.Microsoft Access 2003 as database back end. crystal Reports 8.5 for the creation of reports. totally the reports will be called within Visual Basic using the Crystal Viewer ActiveX control.Software Tools are Needed to Developed the New SystemMicrosoft Visual Basic 6.0Microsoft Word 2007Microsoft Visio 2003Microsoft AccessAdobe Photoshop CS hardware Requirement for New SystemThe reservation system to computerize their reservation system, a computer system needed the following minimum requirements. central proces sor 400 MHzRAM 128 MBHard Disk 4 GBVGA 32 MBMonitor 14Operating System Windows 2000/xpSoftware Microsoft Office 2000/xpFloppy Disk Drive 1.44 MB 3.5 abridgmentThis chapter provided a detailed description on why Hotel Riviera Needs a web and Visual Basic based System and how online room reservation and computerized reservation System solved the problems they are currently facing with the requirement analysis. Next section gives a detailed description about the system.System AnalysisIntroductionThe tools of a system analysis, which are known as fact-finding methods, are found in the scope of the business occupation and its end users. Therefore these methods and techniques should be applied efficiently for finer and better results. There are many reasons for fact finding during systems development life cycle, but the most important time is when its system development has begun its basic stages.During the beginning stage the analyst must do the current system, which is univer se currently used. During these stages, the analyst must gather information on the requirements of the end user. Then when the system designing gets on the way, the analyst must gather, the following-Facts about report formats. stimulus methods.Information about the organization.Goals and aims of the organization.Organization structure.Objectives and reasons of functional units.Information about the people.Authority and responsibility of relationship.Job duties.Information about the work.Tasks and work hangs.Methods and ways for performing the work.Work times and limits.Information about the work environment.Resources available.Proposed System DescriptionsThe scope of my project is only reservation. So, Room, facility, needed food booking is will be included in this project. The processes will be started from check in and finished with the check out. Between, these two actions there are some processes available. Those are selecting the complimentsed room with facilities and food, a dvance payment store the guest details, reservation details, charge calculation, payment settlement and report creation. Sometime there maybe cancellation process includes.In this system there will be receptionist, guest, cashier and supervisor involved. The receptionist will operate some the booking process of this application. The guest will select his needed suitable. Cashier will handle all calculation and payment processes. The supervisor will create the reports to the guidance. The detail information about this computerized Resort Reservation system is included in the DFD ER diagram.In this system my aims is to make the resort reservation System. This is fully secure and fully computerizedFeatures of the New System handling Customer DetailsRoom reservationsBanquet reservationsBackup facilitiesStores data permanentlySecurityCancellationsHandling Rooms DetailsMaking allowancesFeatures like Update, Searching, Deleting, Editing Record etcGenerating different kinds of report.Ad ded Solution to Implement the New SystemThe Data is not long-lasting due to the proper system rase if it is an important data which is been kept in a file, which is not secured, It can be misplaced somewhere. Not only will that it destroy in a particular period. So computerizing the manual system it will be stored in the Database to the computer, so which is more secured. And also we can take the Backup for safety.It is time consumingWhen the data is in a document, which is inside a file, it is very hard to get the necessary details in that particular time. To search the file it will take some time because they have to see the file knave by page. After computerizing the manual system it will be much easier to retrieve the data quickly, this will increase the productivity of Resort reservation system.The stationary costs are very highWhen the data is maintained in a file or any kind of documents the stationary cost like pen, papers, ruler and files. Deleting, updating and editing al so will affect the stationary cost. So after computerizing the manual system we can bring down the cost of stationary, which will economy.If a particular file is lost then the whole data will be loosedIf a file is lost then every data regarding that resort information will be loosed which is a big blow for the Resort reservation system. It can happen very easily in this Resort. So we can protect the data by implementing this system. Because we can store the data in a particular database which is more secure. No one can distinguish any record file because they will have their own login. Without erudite password no one can enter in to the computer. Even they have a back up system.It is not possible to get the necessary Data with in a given timeAs the data is maintained in a file as manual it is impossible to get the data in a given period. If they want to get particular data then they have to seek one by one page. After computerizing all the data it can be retrieved quickly with the help of Query. So it is making easy to workCalculate the payment veryAlso, the calculating process is very difficult such as Guest charge calculation (food, Room, facility charges), the resort balance checking. In the manual system for every process there should be needed more workers. Not only cant they work accurately and in the correct time. After that computerizing make easy to workChecking processWhen more than one guest arrives in to the resort for booking receptionist cant manage with the sort time. The checking process is very difficult in the Guest departure time because, they cant easily find the needed records in this manual system Check Room or banquet availability .after that computerizing easily identifies the room or banquet availabilitySummaryThis chapter presented information about the tools of a system analysis, which are known as fact-finding methods, are found in the scope of the business application and its end users and feasibility study about this entire syst em whether which is accepted or not. Also discussed regard features of this system and value added solution for their earlier systems issues.System Design CriteriaIntroductionIn this part, I have discussed why it is important to have a design method when developing systems. describe and explain some strategies for generating design solutions, simplifying design decisions, evaluating designs, and terminating the search for alternatives, the purpose of design models and the corpus categories of design models and summarized some differing perspectives on the nature of designData attend plot (DFD)Data Flow diagrams are a network mental representation of a system. They are the corn store for structured system analysis and design. The diagrams use four symbols to represent any system at any level of details the four entities that must be represented areData flows movement of data in the systemData stores data repositories for data that is not movingProcesses transforms of incoming d ata flows to outgoing data flowsExternal entities sources or destinations outside the specified system boundaryThe DFD shows how, through analyzing data flows, a systems internal processes interact with each other, how the system interfaces with its environment, how the system is partitioned into interacting sub-systems, how an existing or a proposed system can be depict in a top-down manner.Existing system data flow diagram 0th levelFigure 3.10th level Data Flow DiagramFigure 3.21st Level Data Flow DiagramFigure 3.32nd level Data Flow Diagram for Payment process2nd level Data Flow diagram for report timesFigure 3.5Data dictionary for proposed Hotel reservation systemData storesNameDescriptionNumberOwnerCustomer detailsStore the Customer details1AdministrationPayment detailsStore the Payment details2AdministrationRoom detailsStore the Room details4AdministrationBanquet detailsStore the banquet details5AdministrationBar detailsStore the bar details3AdministrationPool detailsStore t he pool details6AdministrationRestaurant detailsStore the eating house details7Administration turn off3.6External entityNameDescription typefaceTotal occurrenceGuestDescribe the customer who are booking the room and banquetPerson1ManagementDescribe the management of HotelDepartment1 gameboard 3.7Data processesNameDescriptionInput fromOutput intoLogic summaryAdministration processCheck the room and banquet order.guesthotelWhen the guests come to the hotel, the administrator section receive the booking order then check whether the room are available or not, after that, reserve it for the particular guest.Payment processProvide the card to the managementguestguestCollect the money from the guest, when they leave from the hotel.Room processHandle the room details.guestguest turn back the room details, bed details and other equipments details.Check the room, if there is anything damage, collect the details, and need from the room and replace it another.Banquet processHandle the banquet detailsKeep the banquet details, standard equipment details and additional equipment details.Bar processHandle the bar detailsKeep the bar details, such as drinks items, chips items. If it is finish, order them.Pool processHandle the pool detailsKeep the pool detailsRestaurant processHandle the eating house detailsKeep the food itemsReport generationHandle all the reportAll the detailsReport generationKeep whole hotel details and when the tribunal ask the report, get the print out and give it to them.Table 3.8Data flowNameDescriptionSourceDestinationguest details appoint the guest detailsGuestadministration processpayment details show the payment detailsGuestPayment processroom detailsRepresent the room detailsGuestRoom processbar detailsRepresent the bar detailsbar processadministration processbanquet detailsRepresent the banquet detailsbanquet processadministration processpool detailsRepresent the pool detailspool processadministration processRestaurant detailsRepresent the res taurant detailsrestaurant processadministration processCheck restaurant detailsRepresent the checking restaurant detailsRestaurant processadministration processTable 3.9Entity Relationship Diagram (ERD)Normalized ERD for the proposed systemFigure 3.10Relational Table calibrationNormalization is the process of efficiently organizing data in a database. There are two goals of the normalization process eliminating redundant data (for example, storing the alike data in more than one table) and en