Hotel Reservation

I. Statement of Scope and Objectives A. Introduction Techno put downical invention cause changes in the way deal live. They have dissemble lives of mountain easier, more(prenominal) than(prenominal)(prenominal) comfort fit and convenient and even hoteliers and services oriented companies find ways how to satisfy their customers, But how these hoteliers have sex their dealings with fast and more convenient way. The Columban College Hotel & Resort is pitched Dr. Susan P. Alegoria, the Dean of the College of Business Administration, with the proposeing approval of the school financial officer Fr. Amado S. Censon and Rev. Fr. Daniel O.Presto the school President to the Board of Trustees al nearly Reverent Bishop Florentino G. Lavarias, DD, as hot seat of the Board. Hotel now argon having a hard cadence bread and buttering their files in place. The procedure implemented is slow in bearing. Manual handling of selective training may lead to inaccuracy of learning bec ause humans be pr ane to errors. In their backlog transaction there is a problem in sack of schedules of the rung because the records is place provided in the logbook and several(prenominal) sentences the staff is non alert that there is a taciturnity in a particularized dwell because of it is difficult for them to find the live immediately.The proposed computing machineization body idler cut back if not tot eachy eliminates the errors that pull up stakes be encountering. This arrangement provides businesslike and particular output because of the transaction for computation of bills. Accessing and updating records in making sight be by means of with(p) with relative. It would then be easier for this comp whatsoever to go close their fiddle with less exploit and high efficiency. For Columban College Hotel & Resort, a manual(a)(a)-based transaction is still applied that serves as their primary clay & when it comes to their selective reading charge which is record go foring and report generating.Such processes atomic number 18 done using logbooks, worksheets, determine lists, calculators and a lot of human intervention. By doing so, the company has been encountering human errors much(prenominal) as inaccurate calculation, when turns out to be an inconvenience for them as it requires greater effort and time. To complement the take in for capacity to control, it is essential to develop an entropy governance that give serve as the companys backbone. stress of the Study Columban College Hotel & Resort was built on the premise of putting aLaboratory expertness for BSHRM Bachelor of scholarship in Hotel and Restaurant Management and BST Bachelor of intelligence in Tourism students. aft(prenominal) two years of deliberate construction, a five storey, 15 live building complete with three ace class facilities fin exclusivelyy open its doors on April 15, 2004. A team of experts manage and operate the Hotel Laboratory for the students to experience a first class hospitality jazzledge, making them equipped and at par with their counterparts. each(prenominal) Laboratory classes/subjects ar done in the hotel drift Office, Housekeeping, Kitchen Operations, Bar Tending/Cocktail Mixing, Baking with Cake Decoration, worldwide Cuisine, Events and Catering Management, and Culinary Arts. These particular(a)ized subjects are taught by experts from the industry and with NC II certification by TESDA. The Columban College Hotel & Resort, is the first educational hotel in Zambales and Bataan Provinces, it is located at Barrio Barretto, O astronomicapo City. It is ten minutes out from Subic Bay Freeport Zone, thus making it holy individual for conferences, retreats and different gathers.Nestled in the nature rich field of the Barrio Barretto with a undischarged view of Subic Bay and the mountains. This hotel and mending features very affordable live rate one plenty choose from standard to deluxe mea ns ranging from Php. 1,200. 00 to Php. 3,600. 00. It has wait on room that stack accommo come crosswise 200 thickenings, and dining areas. The swimming kitty-cat a mini Olympic size pool with kiddy pool with drenching tropical gardens and a roof deck overlooking the Barretto campus and Subic Bay exit definitely make your stay worthwhile. As educational hotel and mending, our tradition of speckless service provide make your stay memorable.The Columban College Hotel & Resort continues to set itself obscure with its excellence in Hospitality Service and education as narrate by the result of regional culinary skills competition. The existing frame in the establishment contains many a(prenominal) manual operations, including a manual modification and substitute per casted by the invitee which creates a problem on the receptionists recording the selective education that has been garner, manual transactions of hire also created problem in paid the bills in the hotel. T he Columban College Hotel & Resort is having a hard time keeping their files in place. The procedure implemented is slow in flush.Manual handling of training may lead to inaccuracy of information because humans are prone to errors. In their booking transaction there is a problem in shifting of schedules of the staff because the records is place altogether in logbook and intimatelytimes the staff is not aware that there is a substitute in a specific room because of it is difficult for them to find the room immediately. An otherwise problem also is the trade of the hotel because of its location and finding the prospect guests. The proposed computerization body of rules can reduced if not tot tout ensembley eliminates the errors that testament be encountering.This strategy provides effective and precise output because of the transaction for computation of bills. Accessing and updating records in stockpile can be done with relative. Reports are being generated depending on t he list call for by the solicitude. It would then be easier for the company to go about their work with less effort and with high efficiency. B. Statement of the Problem MAJOR conundrum Based on observation and interview done by the proponents, this culture identified that the major(ip) problems experienced by the management lies on the manual process of all their operation. detail PROBLEMS 1. Slow Process It takes time to prepare a billing report and billing line of reasoning of the lymph nodes and unable to determine upper berthily the availability of the rooms in assure to assign rising clients to their single rooms because they are still using manual process. 2. information credential Their records bequeath part lost or damaged because their information is not secured and sometimes the receptionists overlooks the records of the stockpiles and assigns different clients on the same room and same date which makes the manual formation unreliable. 3.Intensive lab or They have difficulties on look for clients records and see the log books for the availability of the rooms it also needs effort in cast to compute the billing statement. C. Objectives of the Study GENERAL OBJECTIVE The oecumenical objective is to design and develop a Hotel Management arranging of rules for Columban College Hotel & Resort, Barrio Barretto, Olongapo City. SPECIFIC OBJECTIVES 1. To be able to develop a placement that allow for speed up the process of operation. The receptionists allow for have an quench using this administration because our proposed schema is capable on cypher the compensations that clients have made. . To be able to secure a program by creating a different drug substance abuser level of security The proposed arranging imparting have a efficacy to create a back-up of the recent database and the records are sheltered because the wholly person who can access their records is the receptionists. 3. To be able to develop a system th at go awaying ease the occupation of different user. With one glance the rooms term go forth be shown whether it is available, set-aside(p) and arriere penseed. The receptionists would no protracted look throughout all the rooms information on the log book one by one. D. Scope and Limitations ScopeThis theme will gallop the management of the rooms, the system will show the information of the room if it is occupied or available. The system will provide the computerization of the costumers total. The system will record the clients information and the transaction they settled. Limitations The system limits the direct usage of the system by the clients, only the receptionists can operate the system. trending guest information & transactions can only be made by the receptionists. E. locus of the Study epitome 1. 0 The Columban College Hotel & Resort is located at Rizal Ext. Barrio Barretto, Olongapo City, estimable the Columban College, Barretto Campus. F. Significance of th e Study This vignette aims to provide a Hotel Management brass for Columban College Hotel & Resort. With regards to the billing of the guest, the system will be responsible in computing their payment and take ining the availability of all rooms. Receptionists They will consume less time and effort interacting with their clients. Having this system, they can easily access or check the status of the rooms depending on its types. And they can easily give the bill of the clients because it was already computed by the system.Clients Their clients will not have to wait for a long period of time for the room that will be assigned to them and their bill. partnership The hotel will have a better transaction process and ease in their guest management. II. Review of Related writings and Studies A. Related literature This chapter is a discussion of the background, aims and objectives of the present study. This chapter deals with the review of related literature. The purpose of the study of investigate works done in the same field is to come across what type of study has been done and what exactly has been explored before the present research work started.The system provide the reception an easy way for searching on rooms, listing off rooms, inserting the client information, making modesty for rooms and doing payment process. This will be created by four students of Columban College. They are Jon Roel Lasala(BSCS), Kristian Castillo(BSCS), Steven Ocampo(BSIT) and Rosendo Luy(BSIT). B. colligate STUDIES Foreign Webraydian (2007) assert that to run a hotel successfully it is important that the hotel management should be good before making any change in the trends one should take a look to every aspects as any changes in the trend also have a wide encounter on the diverse industries.Rutherford (2009) asserted that the hotel business should be done in basis of the guest interest as well because of the growing care over environment friendly service. OFallon (2010) asserted that the hotel business is one of the most competitive businesses in the world or the better talking to is most cut throat. Michael utter that hotel reservations package leases hotels and resorts to manage reservation software allows hotels and resorts to manage reservations, set rates, offer discounts and monitor room allocations. Most otel reservation systems include hotel management software, hotel reservation and billing software, hotel reception software and hotel accounting software modules. Global Marketing asserted that communicating with all of these channels in order to keep them underway on your history and rates, requires in some cases, daily manual intervention with multiple faxes and rally calls. More importantly, verifying the accuracy of each channels current allotment and rate by property is critical but seldom automated. Most times hotel operators do not receipt where or how their rooms are being sold or at what rate until the reserve confirmati on arrives.Waller express that is hotel hotel reservation software is really a inevitable need. Pencil and paper troth sheets for example tend to get the job done, yes? That may be so, but also considers that with hotel reservation software, such booking sheets can be printed out, and many software packages can be piece to most any language. Martindale, asserted that another great feature about using hotel reservation is you can select from any hotel in the area that you want to stay at, even of your budget wouldnt normally allow you to afford it.With the online system you can browse the different hotels available in the area, and see if they have only a discounted price or if they will allow you to create your own price. This many sound strange, but especially during off peak times many hotel want race to go along something to stay in their room to help increase their annual revenue. Charya, asserted that Hotel Management system helps the hotel administrators to accommodate s pecial request, booking checkouts, etc. They keep sending reminders highlight the important dates for the benefits of the customers.It also gives the hotel administration leverage in terms of making immediate queue upments as and when something unexpected turn ups. Schneider said that room management is simple and cost effective because a guest room management system can ensure maximum easy and cost effectiveness. Assuresoftware. com testified that the management software can help your people get more out of every minute, every hour, and every workday. It is designed to unless productivity by simplifying scheduling rooms and resources. LocalValenzuela (2003) asserted that computer-based hotel reservation and billing system can reduce errors that will be encountered. This system provides economical and precise output because of the transaction for computation of bills. Reports are being generated depending on the list inevitable by the management since computerization of all co mpanies are being encourage there is need for hotels to adapt computerized operation too. Razal (2004) testified that the reservation and information are essential to attract clients and customers, so when they see that the judicature that can be added to their success.Wong (2004) concluded that reservation system will diminish the work of the employees and would really help them a lot in managing the hotel and it would be much easy to organize all transactions of the hotel. Capistrano (2005) asserted that reservation system enhance the existing business operation and give farther improvement for the business process. Fuerte (2005) concluded that an practise of IT technology in any business firms hold the key to competitiveness towards instruction and success in the business.Ramirez (2005) asserted that reservation system will benefit not only the company but customers as well, because it will increase the efficiency of the employees working(a) operation. Daduya (2006) claimed that organized and fast retrieval of information computerization of their reservation and registration process is need, for them to have fast and accessible transaction. Mirador (2007) asserted that reservation system is deemed significant because it will be different from the traditional process of reservation.This will reinstate the manual process of reservation which probably creates difficulty for the people the who are responsible in reservation. C. abbreviation on Related Literature and Studies As summary, Hotel Reservation governance is an advance process of managing hotel reservation check in, check out of costumers. It is a user friendly and helps the hotel receptionist to accommodate special request, booking, checkouts. They keep sending reminders and highlight the important dates for the benefits of the costumers. in that locationfore, hotel that uses Computer based system needs to conduct day training for the users/receptionist to be literate in hotel management system and to avoid difficulties in making reservation of costumers. It lessens the time consume doing the hotel reservation. It is a replacement for manual reservation. A system more convenient and user friendly and compiling of files is more accurate and more sufficient than compiling it manually. It is more easy-driven to ensure faster and reliable data by processing of information in database. III. systemologies A. orders of Research StudyIn this chapter, the proponents described the rule of research apply and data host procedure, tools and data processing techniques. The Proponents utilize the different gathering materials like meshwork, books and precedent study similar to the proposed study. After collecting and analyzing the data that we gather we found out some of the problems and get our main objectives that served to be our guidelines for pursuing the system. Those gathered information from questionnaire, great deals and interviews can solved to the problem of the Col umban College Hotel & Resort for their manual process. B. entropy Gathering Techniques The proponents employ the Descriptive Method it is designed to investigate and to gather information about the present situation. This was the elect method acting of the proponents because the method can help the proponents obtain the information they need. There are different ways to gather the information need for the proponents to understand more about the current system of Columban College and how can the people ad mediocre in the new system that is going to be implemented. The facts and information that was gathered by the proponents was obtained by the use of Observation, Interview and Survey.Observation this first stage to be done because before doing the interview and survey the proponents needs to observe what miscellany of environment the locale of the study have, what kind of people is involved and the educational attainment of each people. This technique is very helpful in gatherin g the needed data because conducting the observation opened some issues and problems that the study will encounter. Interview by conducting the interview, all the questions and issues of the proponents was brought up and was answered.Interviews were done with the different people who are involves and in-charge of the Columban College Hotel & Resort. Survey this was used by proponents to determine the percentages of the students who agree and disagree on the proposed system. Using this technique gives the proponents the opport unity to understand the situation of the students in the existing system. The techniques/ways discussed above will not be obtained without the instruments used in data gathering. These instruments were performed carefully and accurately to have a very reliable result in the study.The instruments used to gather the information needed are the library and the Internet. Library the proponents used the Library to gather some important information that can hel p improve the study. It also play a very big part in the study itself the Library contains a lot of reliable information regarding the study that helped the proponents. Internet the internet played a vital role in gathering the information needed. The internet nowadays contains information that are not that reliable and accurate, the proponents carefully compared the results and comments of the other readers in the internet to have a result that is reliable.The proponents used survey form as one of the most important method in data gathering. A set of survey questions was disposed(p) to at least 30 respondents including employee and guests of Columban College Hotel & Resort, who gives the proponents a specific association and help us in identifying the common problems they are facing in a tattle to the study. The proponents used Percentile Method to determine the quantities and percentage of the solvents in the survey. 1. have Design A tramp for Columban College Hotel & Resor t Rizal Ext. , Barrio Barretto, Olongapo City honey respondents, This survey aims to collect data in accordance to the study Columaban College Hotel & Resort Management trunk. loving answer the question honestly and accurately. Please do not pop off any statement unmarked. Your response will be highly appreciated. convey you very much. God Bless I. Personal information Name (Optional)_____________________________________________ maturate 12- 16 17- 21 21- 30 30 & above Gender male person Female II. Questionnaires 1. Is the reservation process on the hotel fast copious? 3D YesNo 2.Was your reservation handled courteously and correctly? 3D YesNo 3. Was the check-in process was punctual and efficient? YesNo 4. Was your suite clear(p) and properly maintained? YesNo 5. Were your arriver and waiver experiences handled courteously and efficiently? YesNo 6. Do you think that the computerization of the reservation can dissemble the performance of the hotel? YesNo 7. Did the resort exceed your expectations? YesNo 8. Would you stay at the resort if you were to return to this area? YesNo Letter of Interview Columban College Hotel & Resort Rizal Ext. , Barrio Barretto Olongapo City Dear Sir/MadamGreetings We are graduating students of College of Computer Studies taking up Bachelor of Science in breeding Technology and Computer Science. Currently, we are enrolled in our dissertation Writing Technology where we are required to design a system for a particular organization or industry. In relation to this, we mean to design Columban College Hotel & Resort Management System and we are seeking for your assist for us to conduct an interview and data gathering at your most convenient time. Rest assured that the information that we will get will be treated with much confidentiality.We are looking forward for the context that you can give to our request. You may reach us through the afterlife(a) number 09072316910 or email us at emailprotected com Sincerely, ______ ___________ Noted by Jon Roel Lasala ________________________ _________________ Mr. Ronnie D. Luy Kristian Castillo Thesis Adviser _________________ Steven Nicco Carangalan _________________ Rosendo Luy 2. Respondents Figure 2. 0 The receptionist of Columban College Hotel & Resort Figure 3. 0 Readying for interview on Mr.Elmer Callo, Assistant Manager of the CCHR Receptionist The receptionist will be observed by the proponents to hump what is the possible problems that are occurring in acting the manual operations in the hotel. nodes The proponents will conduct a survey of how the manual operations of hotel affect the satisfaction of the guests. Administrators The proponents will interview the administrators of the hotel to know what problems they are experiencing in the hotel. C. Statistical Treatment of information 1. Percentile Method to determine the quantities and percentage of the responses in the survey.Survey forms will be condition to the employees and some guests of th e Columban College Hotel & Resort. N N Formula P = f x vitamin C Where % = Percentage f = frequence N = essence Number of Respondents D. amass data and Information Result of Survey The results of the survey were discussed on this study and the following questions that were answered by the respondents 1. Is the reservation process on the hotel fast enough? absolute frequency Percentage Yes 7 23% No 23 77% tally 30 100% remit 1. 0 Figure 2. 0 2. Was your reservation handled courteously and correctly? oftenness PercentageYes 17 56% No 13 44% hail 30 100% Table 1. 1 Figure 2. 1 3. Was the check-in process was timely and efficient? Frequency Percentage Yes 11 36% No 19 64% Total 30 100% Figure 2. 2 4. Was your suite clean and properly maintained? Frequency Percentage Yes 22 73% No 8 27% Total 30 100% Table 1. 3 Table 2. 3 5. Were your arrival and departure experiences handled courteously and efficiently? Frequency Percentage Yes 18 60% No 12 40% Total 30 100% Table 1. 4 Figure 2. 4 6. Do you think that the computerization of the reservation can affect the performance of the hotel? Frequency Percentage Yes 28 93% No 2 7% Total 30 100% Table 1. 5 Figure 2. 5 7. Did the resort exceed your expectations? Frequency Percentage Yes 15 50% No 15 50% Total 30 100% Table 1. 6 Figure 2. 6 8. Would you stay at the resort if you were to return to this area? Frequency Percentage Yes 21 70% No 9 30% Total 30 100% Table 1. 7 IV. Modelling and Technical range A. package Model The proponents adopt the System Development Life round of golf because this will act as the proponents guide in creating the proposed system. Figure 3. 0SDLC is a process used by IT analysts in order to develop or redesign high quality software system which meets both the customer and the real world requirement taking into love all associated aspects of pros and cons of software scrutiny, analysis and post process maintenance. B. Theoretical example This chapter will discuss the d ifferent process and methods of creating the needed system of the organization through the guidelines that the proponents created in their researches and findings. This chapter also involves the different phases that will act as guide that will be an essential to the creation of the proposed system. extra information Additional information PLANNING PLANNING DISCOVEERY DISCOVEERY INFORMATION pull together INFORMATION GATHERING REPORTING REPORTING Figure 4. 0 Theoretical positioning C. conceptual Framework Proposed System Proposed System curb for room availability Check for room availability Show and compute for the bills Show and compute for the bills hit a back-up for database give a back-up for database reveal the needed information Give the needed information Give the room proclivityd by the client Give the room desired by the client Give the payment Give the payment Client Client Receptionist ReceptionistFigure 5. 0 Conceptual Framework This figure shows the concept of th e proposed system, It will tackles how the process of interaction between the receptionist and the guests. 1. range of a function/IPO Diagram Figure 6. 0 Paradigm The IPO model has many interdisciplinary applications, and is used to convey systems fundamentals inITovervieweducationand as a brainstorming, preliminary investigation tool insystems development processessuch as theSDLC. V. Systems Analysis and Design A. Systems Analysis 1. Existing System Columban College Hotel & Resort is currently performing all their process in manual operation. . aimr Requirements/ Requirements Specifications commitr Requirements Developer Requirement Automated Billing Statement fabricate a system that will automatically generate billing statement Computer-based viewing Room Status Include the room status in the features of the program Computer Reservation take a Database Management System Computer-based Check in/out Create a system that will manage the Check in/out of the clients Computerized Adding/Viewing of Clients information Create a Database Management System Table 2. 0 User Requirements 3. feasibleness Study 3. Technical feasibility Columban College Hotel & Resort is in need of a computer-based system to be able to operate faster and more efficiently. The system project primarily intends to avoid inconsistencies during operation. Also, implying the use of computerized processes avoids inaccurate report of billing amounts and miscalculation of transactions. Microsoft Office 2010 offers flexible and powerful new ways to take over your best workat the office, at home, or at school. Create standout reports and presentations with tools that help you capture your ideas more creatively.Stay connected to your projects, even when youre away from your computer, with access to Office files via Web browser or Windows phone. 1 arrive at efficiently with others by sharing, editing, and reviewing files at the same timeeven across geographies and time zones. Adobe Photoshopis a graphics editing program genuine and published byAdobe Systems. Photoshop files have default file book of facts as. PSD, which stands for Photoshop Document. A PSD file stores an image with support for most imagery options available in Photoshop.These include layers withmasks,color spaces,ICC profiles, CMYK Mode (used for commercial printing), transparency, text, of import channelsandspot colors,clipping paths, andduotonesettings. This is in contrast to many other file formats (e. g. .JPG or . GIF) that restrict content to provide streamlined, predictable functionality. A PSD file has a maximum height and width of 30,000 pixels, and a duration limit of 3 Gigabytes. optic basalis athird-generationevent-driven programming languageandintegrated development environment(IDE) fromMicrosoftfor itsCOM programming model first released in 1991.Visual Basic is designed to be relatively easy to learn and use. Visual Basic was derived from BASICand enables therapid application development ( RAD)ofgraphical user interface (GUI)applications, access todatabasesusingData Access Objects,Remote Data Objects, orActiveX Data Objects, and creation ofActiveXcontrols and objects. VBAis effectively the same language as Visual Basic but VBA-code is tied to Microsoft Office and can only run within that environment. Thescripting languageVBScriptis a subset of Visual Basic. . 2 Economical feasibility The Economic feasibility will be the basis if the said device is economically feasible Every company knows that cost is one of the major problems to be considered in making a proposed system, if it affordable or not. However, the only thing that the shop need is hosting the proposed system and it is less expensive. The proposed system fair(a) need to acquire an internet connection and have fellowship on computer and it will be possible for them to get their needs and information by just browsing.The economic feasibility will illustrate the expenses needed to be able to implement the proposed system successfully below. Since the Columban College Hotel & Resort has already has a one (1) complete set of personal computer, there is no need to buy a new one. software package Specification Software Components verbal description Windows 7 Microsoft Office 2010 Visual Basic 6. 0 computer hardware Specification Hardware Components Description Intel DUAL CORE E5300 2. 6Processor INTEL DG41RQ DDR800/ 6CHN/ GLAN/ QUAD/ 2 GB DDR2 PC800 Hard disk SEAGATE 250GB 7200 SATA Monitor AOC9315l 18. 5 Black AVR ergocalciferol watts A4Tech Slim PS2 KBS-720 Black A4tech Optical Mouse OP6200 USB 3. 3 Operational Feasibility Operational feasibility is this will focus whether the system will be productive if it is being developed and implemented. Whether there will be affect from user or there will be possible application benefits. Operational feasibility, this is how the system will solve the following problem or how it satisfies the requirements analysis phase of the developm ent.ITEM UNIT PRICE QTY. FREQ. (1 Acad. Yr. ) TOTAL Bond opus Ream Php. 200. 00 1 20pcs. Php. 4,000. 00 Ink Cartridge Php. 350. 00 1 1 Php. 350. 00 Log sustain Php. 35. 00 1 12pcs. Php. 420. 00 Total Php. 4,770. 00 Table 4. 0 Operational Feasibility electricity Consumption and Cost Rate/kW = Php. 5. 90 (based on ZAMECO II) amount = (units watt/1,000kW) *rate *hours usage ITEM UNIT WATTS(1 Acad. Yr. ) HOURS role COST Personal Computer 225W 24hrs. (min) Php. 4,032. 00 Table 4. 1 Operational Feasibility 3. 4 Time FeasibilityTime feasibility will say the schedule if the project being done. And how many months it is being cover. This Gantt chart show how does data gathering being done and even the design phase and maintenance are show in the Gantt chart. Bars show the time being consumed in one task to other task until we fulfil all the requirements needed by the clients. Figure 7. 0 Gantt Chart 3. 5 Feasibility Analysis Executive Summary After the proponents gather all the essential information needed, the proponents is convinced that the proposed system will be feasible in implementing.The proposed system requires both hardware and software components to keep the system running. For the receptionists, the Visual Basic 6. 0 is needed to run the system. It is important to create a back-up of database to keep the information and transactions safely. Since the needed software and hardware were available in the hotel, the proponents will only now focus in implementing the system to know whether the proposed system will truly help the Columban College Hotel & Resort. 4. stake Analysis Risk Source Action Risk levelData corruption through loss or alteration of data without the applications knowledge and consent Receptionist error (accidental file deletion) Recover file full(prenominal) Software bugs (unexpected conditions and responded to incorrectly Update anti-virus, delete any virus founds metier Data corruption through willful action Externally, from viruses and worms Create back-up data Medium Acts of God Earthquake, floods, etc. Create back-up data Low Table 5. 0 Risk Analysis B. System Design 1. Proposed System This research describes an adaption of a hotel reservation system in Columban College Hotel & Resort.Computer technology has made our lives much easier and convenient. old age ago, people had to manually input important information of their guest, now you just use the computer to find this information. In just one click, without delay find the guest name, rooms & rates, address, email address, phone numbers and so on. By investigating their existing reservation, the guest input the information manually in reservation form. It is hassle for the guest to do a reservation as well as to the receptionist. It is time a waste of time, effort and the things that is needed for the reservation.Proponents will implement the proposed system in Columban College Hotel and Resort. All you need is computer and a user, by just open ing the application. It is a very reliable, efficient and convenient. It is much easier to for the receptionist to look at the database and see if the guests are already paid or if the room is already occupied or slothful and so on and so forth. 2. Object-Oriented Analysis and Design 2. 1 UML score Diagram Figure 8. 0 Class Diagram 2. 2 Use mooring Diagram System System Check Room Information Check Room Information Input Customer InformationInput Customer Information Update System Update System Edit information Edit information Add Subcharges Add Subcharges Total pay Total Payment Figure 9. 0 Use Case Diagram 2. 3 Use Case Description Use Case Input reserved information Actor Receptionist Description Input data information about room reserved Trigger When a customer wants to reserve for room Pre-conditions Customers wants to reserve room Post-conditions System will be updated Normal black market All information about reservation essential be encoded Priority High Frequency of Use In all guest to booked in the hotelTable 6. 4 Use Case Updates System Actor Receptionist Description Updating of system in every time there is new booking schedule Trigger New inputs/booking schedule is given Pre-conditions Guest requested for room reservation Post-conditions Input/information given is updates to the system Priority High Frequency of Use In all guest to booked in the hotel Table 6. 5 Use Case Edit information Actor Receptionist Description Editing of customer and room information Trigger When information needs to be updated Post-conditions System will update changesNormal Flow Editing is unceasingly done when changes are needed to be done in the customer information Includes Data Verification Table 6. 6 Use Case Total payment Actor Receptionist Description Adding all the expenses in the information Post-conditions Payment will be done according to the total amount Normal Flow Includes Priority Frequency of Use Business Rules Table 6. 8 2. 4 System Sequence Diagram 3. mesh Diagram/System computer architecture Proposed System Proposed System Receptionist Receptionist Database Management System Database Management SystemFigure 11. 0 Network Diagram Network Diagramis theconceptual modelthat defines thestructure and doings of asystem. 4. Database Structure 4. 1 Entity Relationship Diagram 4. 2 Data Dictionary 4. 3 Relational Databases 5. System Interfaces 5. 1 System Inputs Guest Reservation Form This is where the receptionist will input the essential information of the guest, it will also show how much the guest will pay about the chosen room. This is where the additional necessity will be ordered by the guest and the receptionist will process the transaction 5. 2 System Outputs . 3 Process Specifications 5. 4 Integrity Controls All bits of information or data that are gathered in the guest will be stored in the system and its database. Only the receptionist can modify the system in the boniface through the approval of who might be th e one should be authorise it. That person who will be approving it will depend on the agreement of the company or policy. 5. 5 Security Controls The proposed system has the capability to back-up the database of all it saved information. The system will have passwords where only receptionist can access it.Any antivirus programs with high integrity will be used to protect the system. 6. Automation Boundary The proposed system will be about reservation of room accommodation and other services. The system will not be providing automated billing. 7. Initial Gap Analysis The existing system is all about manual operation by plectron up form of reservation, unlike the proposed system all you need to do is encode the information. separate advantage of the proposed system its more efficient if compiling reservation form. It is also more accurate in reviewing data information about the old accommodations.Chapter VI A. Implementation Activities In order to successfully implement the propose d system for Columban College Hotel & Resort, the proponents need to orient the Receptionist, Manager and Owner on how the process of the proposed system works and on how the system should be handled, after orientation and elicitation the system will be tested and will be evaluated for further revisions or enhancement that are still needed to include on the proposed system. B. Testing 1. Unit Testing The system administrator and other users will be involved in testing the program.The users are allowed to explore the system then let them take notes if there are any flaws in it or if there are anything that needs to improve. Then the proponents will debug the system then re-run the testing for further adjustment and debugging until the system will be fully operational. ALPHA TESTING Alpha testing is a form of preliminary software field test carried out by a team of users in order to find bugs that were not found previously through other tests. The main purpose of alpha testing is to refine the software product by finding and fixing the bugs that were not discovered through previous tests.This indicate the stages of the process how the system response to its given task. The testing is conducted in order to know how the systems deliver the required response regarding with its performance. Based from the test that has been establish in using alpha testing, the proponents comes up from the first part of testing the system, there were things that must be change. One of the changes that need to be change is the abolishing of the manual procedure of the hotel, 2. integrating Testing 3. Usability TestingAfter all operation testing are done, the Hotel Management System receptionist will seek for questions regarding the improvements of the system. After gathering some information, adjustment or improvements will be done in the system depending on how big are the problems need to be change in the system. 4. User betrothal Test As all the adjustment or improvements are d one, the system will be tested again by the Users and will be re-evaluated if the system already fulfilled the Users satisfaction. C. Change request and Error Reports D. Deployment 1. Deployment Approaches 2. Users TrainingIn order for the system to fully-implement in the oraganization, the users must undergo training in order to gain enough knowledge in computer. The training will be about familiarizing in the operating system which is the Windows7 so that the user wil use will know where to go in accessing the system, then the Microsoft Visual Basic. net in order for them to easily understand the environment of the syetm because the system is made through the said software. Then, also most importantly is the users must be trained on how to use the system. The training will be conducted in their free time.In terms of the untoward incident that will happen in the system during the operation, the users are obligued to go out series of trainings for the debugging of the system as wel l as the systems maintenace. 3. System Maintenance 1. Problem Report During the previous process, the problems aroused in the system are the following 2. Manual ever-changing and Updating of records The Hotels office consists of many files of the clients and inventories. Since, the office piled up with many files there are many records that needed to be recorded in a new form and add to the database.And also the files are not be placed consequently because the files are only been placed to the filling cabinet in the office. 3. Employees are not Computer Confident The Front Desk Employees does not have sufficient knowledge about computer. Regarding with this, the proponents suggested to have take out and conduct training or seminar. 1. Policies and Procedures Policies Policies may vary depending on the desire of Columban College Hotel & Resort Management, but the proponents suggest the following policies 1. Only the Admin are in charge of adding, editing and deleting the System User s 2.The system data base should be backed-up every week in case of data crash or other unexpected circumstances 3. The Computer should be place in a nice atmosphere to prevent overheating. 4. No other employee other than the Receptionist, Manager and owner can directly use the system. 5. In the reservation transaction, down payment is needed in order to confirm the reservation, the receptionist will inform the client that the registration will be cancelled if the guest didnt arrive 2 hours after the expected time of arrival and the down payment will serve as the registration fee. Chapter VIIConclusion and tribute A. Conclusion The Hotel Management System have already been completed. It really made a significant difference as compared with the present existing system of the hotel since it was done through interfaces of computers. The usage of the system truly provides the advancement of technology, towards a fast access of information. The proponents thereof conclude that it is mor e reliable to make use of the proposed system as it is able to reduce data redundancies and inconsistencies, in which the administrator and receptionist experienced while using the existing system.The proposed system is guaranteed to be secured and will make the work of the receptionist faster and more convenient. B. Recommendation The proponents recommend the writ of execution of the system as it would speed up and make more efficient the processes involved in managing rooms. Full testing before implementation is suggested. The system will not cover how the payment will be done, whether they will use credit card or bank transactions.Stand-alone computer unit is used in the system but in the future purposes the respondents can use two or more computer unit for the manager and the management if needed. The user level must be considered always for the security of the files and every transaction. Because of technology the needed for improvement never stop, therefore the proponents rec ommend to the next future proponents to add more features to the system to wrick more useful and to satisfy the future needs of the business.