1.1 Background of the Study
As the technology continues to improve, it also affects the different aspects of the life of the people. For business, proper utilization of technology can brought up good edge against competitors. The use of technology has become an important issue in operating different kinds of businessfor it may improve or deteriorate their market. Green Ridge Apartelle, established since 2008 in Malaybalay, Bukidnon, desires to switch its manual processes to a faster and easier way through automation. Like other businesses who adopt automation in their processes, Green Ridge Apartelle wants to have the same advantage and that is to improve their standards. They are currently
using manual processing of transaction in reservation and cashiering and they don’t have inventory monitoring for their restaurant. In this system, the receptionist is the one liable for all the transaction like providing check-in form, listing reservation, and calculating the payable which is really consumes time. Having a website of its own also helps to enhance the communications and interactions between the apartelle and its potential customers. Potential customers can check out the current apartelle room rates from the apartelle website and made online reservations. Apartelle receptionists, on the other hand can update the latest and upcoming events. The receptionist and the owner will be given different access rights, since they have different role and job responsibilities. The current manual calculation of billing will be replaced by a fully computerized and automated cashiering system, to save on processing time and improve efficiency.Included in the system is an Inventory monitoring and record function that allows the user to monitor current Inventory for the mini-restaurant. Product information is inputted in the Inventory records for easy and fast access for product information.
Fig. 1.1 (Workflow)
1.2 Statement of the Problem
Will GRAAS able to handle reservations online and offline?
Does GRAAS have cashiering that will handle the calculations of every transaction of apartelle? Will GRAAS able to handle inventory monitoring?
Does GRAAS able to generate essential reports for the business? Will the Green Ridge Apartelle Automated System (GRAAS) able to speed up processing of transactions? Is there a significant difference between the manual systemof Green Ridge apartelle to the automated system? Stakeholder’s Issues
The group conducted several interviews in the apartelle to know the different concerns regarding the automation of their processes. We then figure out important issues of the different stakeholders of the business. Users of the system can be classified into two which is the Administrator (Owner) and the receptionist. These two will be provided different access rights in the system. The administrator shall have the right in editing, creating and
deleting user accounts and can access all the features of the system while the receptionist shall have the right to access the main transactions of the business such as cashiering, inventory and reservation.
The system should provide different reports and receipts for the transactions. It must be user friendly so that the users will not be hesitant to used it and let them adapt easily to the new system. The customer shall have the option to transact to the appartelle through online or offline transaction. Online clients should be able to know the available and reserved dates as well as the information about the room and other features of the apartelle that they can avail. Developer’s/Engineer’s Issues
The developers gather different information about the client and come up to sets of problems involving their current system. The group decided to give specific designation to each of the members based on their capacity. In this manner, we can focus properly and we will have a good working system.
Programming language is an issue in developing the system and the programmer of the group should study more on the languages the group will use. Consultations to our instructors are also made to ask for different issues such as functions, processes and documentations. The online reservation was also a hard challenge for the group because they don’t have any background in making such online system.
The general objective of GRAAS is to automate the manual processes and make it faster and easier for the convenience of both users and customers.
Develop an automated system that will handle online and offline reservation for the apartelle. Provide inventory monitoring in the system that will monitor all the stocks and provide necessary information of each of the items in the inventory. Include a cashiering in the system that will allow the user to calculate the bills of the customers. Allow the system to
generate reports that will be needed by the business.
The automation of the processes of Green Ridge Apartelle is faster than the manual processing and there is a significant difference between manual and automated processing in the apartelle.
1.5 Significance of the Study
The general recipient of benefit of the Green Ridge Apartelle system is the business itself. It will improve different aspects of the business such as customer accommodation and increase the speed and efficiency of transactions. Specific:
RECEPTIONISTS – They are the main user of the system and the one who will accommodate the clients and customers of the apartelle. By using the GRAAS, they will able to easily handle transactions and fasten their processing time. They can also keep track to the inventory and the payables of the customers/clients of the apartelle. Reservation will also be easier because the information on the available rooms and reservations are transparent in the system.
OWNER – The owner of the business which is also the administrator of the system will have the opportunity to monitor properly the business anytime and anywhere as long there is an internet connection.
CLIENTS/CUSTOMERS – They are considered as the life of the business. With the automated system of Green Ridge, they can easily transact to the business online or offline. Information about the available rooms, products, and reservations are transparent so that they can easily know what they are looking for.
1.6 Scope, Delimitation and Limitation
There are three main processes of the system namely reservation, cashiering and inventory. These processes are divided into sub processes and it was
accessible depending upon the access rights of a user. Reservation of clients was one of the functions of the system. The reservation starts upon the inquiry of a client. The system process the client preferences to check its availability and let the client choose on the available schedules from the list provided. When the final preference was set, the system process the reservation and the client’s details. The reservation shall be completed upon the confirmation of the apartelle receptionist through a call or e-mail of the client only. The inventory stores the products available and edit, add or delete as the situation requires.However, the food catered in the function hall is not included in the inventory because the customer can choose what will be served or choose the combination of menus that will be served. The price of the food will be inputted in the cashiering as other payable and the amount shall be defined by the receptionist. The inventory is also the reference of prices for cashiering function. Cashiering was also included in the system and was used for the computational transaction and sales. It processes the client or customer payable in the rooms, function hall and in the restaurant. The system has only three possible users, namely: the client, the administrator, and the receptionist. Non-admin can only access limited data. For instance, the client can only access the reserved and available schedules and the products of the apartelle online. Administrators can access all the functions in the system and can add edit or delete user accounts. The passwords of each receptionist cannot be accessed by the co-receptionist for privacy purposes.The receptionist can also access all the system functions excluding the user accounts. For the systems side, the website can handle reservation, payment, queries and comments or feedbacks via online.
1.7 Definition of Terms
GRAAS– An acronym/name of Green Ridge Apartelle Automated System. Client- The person who reserve for rooms using online systemor not. Customer –The person who purchase at the mini restaurant in the apartelle. Administrator- An authorized person that fully operates/manipulates the system. Receptionist–An authorized person that operates/manipulates the system but it doesn’t have full control over it. Automated Transactions–The processes are faster and easier than manual processes. Inventory Records–An update
for data that has been saved and retrieved. Online Reservation–The process of reserving available rooms using the online system. Unified Process Model – is a popular iterative and incremental software development process framework. Komodo – Komodo Edit is a fast, smart, free and open-source code editor. Adaptive Maintenance – maintenance activities intended to enhance the system by adding features, capabilities, and functions in response to new technology, upgrades, new requirements, or new problems. (www.hit.ac.il/staff/leonidm/information-systems/ch81.html)
Corrective Maintenance – maintenance activities intended to remove errors or bugs from the software, the procedures, the hardware, the network, the data structures, and the documentation. (www.hit.ac.il/staff/leonidm/information-systems/ch81.html)
Perfective Maintenance – maintenance activities intended to enhance the system by improving efficiency, reliability, functionality, or maintainability, often in response to user or system personnel requests. (www.hit.ac.il/staff/leonidm/information-systems/ch81.html)
Apartelle’s are popular in the Philippines. The word means “A combination of Hotel and Apartment, often a cheaper value for long-term visits” Hobotraveler.com (2012). It is commonly used in the Philippines and it refers to the apartment like businesses that offers renting and other services. Automation
Automation involves a lot of aspects. It is defined as “the technique, method, or system of operating or controllinga process by highly automatic means, as by electronicdevices, reducing human intervention to a minimum” dictionary.reference.com (2012). One important factor that supports automation is the use of information technology. According to McNurlin (2006) Information technology was “initially used to perform existing information work more quickly and efficiently”. Making the information more quickly was similar to the definition of automation which is reducing human intervention to minimum. “In actuality, information technology is the use of computers and software to manage information”jobsearchtech.about.com (2012) and that is the key to increase the capacity of work with less human intervention. Since computers are already involved, Human-Machine Interfaces comes in. “A human machine interface is an interface which permits interaction between a human being and a machine”wisegeek.com (2012) while the activities between the computer and the user is called the Human-Computer Interaction.Human-Computer Interaction was defined by encyclopedia2.thefreedictionary.com (2012) as “An interdisciplinary field focused on the interactions between human users and computer systems, including the user interface and the underlying processes which produce the interactions”.
Automated vs. Manual
Nowadays, apartelle businesses are growing fast and owners started to look for an edge against their competitors. One solution that was presented was automation of processes which greatly help in speeding up their transactions.Few advantages are mentioned in mge.com (2012). “Hotel room automation includes a variety of products and applications that can be combined in various ways to suit a business’ specific needs.” On the other hand, there are certain disadvantages of automation that are putting the owners in doubt. “A computerized system will have an initial higher cost than a manual system” was one of the mentioned disadvantages in answers.yahoo.com (2012) and the most common of it. Blurtit.com (2012) posted the advantages and disadvantages of manual front desk in hotel industry. Some of the said advantages are “More customer satisfaction, Services can be better customized for a particular customer through a manual system, and Complimentary services can be given for frequent customers or for unsatisfied customers”. There might be negative and positive side of manual and automated, the key for decision making is considering the cost and benefit of the system. Online Automated Systems
GreenRidge Apartelle Automated System was a system with the functions suited in the apartelle and has an online reservation that enables the web users to transact through internet.
When we say online, we directly associated it with the internet. Dictionary.reference.com (2012) defined it as “connected by computer to one or more other computers or networks, as through commercial electronic information service or the internet” According to thefreedictionary.com (2012) automated means “to convert to automatic operation or to control or operate by automation”. A machine, facility, or thing are said to be automatic if it lessen the effort of user. As thefreedictionary.com (2012) define it, “operating with minimal human intervention”. A system is defined as “a group or combination of interrelated, interdependent, or interacting elements forming a collective entity; a methodical or coordinated assemblage of parts, facts, concepts, etc.” by the thefreedictionary.com (2012).
In conclusion, Online Automated systems can be defined as an internet based
system with the less hassle on user and offer better processing. In the case of GreenRidge Apartelle, only the reservation was enabled online while the cashiering and inventory can be accessed offline.
Programming Languages and Tools
There are certain concerns in making a system and one of it is the programming language that will be used. Depending on the system and the functionalities that will be needed, the programmer decides what language that will be used for the task. The following are some of programming languages that are used in making systems: JAVA
“For the enterprise, Java and Microsoft’s .NET rule. However, Java has the edge, as it is No. 1 language in terms of number of developers. According to Evans Data, there are more than 9 million Java developers in the world. That means there are tons of Java applications out there that will have to be supported, updated and maintained. Furthermore, Java is the language of the Android mobile operating system. Android provides the tools and APIs necessary to begin developing applications for the Android OS using the Java programming language. Java ranks No. 1 on the TIOBE Programming Community Index for June 2010 (after a brief stint at No. 2, behind C, in May). The need for Java developers to build new Java applications is not about to wane.”eweek.com (2012)“Java continues to dominate the developer landscape as the No. 1 programming language in use today. It remains atop the TIOBE Index. According to Simply Hired, since April 2009, Java jobs increased 52 percent. With Oracle now the steward of Java and having shepherded two new Java Specifications Requests mapping out the next two versions of the language and platform—Java 7 and Java –the language is due for enhancements to “move Java forward,” Oracle said. The language is used for a variety of things, including enterprise apps, as well as Web and mobile development.” myitview.com (2012) C#
“C# is a multiparadigm programming language encompassing imperative, functional, generic, object-oriented and component-oriented programming disciplines. Microsoft developed C# within its .NET initiative and the language was later approved as a standard by Ecma and ISO. C# also is slated
by Microsoft to become the primary development language for Windows Phone 7. Like Java, C# is big in the enterprise. However there are considerably fewer C# developers than there are Java developers. But the importance of C# as part of the Microsoft .NET strategy and its support through the Visual Studio tools suite make C# a formidable contender in the programming language race. C# ranked No. 6 on the most-recent TIOBE Index.” eweek.com (2012)“Microsoft’s C# was developed as a Java alternative and borrows from its predecessors: Java, C, C++ and Delphi—as it should, since Anders Hejlsberg, creator of C#, also created the Delphi programming environment while at Borland. Powered by Microsoft, C# has become very popular among developers and among Microsoft shops. It ranks as the No. 5 language on the TIOBE Index. According to Simply Hired, since April 2009, C# jobs increased 52 percent.”myitview.com (2012) C/C++
“We know they are not the same language, though C++ builds on C and began as an extension of the C language. Though sometimes viewed as “nichey,” C++ is widely used in the software industry. Some of its key application domains include systems software, application software, device drivers, embedded software, high-performance server and client applications, and entertainment software such as video games. C++ has greatly influenced many other popular programming languages, most notably Java. Furthermore, C and C++ ranked No. 2 and 3, respectively, on the most-recent TIOBE Index.” eweek.com (2012)“C is one of the most popular languages ever. It is used as a systems programming language and also for applications—such as embedded systems applications. It ranks as the second most popular language on the TIOBE Index. According to Simply Hired, since April 2009, C jobs increased 11 percent.” myitview.com (2012) “C++ was developed as an enhancement of the C language (also at Bell Labs, where C itself came from) and was initially known as “C with Classes.” It quickly became one of the most popular languages amongst developers. C++ is used for developing systems software, application software, device drivers, embedded software, high-performance server and client applications, and entertainment software such as video games. It ranks as No. 3 on the TIOBE Index. According to Simply Hired, since April 2009, C++ jobs decreased by 13 percent. However, because the pool of opportunities for C++ developers is so much greater than that for
“Like the BASIC programming language, Visual Basic was designed to be easily learned and used by beginner programmers. The language not only allows programmers to create simple GUI applications, but it can also be used to develop complex applications. Programming in VB is a combination of visually arranging components or controls on a form specifying attributes and actions of those components, and writing additional lines of code for more functionality. With ease of use as a selling point, Visual Basic caught on like wildfire. There is simply too much VB code out there to ignore this language in any list of 10 programming languages. Visual Basic ranked No. 5 on the most-recent TIOBE Index.” eweek.com (2012) “Visual Basic is the third-generation event-driven language and integrated development environment from Microsoft for its COM programming model. Microsoft designed VB to be relatively easy to learn and use, and it quickly became popular with developers, particularly those building departmental apps. VB ranks No. 7 on the TIOBE Index. According to Simply Hired, since April 2009, Visual Basic jobs increased 112 percent. VB is part of the Microsoft Visual Studio tool suite.”myitview.com (2012) PHP
“PHP is very popular for corporate applications and for Web design. If you
“If you want to make a lot of money, but probably also work on very intense high-pressure projects where risk is often involved—as in a lot can go wrong—learn Objective-C. Objective-C borrows from Smalltalk and the C language, and it influenced the creation of Java. Objective-C is used primarily on Apple’s Mac OS X and iOS. With the wild popularity of Apple’s iPhone, iPod Touch and iPad, there are simply not enough Objective-C developers out there to meet the needs of users hungry for more apps for these devices. Objective-C ranked No. 9 on the most-recent TIOBE survey, but that is up from being No. 45 in the survey in June of 2009.” eweek.com (2012) PERL
“Many say Perl is the new COBOL. Perl is also viewed as “the duct tape of the Internet” and is used to integrate databases and other systems together. While demand for the dynamic or scripting languages such as Perl, Python, PHP and Ruby lags behind that of Java and more mainstream languages, the popularity of these languages is growing and there is a need for programmers in each of those communities. However, according to Indeed.com, the demand for Perl programmers is tracking higher than that for PHP, Python and Ruby developers, in that order. Perl was ranked No. 8 on the most-recent TIOBE Index.” eweek.com (2012) “Perl is a high-level, general-purpose, interpreted, dynamic language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Perl ranks No. 9 on the TIOBE Index. According to Simply
Hired, since April 2009, Perl jobs increased 33 percent.”myitview.com (2012) PYTHON
“Want to work on the leading edge and build applications for the cloud? Dynamic languages, especially Python, are being used to create Web/cloud applications on frameworks such as Django. Google App Engine is built with Python and originally only supported Python. The advantage of Perl and Python over PHP among the dynamic languages is that while PHP is a Web-only, server-side language, Perl and Python are both general purpose languages with usage in multiple industries, from aerospace and defense to sciences and to financial to hi-tech. Python was ranked No. 7 on the most-recent TIOBE Index.” eweek.com (2012) “Python is a dynamic language that is used in a wide variety of application domains. Python is often compared to Tcl, Perl, Ruby, Scheme and Java. It enables developers to write code quickly. Python ranks No. 6 on the TIOBE Index. According to Simply Hired, since April 2009 Python jobs increased 69 percent.”myitview.com (2012) RUBY
“Ruby is a language of careful balance. Its creator, Yukihiro “Matz” Matsumoto blended parts of his favorite languages (Perl, Smalltalk, Eiffel, Ada and Lisp) to form a new language that balanced functional programming with imperative programming. The popular Ruby on Rails framework has helped to promote the use of Ruby. Since its public release in 1995, Ruby has drawn devoted coders worldwide. In 2006, Ruby achieved mass acceptance. Active user groups have formed in the world’s major cities and Ruby-related conferences are filled to capacity. Ruby is used for building Web apps, simulations, 3D modeling, business apps, robotics, networking, telephony and system administration systems among other uses. Companies such as Engine Yard, Heroku and New Relic provide Ruby with cloud hosting and developer tools support. And demand for Ruby developers is strong. As Yehuda Katz, a core Ruby on Rails contributor and an architect at Engine Yard said at RailsConf 2010: “I don’t know any Ruby developers who are unemployed.”” eweek.com (2012)“Ruby is a dynamic, open-source language with a focus on simplicity and productivity. It has an elegant syntax that is natural to read and easy to write. Ruby is catching on in the enterprise given the recent acquisition of Heroku, a Ruby and Rails app hosting/cloud service
provider, by Salesforce.com. Ruby is No. 11 on the TIOBE Index. According to Simply Hired, since April 2009, Ruby jobs increased 78 percent.” myitview.com (2012)S
Review of Related Literature (Local and Foreign)
Hotel Reservation and Billing System (HRBS)
Authors: RebeccaAkello ,RichardBalemwa, BrianBuggah,DenisHalonda,KamalizaEnock , Anita Gatare , JosephKigula,BenonKubanja,andMunduruBabraKyomuhendo Source: http://dspace.mak.ac.ug/handle/123456789/1130
Date: March 9, 2012
to run on client server architecture. The system will be accessed via a browser with two views, the primary view from where clients will be able to browse through the website. The second view will be accessed via a login form on the home page of the website. The adoption of this system would be valuable to hotel practitioners since such a system can help handle the ever increasing volumes of information. Additional functionalities can be incorporated which include virtual tours, security controls, and on line payment services.
658 Apartelle Online Reservation System
Source:http://www.oppapers.com/essays/658-Apartelle-Online-Reservation-System/375787 Date: July 15, 2011
Short term base lodging is the main reason that a hotel has been established. In the Philippines, wherein many foreign people go and have a vacation, hotel is always their first destination to have relaxation after long hours of travel in an airplane. Because of the rapid increase of foreigners visiting the Philippines for a vacation, a common sight is the establishments ad sophisticated hotels for competitive advantage. As the result of the competition between different hotels, various business strategies had been made to attract customers, such as putting discounts, having beautiful and relaxing environment and above all having a state of the art computer system and facilities. The current problem observed is the manual guest list records; the manual reservation of guests, the manual booking of rooms for the guests takes a long time to accomplish. According to the manager in the establishment, because they keep on doing their job manually, it resulted to a very messy office, lots of papers around the desks and sometimes important documents disappear. From the information gathered, the proponents came up with an idea of proposing a system that is relevant to the needs of the establishment, highly efficient to meet their needs and most of all simple, easy to use system. The 658 Apartelle Online Reservation Management System is not only a database for guest list but also an online reservation system, where potential guest can have online reservation which will automatically be sent to the database of the 658
Apartelle. Based on the proponent’s observation and interview, they have found many problems such as time consuming logging of the guest list names to the log book, difficulties in making reservations and difficulties in retrieving information on their previous guests because of the papers that are scattered everywhere and misplacing of the guestless records.
MC Mountain Home Apartelle Launches Online Reservation System on Website Source: http://www.pressreleasepoint.com/mc-mountain-home-apartelle-launches-online-reservation-system-website Date: July 15, 2011
Summary: MC Mountain Home Apartelle provides guests with a convenient way of booking rooms at the hotel by integrating a reservation system on its website. Tagaytay, Cavite, Philippines – Reserving accommodations at MC Mountain Home Apartelle in Tagaytay, Philippines has just gotten easier and faster with the integration of a new reservation system on the hotel’s official website. By simply going online, guests can now book the room of their choice in a matter of minutes. Through the new service, guests need only click on the Reserve Now button on the Tagaytay hotel’s website to view room rates, features and availability over a 14-day period. Upon specifying their chosen rooms and duration of stay, guests will get instant confirmation of their reservation via email immediately after paying the required 10% deposit using WorldPay. The secure system makes the process of booking accommodations at the hotel safer and more convenient for guests. Located along the Tagaytay-Nasugbu Highway in Cavite Province, MC Mountain Home Apartelle is only a few hours away from Manila, making it an ideal impromptu vacation getawayfor families or groups. Some popular attractions near the hotel include the Taal Volcano and Lake, Sonya’s Garden, Calaruega Chapel, Chapel on the Hill, SplendidoTaal Golf, and the Royale Tagaytay Country Club, to name a few. The hotel provides guests with cozy yet affordable Tagaytay accommodations that overlook the scenic Taal Lake. Each room comes complete with air-conditioning, television, deck/balcony, and private toilet and bath with shower. Breakfast is served daily and is
already included in the room rates. Other features of the hotel in Tagaytay include the MC Mountain Restaurant which serves a delicious array of dishes, a multipurpose hall, high-speed Internet at the common areas of the hotel, dry cleaning and laundry services, and room service. Holiday Bookings Online
Date: July 19, 2011
Time: 5:21 am
© Copyright 2010 Holiday Bookings Online Ltd.
Whether you have a cottage, villa or apartment management of your holiday lettings is simple using Holiday-Bookings-Online. Customers can check availability, make a reservation and receive confirmation – at any hour of the day or night. This gives your business the opportunity to take secure bookings 24/7 from around the world. Holiday-Bookings-Online professional holiday accommodation rental software has helped some owners increase occupancy levels to over 90%. This cost effective booking software is suitable for property owners with a single cottage, villa or apartment through to agencies with multiple properties. Not only does the online booking system help generate more bookings for owners; it also makes the management of your bookings easier. Management of your tariffs, invoices, booking preferences, deposits and reports is simple via the online admin control panel. The booking software allows you to take secure payments online via PayPal or a merchant account as well as via bank transfer or cheque. The online booking system includes not just an online booking calendar but also a sophisticated availability search facility which is useful for accommodation owners and agents with lots of rental properties. It also includes a special offers page, enquiry page and rental tariffs page – essential tools for a successful accommodation provider.
Hotel Online Booking System
Date: July 19, 2011
Time: 5:45 am
©2006-2011 Hotels Online International Ltd. All rights reserved
The Hotels Online Booking System is an easy to use, web-based internet reservation system used internationally by a diverse range of accommodation providers including Holiday Villas, Guest Houses, Bed & Breakfasts, Self-Catering Apartments, Independent Hotels & Hotel Chains, Tourist Boards, Travel Agents & Travel Companies. The HOL online booking system is reliable, fast-loading and most importantly very user-friendly requiring very little training or times to get your hotel or guest house online and taking reservations! Smaller hotel groups and individual guest houses utilizing the Hotels Online reservation system gain the same online reservation potential as the major hotel chains/groups – but for a mere fraction of the cost! Our hotel room reservation system currently facilitates hundreds of online hotel reservations each day on behalf of our client accommodation providers. The Hotels Online hotel booking system offers a very cost-effective online marketing solution for your hotel, guest house or self-catering accommodation. Hotel Management System for StayInn
Source: http://sst.unisim.edu.sg:8080/dspace/handle/123456789/128 Authors: Su, Ze Cong
Issue Date: 2009
Date: July 23, 2011
Time: 10:44 pm
StayInn hotel aims to put the hotel in control of its internet presence and exposure as it is the shortest path to establishing interactive relationship with customers. The hotel wishes to eliminate the current cumbersome and inefficient operations like processing of payment, generating reports which involve manual work and lot of paperwork so that it not only increase the efficiency of its staffs but also helps the company in cost cutting. The thesis describes the design and development of a web-based hotel management system. The finding and methodology use to develop the system. Investigating and exploring ways to ensure high performance, reliability and identifying potential data integrity problem which might arise due to high volume booking rate during holiday peaks. Security control and features also include setting the database privileges and user’s access rights to protect
the system against threats from the interne. The outcome of the project was a success as it complied with the client specification. The functionalities of the final system were able to reduce the processing time and the amount of paperwork needed. Key statistics reports generation were automated, coupled with high level of data accuracy to facilitate the planning of its marketing strategy based on the trends identified in the report. The content management functionality in the system allows staffs to create news and promotions onto the website to raise awareness and publicity. EHOTEL RESERVATION SYSTEM
Source: http://sst.unisim.edu.sg:8080/dspace/handle/123456789/593 Authors: CHONG, MAY KWAN
Issue Date: May-2011
Date: July 23, 2011
Time: 11:01 pm
The main objective of this project is to create an EHotel Reservation System with basic functions to handle room reservations more efficiently. The benefits are not only customers can book room reservation conveniently online, the hotel can also keep track of customer’s records in a more trouble freeway. This document seeks to present the details of work and milestones in the development of EHotel Reservation System for “4 * Hotel”. A list of proposed system scopes has been designed & developed to suit the primary objective of this project. The Web interface is designed using Dream weaver, coded with PHP, integrating with MS SQL, which is chosen to develop the database part of “4 * Hotel”. The general feature of the EHotel Reservation system will be user-friendly with basic reservation functions like checking room’s availability, create room reservations, generating reservation IDs, triggering auto email confirmation to customers upon successful reservation etc. Besides having the basic reservation functions, member’s reward program is also created to give value add in this project. With all the goals in mind, the project has established strategic objectives and deliverables to ensure smooth operation of the project till completion. This report captures the appropriate information for analysis, design and development of this project. Note that the term “Customer” in this context
will represent the hotel customer, who will be the actual individuals interacting with the EHotel Reservation system and “Client” in this context represent the “owner”, who identify the business needs. Lastly, this report will conclude with recommendations for future work, as well as screenshot of the final Website.
a. Entity Relationship Diagram
b. Use Case Model
Figure 3.3.1Use Case Diagramlogging in
The diagram shows the interaction or the process of login by the user of the system. The user is required to input the username and password to be able to login and redirected to the main form of the system. If the user fails to provide the correct username or password, the system will prompt an error and redirect the user back to the login form.
Figure 3.3.2Use Case DiagramAdding User Accounts
The administrator is the actor of diagram. Information is required for the user that will be added and it will be inputted by the administrator. After filling up the necessary information, the administrator can then save the new user to the database and the system will prompt when the New User was successfully added or not.
Figure 3.3.3Use Case DiagramEditing User Accounts
The administrator is the actor of diagram. User accounts can be edited by the administrator only. The administrator can select the user account that will be edited and input information that will replace the old record. The administrator can then save the changes made to user accounts and the system will prompt if the changes were successful or failed.
Figure 3.3.4Use Case DiagramAdding, Editing, Deleting Products
There are two possible users that can access the function of add, edit, and