The Hotel Reservation System

The Hotel Reservation clayAbstractThe Riviera go back is a tourist resort. It is located in Greenwich, in the south east capital of the United Kingdom of United Kingdom. This resort was established in 2000.This resort has 38 populate with whole the facilities. There be double, undivided and family rooms with attached bathrooms. There atomic number 18 indoor and outdoor games facilities with a swimming pussycat. Air-conditioned rooms excessively ar available. Within a distance of a few yards the real oceanic view is attractive for the tourist for enjoyment.As Hotel Riviera a customer based Comp either it is identified that providing an efficient customer service is a major instrument that is considered in all customer based Companies, to remain competitive in the market. One major exceptrier to this is the manual dodging does not provide whatever forwardness for the Managers, taleants and other employees to trace the routine inside information on m and provide a qu ality of service. Which ultimately lead to a lot of problems and inefficiencies?In the aim of solving these problems and do the comp any(prenominal)(prenominal) ope prescribe efficiently, the Hotel Reservation outline with online Environment to Hotel Riviera arranging project was undertaken. In here this system was strengthen in web base glide slope as well as with a Visual Basic component that was used to track the reservations through by the Employees separately day. In this system the Administrators take out the chance to view their routine expatiate as well as the reservation flesh out at the company. So the managers preempt get a good idea what sort of things they name to do in order to improve their business activitiesThe benefits of the system are numerous. The system get out help the company to operate efficiently by eliminating all the clock time consuming procedures and provide a better service to their Customers.IntroductionHotel Riviera InformationThe Rivier a 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 are 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 there are take a shiting thirty employees as Managers, Accountant, Supervisors, Cashier, board boys, Servants, Cleaners, and Cookers. E realday foreign and local guests visit and enjoy with the resort facilities. The resort owner is very happy near the success of his resort.Room 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.Problem IdentifiedOut of survey done by me, I plant the numerou s problems faced by the Owner and other employees of the company. The main drawback of their currently available system is that for many surgical processes are very time consuming. So the company required a system that get out produce out puts in on time. Also the time that takes to send serve to customers are quite racy. Next the company does not have an easy way to trace the reservation process.Introduction of the Current Information SystemThe employ is one of the famous resorts in United Kingdom which is currently doing everything in a manual way. Although if they have a number of computers even they dont have any computerized system. Their Guest and staff are facing piles of problems in their day today activities. So I proposed them to carry out their resort reservation system enlarge in a computerized manner.These are the major functions/processes occurring which is manual way.Guest registrationRoom reservationFood orderPayment calculationsFunctions of the Existing Syste mHotel has four departments1. Front business officeThis department contains 2 employees Receptionist and Front Office Manager.Main functions1. Request booking information2. Confirm booking.3. Cancel booking.2. Kitchen department.This department contains 15 employees Chief cook, Cooks, Supervisor, and Supplier for groceriesMain functionsPrepare meals according to the guest preference.2. Prepare food menu information.3. Housekeeping department.This department contains 8 employees House flight attendant, Record keeper Supervisor and Cleaners.Main function1. Check the room availability information and pass to the front office.2. Reservation of room.4. Finance department.These departments contain 5 employees Accountant, Manager, Finance Manager, Account operatorsMain Functions1. Calculate Guest earningss.2. Prepare invoices.3. Salary functions.4. Profit and loss analysis.Purposes and Objectives of This ProjectThe proposed computerized system means and objectives are as follows.With t he earlier system the customers had to idle work on the receptionist filled all information. But, with the proposed system the customer related activities lead be very quick and efficient.Less waste of resources, because only necessary entropy depart be taken into HardCopy out puts.In the manual system entropy duplication was happening frequently. But, with the proposed system data redundancy march on be reduced to a great extent.Security measures impart be introduced therefore data is 99% accurate and reliable.The company merchantman convert into modern trends of technology and give aBetter competition with its competitors.The company profitability notify be increased because the cost that was incurred for maintaining the system will be sawed-off down.Work load of the employee is lifted off.The proposed system requires only a computer therefore there is no need of large room space. There is no need of large storage cupboards because all data will be blood lined in one single database of the computer.The manual system did not have any back-up files, unless 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-lasting for this hotel collectible to the improper system-The resort reservation System is maintaining their data and information in the files and some copies. So it is not secure for them. Not only that only it can destroy in a particular period. It can be misplaced somewhere. They have to buy the files and copies. So it is not proper system for them.It is time consuming -Very important only if this manual system is very slow and extremely time consuming. So that guest time too wasting. When to a greater extent than one guest arrives in to the resort for booking, Receptionist bank manage with the short time. The checking process is very difficult in the guest departure time because, they flip easily find requisite record books in this manual system.The stationery be are high -There is a lot of paperwork to be done and lots of records of guest, cash books, room inside information, availability details etc. that have to be kept up(p), which makes it a very confusing job. Due to the large amount of paperwork that needs to be kept for ulterior reference, there is also need for large storage space. Not only should there be space to store all the records except 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 due to the diverse locations -Currently, a large number of past and present guest and recruitment related information are stored in cabinets and racks. This way, files get dust collected and hush-hush papers get loose from the files with time.To maintain the paper in order, filing cabinets, stationary and employee is needed which comes with a cost. Some of these cabinets are kept inside the office congesting working ar eas and the others are kept in store rooms accruing valuable floor space.Calculation Process -Also, the calculating process is very difficult such as customer 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.System Development MethodologyI have selected the Water fall regularity model for developing a system for Riviera resort reservation because these models demand a systematic and sequential approach to software training.It presents a highly coordinate method of software development that starts at the system levels and progress.I am going to develop a resort reservation system which is more complex. This can be handled by using this methodology. And this model decreases the gaps between exploiters and system developers and to increasing systems performance.Waterfall ModelThis is the nearly common and classic of life cycle models, also referred to as a linear-sequential life cycle model. It is very simple to understand and use. In a waterfall model, each phase must be spotless in its entirety before the next phase can begin. At the end of each phase, a review takes place to determine if the project is on the right path and whether or not to continue or discard the project. Unlike what I mentioned in the general model, phases do not overlap in a waterfall model.Waterfall Life CycleFigure 1.1Reasons for selecting waterfall methodology for Hotel RivieraWorks well for smaller projects where requirements are very well understood. casual 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 suitable for real time and critical systemSuitable for small and large size of it projects.Simple and easy to use.System necessitysFunctional RequirementTo develop a intacty tested Guest up participation, Room update process, it is asked that the action should allow the user to add, edit find details and handle payments. To accomplish this, it is required to create Access VB (Visual Basic) forms. It necessary to maintain reservation file, guest file, order details files payment file including registration fee in the database. So it is asked to design the necessary interfaces using VB to fulfill the above requirement.To fulfill the above requirements I have created a fully tested reservation system from the knowledge that I have on VB Access. I assumed that resort reservation system need to computerize the reservation process and I have directed my efforts and created a program which is coming out here.Front endWelcome ScreenWelcome concealment with user verification facility. This screen will allow the user to type user name and password. This user name will be common for garbage disposal members and other username and password for Manager.Registration of new usersThis system should allow registering new users from this organization.Adding details to databaseWhen a Guest comes to register, the system will be added his details to database. practically(prenominal) 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 detailsDetails 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 details such as room number, room type, rate and status etc.Banquet detailsBanquet reservation also is another function of this resort. So details of banquet can be found in this system. Also the system should be able to record their information. Such as banquet no, location and charges.Engineering detailsWhen customers reser ve a vestibule 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, Chicken Salad, vitamin C (Medium) and Fried chicken w/ rice etc.Liquor detailsHotel Riviera has a big bar for their customers. So liquor details are very important for this system. Mainly it should be included description 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 made 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 successfully 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 in operation(p )ity 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. melodic themesIn this computerized system, reports will also be a part and parcel they are the means that help get printed outputs here. Staffs should be allowed to go by reports and get prints.Common functionality requirementsThe system will be having a Multiple Document 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 within one window. It can be b y 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 reenforcement the database to a certain location. This practice 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 today 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 this section I identify non functional requirement within the projects scope.Product RequirementUsability and EfficiencySince the earlier version of Visual basic (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 shou ld easily understand close the system. And they will find it very much handy.Portability informationbase 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 step-up 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 while this system is running on the machine.Software Requirement for ImplementationFor the development of the new system, the following software packages are recommended to be used.Microsoft Visual basic (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 combo Control, Data grid control, Microsoft- Calendar control and Date time picker control, etc.Microsoft Access 2003 as database back end.Crystal Reports 8.5 for the creation of reports. All the reports will be called within Visual Basic using the Crystal knockout ActiveX control.Software Tools are Needed to Developed the cutting SystemMicrosoft Visual Basic 6.0Microsoft Word 2007Microsoft Visio 2003Microsoft AccessAdobe Photoshop CSHardware Requirement for New SystemThe reservation system to computerize their reservation system, a computer system needed the following minimum requirements.Processor 400 MHz pile 128 MBHard phonograph record 4 GBVGA 32 MBMonitor 14Operating System Windows 2000/xpSoftware Microsoft Office 2000/xpFloppy Disk Drive 1.44 MB 3.5SummaryThis chapter provided a detailed description on why Hotel Riviera Needs a web and Visual Basic based System and how online room reservation and computerized rese rvation System solved the problems they are currently facing with the requirement analysis. Next section gives a detailed description about(predicate) the system.System AnalysisIntroductionThe 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. 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 psychoanalyst must do the current system, which is being 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. foreplay 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 workflows.Methods and ways for performing the work.Work propagation and limits.Information about the work environment.Resources available.Proposed System commentsThe 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 wanted room with facilities and food, advance 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 ap plication. The guest will select his needed suitable. Cashier will handle all calculation and payment processes. The supervisor will create the reports to the management. 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 SystemHandling Customer DetailsRoom reservationsBanquet reservations supporting facilities throw ins data permanentlySecurityCancellationsHandling Rooms DetailsMaking PaymentsFeatures like Update, Searching, Deleting, Editing Record etcGenerating different kinds of report.Added Solution to Implement the New SystemThe Data is not long-lasting due to the proper systemEven 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 store d 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 page 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, normal and files. Deleting, updating and editing also 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 Re sort 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 purloin any record file because they will have their own login. Without knowing 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 accurat ely 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 system 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. Name and explain some strategies for generat ing design solutions, simplifying design decisions, evaluating designs, and terminating the search for alternatives, the purpose of design models and the principal categories of design models and summarized some differing perspectives on the nature of designData Flow plat (DFD)Data Flow diagrams are a net 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 data 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 described 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 generationFigure 3.5Data dictionary for proposed Hotel reservation systemData storesNameDescriptionNumberOwnerCustomer detailsStore the Customer details1 memorial tabletPayment detailsStore the Payment details2AdministrationRoom detailsStore the Room details4AdministrationBanquet detailsStore the banquet details5AdministrationBar detailsStore the bar details3AdministrationPool detailsStore the pool details6AdministrationRestaurant detailsStore the restaurant details7AdministrationTable3.6External entityNameDescriptionTypeTotal occurrenceGuestDescribe the customer who are booking the room and banquet individual1ManagementDescribe the management of HotelDepartment1Table 3.7Data processesNameDescriptionInput fromOutpu t 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 process detainment the room details.guestguestKeep the room details, bed details and other equipments details.Check the room, if there is anything damage, collect the details, and admit 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 restaurant detailsKeep the food itemsReport g enerationHandle all the reportAll the detailsReport generationKeep whole hotel details and when the administration ask the report, get the print out and give it to them.Table 3.8Data flowNameDescriptionSourceDestinationguest detailsRepresent the guest detailsGuestadministration processpayment detailsRepresent 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 restaurant detailsrestaurant processadministration processCheck restaurant detailsRepresent the checking restaurant detailsRestaurant processadministration processTable 3.9Entity Relationship Diagram (ERD)Normalized ERD for the proposed systemFigure 3.10Relational TableNormalizationNormalization is the process of efficiently organizing data in a database. There are two goals of the calibration process eliminating redundant data (for example, storing the same data in more than one table) and en