• No results found

reservation

N/A
N/A
Protected

Academic year: 2021

Share "reservation"

Copied!
100
0
0

Loading.... (view fulltext now)

Full text

(1)

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

LIGAYA VILLAGE

LIGAYA VILLAGE

A Thesis Project A Thesis Project Presented to Presented to The faculty of STI College

The faculty of STI College –  – San FernandoSan Fernando

In Partial Fulfillment In Partial Fulfillment

of the Requirements of the Degree of  of the Requirements of the Degree of  Bachelor of Science in Information Technology Bachelor of Science in Information Technology

by: by:

Dizon, Anna Paula L. Dizon, Anna Paula L. Espiritu, Marianne R. Espiritu, Marianne R.

Roque, Yngwee L. Roque, Yngwee L. Santos, John Andrew A. Santos, John Andrew A.

Mr. Rheyson Leary Mr. Rheyson Leary Thesis Adviser Thesis Adviser February 2009 February 2009

(2)

ADVISER’S

ADVISER’S RECOMMENDA

RECOMMENDATION

TION SHEET

SHEET

This Thesis entitled This Thesis entitled

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

LIGAYA VILLAGE

LIGAYA VILLAGE

by: by:

Dizon, Anna Paula L. Dizon, Anna Paula L. Espiritu, Marianne R. Espiritu, Marianne R.

Roque, Yngwee L. Roque, Yngwee L. Santos, John Andrew A. Santos, John Andrew A.

Submitted in partial fulfillment of the requirements of the Submitted in partial fulfillment of the requirements of the Bachelor of Science In Information Technology degree Bachelor of Science In Information Technology degree

has been examined and is hereby recommended has been examined and is hereby recommended

for acceptance and approval for acceptance and approval

Mr. Rheyson Leary Mr. Rheyson Leary Thesis Adviser Thesis Adviser February 2009 February 2009

(3)

ADVISER’S

ADVISER’S RECOMMENDA

RECOMMENDATION

TION SHEET

SHEET

This Thesis entitled This Thesis entitled

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

LIGAYA VILLAGE

LIGAYA VILLAGE

by: by:

Dizon, Anna Paula L. Dizon, Anna Paula L. Espiritu, Marianne R. Espiritu, Marianne R.

Roque, Yngwee L. Roque, Yngwee L. Santos, John Andrew A. Santos, John Andrew A.

Submitted in partial fulfillment of the requirements of the Submitted in partial fulfillment of the requirements of the Bachelor of Science In Information Technology degree Bachelor of Science In Information Technology degree

has been examined and is hereby recommended has been examined and is hereby recommended

for acceptance and approval for acceptance and approval

Mr. Rheyson Leary Mr. Rheyson Leary Thesis Adviser Thesis Adviser February 2009 February 2009

(4)

THESIS COORDINATOR AND DEAN’S ACCEPTANCE SHEET

THESIS COORDINATOR AND DEAN’S ACCEPTANCE SHEET

This Thesis entitled This Thesis entitled

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

LIGAYA VILLAGE

LIGAYA VILLAGE

After having been recommended and approved is hereby accepted After having been recommended and approved is hereby accepted

by the Information technology Department by the Information technology Department

Of STI College

Of STI College –  – San FernandoSan Fernando

_____________________ _____________________

Ms. Fides C. Arceo Ms. Fides C. Arceo Thesis Coordinator/ Dean Thesis Coordinator/ Dean

February 2009 February 2009

(5)

PANEL’S APPROVAL SHEET

This thesis entitled

AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR

LIGAYA VILLAGE

developed by:

Dizon, Anna Paula L. Espiritu, Marianne R.

Roque, Yngwee L. Santos, John Andrew A.

After having been presented is hereby approved by the following members of the panel

Mr. Louie A. Ruiz Ms. Fides Celeste C. Arceo

Panelist 1 Panelist 2

Dr. Darwin Jaime Lead Panelist

(6)

TABLE OF CONTENTS

Chapter 1 INTRODUCTION

1.1 Statement of the Problem 1-2

1.2 Current State of the Technology 1-4

1.3 Objectives 1-8

1.3.1 General Objective 1-8

1.3.2 Specific Objective 1-9

1.3.3 Scope and Limitations 1-11

Chapter 2 THEORETICAL FRAMEWORK

2.1 Introduction 2-1

2.2 Internet 2-1

2.3 Website 2-2

2.4 World Wide Web 2-2

2.5 Hypertext Transfer Protocol 2-3

2.6 Client and Server 2-3

2.7 Information System 2-4

2.8 Graphical User Interface 2-4

2.9 Database Management System 2-5

2.9.1 Database Normalization 2-5

2.9.2 Relational Database 2-7

2.10 Fourth Generation Techniques 2-8

(7)

Chapter 3 AN ONLINE INFORMATION SYSTEM WITH RESERVATION FOR LIGAYA VILLAGE

3.1 Introduction 3-1

3.2 System Design Specification 3-1

3.2.1 Software Components 3-1 3.2.1.1 Front End 3-1 3.2.1.2 Back End 3-3 3.2.2 Hardware Components 3-5 3.2.2.1 Server 3-5 3.2.2.2 Client 3-6 3.2.3 Context Diagram 3-7

3.2.3.1 Context Diagram of the Current System 3-7

3.2.3.2 Context Diagram of the Proposed System 3-8

3.2.3.3 Data Flow Diagram 3-9

3.2.3.3.4 DFD of the Current System 3-9

3.2.3.3.4 DFD of the Proposed System 3-10

3.2.3.6 Entity Relationship Diagram 3-11

3.2.3.7 Hierarchical Input Process Output 3-12

3.3 Summary 3-18

Chapter 4 PERFORMANCE ANALYSIS

4.1 Introduction 4-1

4.2 Experimental 4-1

(8)

4.2.2 Example of an Evaluation Tally 4-5

4.3 Results and Analysis 4-6

4.4 Summary 4-6 Chapter 5 CONCLUSION 5-1 BIBLIOGRAPHY ACKNOWLEDGEMENT APPENDICES Appendix A (Certifications)

Appendix B (Transcript of interviews) Appendix C (Project Scheduling)

Appendix D (Sample forms and Report) Appendix E (Personal Vitae)

(9)

Abstract

The Online Information System with Reservation for Ligaya Village aims to lessen the time consumed in processing reservation, lessen paper works and reduce transaction costs. To achieve the objectives of the system, the proponents had designed and developed different modules that comprise the whole online system.

Currently, Ligaya Village uses a manual system in all the transactions such as inquiry, tripping, registration, assessment, reservation, cancellation of reservation and payment. All this processes are time consuming that usually caused inconvenience in the part of the customer as it means that a prospective buyer must wait if ever someone had comes first on the office. For people who live far away from the village, they will have hard time in inquiring about the village.

The proponents upon analyzing the trend of the business concluded that technology could contribute to the productivity of the business especially in the reservation process to its customer and some transactions inside the business.

(10)

Preface

Currently, Ligaya Village uses a manual system in all the of the business processes particularly in reservation, promotion or advertisement and inquiry. Customers who are interested in buying lot or house and lot are required to go to the main office of  Ligaya Village in order to inquire and acquire reservation.

The promotions and advertisement of the company is needed to be enhanced to gain and attract more customers. Online Information system with reservation will help Ligaya Village in the improvement and enhancement of the current system used by the said village and makes it easier for the customers to acquire information and speed up the reservation process. In addition, the online system will allow the reservation available for the customers anytime of the day.

Many individuals will benefit in developing the said system. The company, employees and most of all the clients because it will give more convenient means of  acquiring information at a time that it is suited. Furthermore, some people such as the proponents, future thesis students and researchers would also gain benefit upon the completion of the proposed system.

The proponents’ knowledge will be tested, enhanced and developed at the same time. All the knowledge acquired during the entire college years will now be used in this thesis project. This project can be used as a reference for the future thesis students to gain knowledge. Through the various chapters of the document, the readers will see the clarity and accuracy on how the thesis project was developed. This document includes the Chapter 1 that contains the introduction, statement of the problem, current state of the

(11)

technology, objectives of the study, project scope and limitations. The Chapter 2 discussed all the theories that were studied and applied by the proponents to the proposed system. The Chapter 3 discussed about the system design specification wherein all the system requirements were stated. The Chapter 4 discussed about the performance analysis wherein it provides a list of experiments conducted by the group. Lastly, the Chapter 5 which is the conclusion that contains the summary of the problem, the proposed system, the major results of the performance analysis and the recommendation for the further works.

(12)

Chapter 1 Introduction

An information system (IS) is the system of persons, data records and activities that process the data and information in a given organization, including manual processes or automated processes. Usually the term is used erroneously as a synonym for computer based information systems, which is only the Information technologies component of an information system. The computer-based information systems are the field of study for Information Technologies (IT); however these should hardly be treated apart from the bigger information system that they are always involved in [WIKI2007].

World Wide Web (WWW) is an international, archival, peer-reviewed  journal that covers all aspects of the Web, including issues related to architectures, applications, Internet and Web information systems, and communities. It provides in-depth coverage of the most recent developments in the Web, enabling readers to keep up-to-date with this dynamically changing technology. The journal also focuses on all database- and information-system topics that relate to the Internet and the Web, particularly on ways to model, design, develop, integrate, and manage these systems [WIKI2007].

The Internet is a worldwide, publicly accessible series of interconnected computer networks that transmit data by packet switching using the standard Internet Protocol (IP). It is a "network of networks" that consists of millions of  smaller domestic, academic, business, and government networks, which together carry various information and services, such as electronic mail, online

(13)

chat,

chat, filefile transfer, and the interlinked web pages and other resources of thetransfer, and the interlinked web pages and other resources of the World Wide Web

World Wide Web (WWW) [WIKI2007].(WWW) [WIKI2007].

 Real

 Real estateestate is a legal term that encompasses land along with anythingis a legal term that encompasses land along with anything permanently affixed to the land, such as buildings. Real estate is often permanently affixed to the land, such as buildings. Real estate is often considered synonymous with real property, in contrast with personal property. considered synonymous with real property, in contrast with personal property. However, in some situations the term ―real estate‖ refers to the land and fixtures However, in some situations the term ―real estate‖ refers to the land and fixtures together, as distinguished from ―real property,‖ referring to ownership rights of  together, as distinguished from ―real property,‖ referring to ownership rights of  the land itself [WIKI2007].

the land itself [WIKI2007].

1.1

1.1 Statement of the ProblemStatement of the Problem

Ligaya Village is currently using a manual system in its daily Ligaya Village is currently using a manual system in its daily transactions.

transactions.

The said Village is having difficulties in terms of advertising and giving The said Village is having difficulties in terms of advertising and giving information to people who are interested in buying lots or house and lot. information to people who are interested in buying lots or house and lot. Since the company lacks ways of presenting advertisements to its Since the company lacks ways of presenting advertisements to its customers, the company does not benefit much in this strategy.

customers, the company does not benefit much in this strategy.

Ligaya Village’s advertisements are handled through the use of  Ligaya Village’s advertisements are handled through the use of  posters and flyers.

posters and flyers. This method is This method is costly and its costly and its purpose to attract purpose to attract moremore customers is less effective. Due to the poor display and advertising of  customers is less effective. Due to the poor display and advertising of  information regarding their houses and lots, the clients cannot obtain information regarding their houses and lots, the clients cannot obtain sufficient information about the company.

(14)

The scope of advertising is also limited because the staff are only The scope of advertising is also limited because the staff are only located in Pampanga. Ligaya Village aims to have foreign customers or located in Pampanga. Ligaya Village aims to have foreign customers or Overseas Filipino Workers (OFWs) planning to reside to the Philippines. Overseas Filipino Workers (OFWs) planning to reside to the Philippines.

The present reservation process takes a lot of time and effort for The present reservation process takes a lot of time and effort for the customer. The manual reservation requires the customer to fill-out the customer. The manual reservation requires the customer to fill-out forms which is inconvenient for some customers that are located far from forms which is inconvenient for some customers that are located far from Ligaya Village and especially to those customers who have very busy Ligaya Village and especially to those customers who have very busy schedules.

schedules.

Customer and employee records of Ligaya Village as well as its Customer and employee records of Ligaya Village as well as its business related transactions are written on papers and forms. These are business related transactions are written on papers and forms. These are clipped inside a folder and stored on a filing cabinet. Retrieving such clipped inside a folder and stored on a filing cabinet. Retrieving such records cannot immediately be done because an employee must manually records cannot immediately be done because an employee must manually scan the folders to look for the date he is trying to look for. Also, the use scan the folders to look for the date he is trying to look for. Also, the use of the current system provides a hard time in accessing records about the of the current system provides a hard time in accessing records about the customer and employee.

customer and employee.

The company uses forms in recording business transactions and The company uses forms in recording business transactions and profiles of customers. These

profiles of customers. These records can be records can be misplaced or misplaced or lost and lost and take atake a lot of time to view a specific file if not properly kept and maintained. lot of time to view a specific file if not properly kept and maintained. These records could also be viewed by anyone because of the lack of  These records could also be viewed by anyone because of the lack of  security of the files.

(15)

A question came up with the proponents after analyzing all the A question came up with the proponents after analyzing all the transactions involved in the business that is

transactions involved in the business that is “how to design, develop and“how to design, develop and implement an Online Information System with Reservation for Ligaya implement an Online Information System with Reservation for Ligaya Village that will be a useful tool for the total computerization of all Village that will be a useful tool for the total computerization of all

business-business-related transaction in the company.”related transaction in the company.” 1.2

1.2 Current State of the TechnologyCurrent State of the Technology Brief History of the Company Brief History of the Company

Ligaya Village is located right in the heart of Pampanga's urban Ligaya Village is located right in the heart of Pampanga's urban development and Accessible just minutes away from bustling commercial development and Accessible just minutes away from bustling commercial places like SM Pampanga and Robinson's Mall. It was opened last April places like SM Pampanga and Robinson's Mall. It was opened last April 2003 at San Antonio Mexico, Pampanga.

2003 at San Antonio Mexico, Pampanga.

The village was named after Mrs. Ligaya Nucup, the wife of Mr. The village was named after Mrs. Ligaya Nucup, the wife of Mr. Oscar Nucup who initially invested the business and who also owns Owen Oscar Nucup who initially invested the business and who also owns Owen and Son’s Pawnshop, Owen and Son’s purified water, and Owen and and Son’s Pawnshop, Owen and Son’s purified water, and Owen and Son’s motors and services in Mexico, Pampanga. But the village is being Son’s motors and services in Mexico, Pampanga. But the village is being maintained and managed by NESLAN Realty and Development maintained and managed by NESLAN Realty and Development Corporation composes of Mr. Nestor Sotto as the president, Dra. Maria Corporation composes of Mr. Nestor Sotto as the president, Dra. Maria Luz Pangilinan

Luz Pangilinan  –  –  the Vice President for Sales and Marketing, andthe Vice President for Sales and Marketing, and Architect Allan M. Pangilinan as the developer.

Architect Allan M. Pangilinan as the developer.

The village has a total land area of 50,000 square meters; the The village has a total land area of 50,000 square meters; the biggest lot is 430 square meters while the smallest is 150 square meters. biggest lot is 430 square meters while the smallest is 150 square meters. At present, almost 50% of lots were already sold. A square meter costs At present, almost 50% of lots were already sold. A square meter costs from P4, 300.00 up to P4, 500.00. The said village has one clubhouse and from P4, 300.00 up to P4, 500.00. The said village has one clubhouse and

(16)

two mini pools. The company currently implements two mode of  payments  –  cash and installment. A 5% discount will be given to those who will make full payments.

Currently, Ligaya Village uses a manual system in all the transactions such as inquiry, tripping, registration, reservation, assessment, cancellation of reservation and payment.

On the inquiry process, a customer must personally visit the office of Ligaya Village. There, a front desk clerk will entertain all of the customer’s questions and inquiries about the village and its reservation process, rules, and cost.

After inquiring, if the customer is interested in having business with Ligaya Village, the Marketing Assistant will tour the said customer to the entire village and choose the lot and its location that he desires.

The current registration requires filling out Prospective Buyers Registration (PBR) and Reservation Application forms. Along with those forms, are the documents that need to be submitted such as valid ID, photocopy of marriage contract (if married) or birth certificate, two pieces 2x2 picture, community tax, proof of billing, and post dated check for equity and amortization, which will be given by the customer to the front desk clerk.

On the assessment, the finance officer will ask the customer if he will pay the lot in cash or installment basis. From it, the finance officer

(17)

will break down all of the charges a customer must pay. An assessment slip will be given to a prospective buyer before payment process starts.

A customer must register prior to reservation. After doing so, the customer should pay an initial amount of twenty thousand pesos (P20,0000.00) as the reservation fee. An agreement then will be done between the company and the prospective buyer. Included in this agreement is the Deed of Restrictions. Failure on the part of the customer to submit the necessary document and payment during such time gives the management the right to automatically cancel the reservation without the need of notice.

Aside from the above mentioned cancellation, customer themselves can voluntarily cancel the reservation. Required forms must be filled out as a proof of cancelling the reservation made and for legality purposes as well. The reservation fee then will not be given back to the customer because it is strictly non-refundable.

Payments are made directly to Ligaya Village office. Before the payment, the customer is given an assessment slip from the respective account officer. Down payments are covered by postdated checks. The Total Contract Price (TCP) together with the breakdown of payments and its corresponding schedule detailed in the quotation sheet.

With regard to the marketing and advertisement of the company, it only uses posters and flyers which are usually expensive. The village hires

(18)

sales representative to distribute those flyers at public places such as malls and markets.

All this processes are time consuming that usually cause inconvenience in the part of the customer as the prospective buyer must wait if ever someone comes first on the office. Customers who also live far away from the village will also have a hard time in inquiring about the village.

We visited some websites about real estate subdivisions that could help us and give additional ideas to enhance the proposed website of  Ligaya Village.

Amber Trail (http://thenorthgaterealty.com) is located at San Pablo Mexico, Pampanga. This website includes a web inquiry in which the client can inquire regarding the house and lot. They also have a gallery of houses in which the client can choose his/her desired house.

Lakeshore (http://lakeshore.com.ph) is a world-class residential commercial and recreational development project of Central Country Estate Incorporated, located at Kilometer 71 of the North Luzon Expressway, Mexico, Pampanga. This website has a map in which the client can know where it is exactly located. In their map also includes the list of available lots, development photos and the pricelist.

Bahay.ph (http://bahay.ph/ph/) is the first world-class FREE on-line Philippine Housing & Real Property Super Trade Show. It provides a virtual mega-trade fair where real estate brokers & agents can exhibit their

(19)

inventories; and investors, buyers, or property searchers can avail of a wide choice of quality homes and all kinds of real property in various locations throughout the Philippines. The website has a FAQ menu or the Frequently Ask Question where in you can check all the frequently ask  questions and with their corresponding answers.

1.3 Objectives

1.3.1 General Objective

The proponents aim to design, develop and implement an online information system with reservation for Ligaya Village that will be a useful tool for the total computerization of all business-related   transaction in the company.

This will give information and allow reservations for the clients on the internet. Hence, the system will also enhance the marketing of  the company and widening its scope of advertisement where the company could benefit much. Thus, the company will attract more prospective buyers that will lead to a more successful business.

1.3.2 Specific Objectives

To develop a module that will display detailed information  about Ligaya Village.

The proponents will develop module that will display different kinds of information regarding Ligaya Village. A specific module will display information about

(20)

houses and lots such as the total area, prices and internal perspectives. Online information regarding the mode of  payments will be made available for the browser. Contact Us form will be provided where in customers can find information on how to reach the company, such information as telephone number, email and business address. Deed of restrictions will also be available so that the customers are aware about the rules and regulations of  the company. The vicinity map will help the customer to know the exact location of Ligaya Village. Furthermore, the module will also display the company’s background and the list of the company’s staff. Contact details of  selected staff will be presented to give customers the opportunity to ask them about their line of work. Thus, this will raise the credibility and trust of the customer to the company. It will also give the customer an idea on who to ask for if they have specific inquiries about the company.

To develop a module that will allow online reservation  and cancellation of reservation for the client.

The proponents will develop a module for online reservation to speed up the reservation process. This will allow the reservation for the client available at anytime of  the day. It will also provide another choice for the client on

(21)

how to make reservation if the customer does not have time to go in the office when filling out forms. The system allows cancellation of reservation but the reservation fee is non refundable, this is in accordance with the policy of the company with regard to cancellation of reservation.

To develop an online database for storing records and   keeping track of transactions.

The system will provide an online database that will be used for storing customers and employees records in the company and the company's transactions. When problems occur, like accidental deletion of records, data can still be recovered easily. A backup can also be made that can be restored to a later time if needed.

To design, develop and implement a module that will  increase the security and accessibility of the company’s  files.

The proponents will develop a module that will record, monitor, update and secure transactions and customer profiles. This module will allow easy and secure access of files. The maintenance of records will also be easier and uncomplicated to manage.

(22)

1.3.3 Scope and Limitations

The proponents will develop a website that will improve the daily business transactions of Ligaya Village in order to provide a better service to the customers and to the company itself.

The Scopes of the study:

 Front end

An online reservation module that will allow customers to make reservations of the lots on the web.

An online registration module that will allow customers to make a registration online.

A gallery to show the different kinds of houses and its internal perspectives.

A search module which will allow clients to search for their desired lots.

A Frequently Asked Questions (FAQ) menu where the client can check all the frequently ask questions with the corresponding answers.

Feedback and complaints module where in the system accepts positive feedback and supports your right to complain.

(23)

 Downloadable forms that are the same as the ones shown in the website for client registration and reservation.

 A cancellation of reservation where the customer can cancel the reservation within 30 days.

 Mode of payment guideline that will allow clients to know all the payment procedures when it comes to reservation, down payment, terms of payment, monthly payment and discounts.

 Deed of restrictions is a written agreement that restricts, or limit, the use or activities that may take place on property in a subdivision.

Contact Us form will be provided where in customers can find information on how to reach the company, such information as telephone number, email and business address.

Company profile where you can find the history of the company.

A pricelist of lots and house and lot. A site mapis a list of pages on a web site.

A site development plan shows an overview of all the available, reserved and sold lots.

(24)

A vicinity map where the client will be able to know the exact location of Ligaya Village.

A virtual tour where the customer can view the internal perspective of the house.

 Back end

An administrator backend wherein the administrator can manage the contents of the website online.

 Level of access will be implemented to improve the security of files and maintain customers’ privacy.

A search module which will allow clients to search for their desired houses or lots.

The Limitations of the study:

Clients will not be able to make online payments of any transaction in the company. They are still required to be present in the office for payments.

The company does not accept credit cards. Only cash and checks.

Search terms are only limited to the information of lots. Giving and printing of land titles to the customers will not be generated by the system.

The payment module only covers the payment for the reservation fee.

(25)

Chapter 2 THEORETICAL FRAMEWORK 2.1 Introduction

This chapter contains theories that are adopted by the proponents in developing the system. These theories contributed for the development of  the system. The proponents will look for solution that leads to the design of  the system and sources significant to the study.

2.2 Internet

The Internet, or simply the Net, is the publicly available worldwide system of interconnected computer networks that transmit data by packet switching using a standardized Internet Protocol (IP) and many other protocols. It is made up of thousands of smaller commercial, academic, domestic and government networks. It carries various information and services, such as electronic mail, online chat and the interlinked web pages and other documents of the World Wide Web [WIKI2007].

Internet is a computer-based global information system. It is composed of many interconnected computer networks. Each network may link tens, hundreds, or even thousands of computers, enabling them to share information and processing power. The Internet has made it possible for people all over the world to communicate with one another effectively and inexpensively. Unlike traditional broadcasting media, such as radio and television, the Internet does not have a centralized distribution system. Instead, an individual who has Internet access can communicate directly with anyone else on the Internet, post information for general consumption,

(26)

retrieve information, use distant applications and services, or buy and sell products. [WIKI2007]

Upon the completion of the system, it will be uploaded on the Internet. For this, the proponents were able to know some concepts in the internet such as uploading a system.

2.3 Website

Web Site is a file of information located on a server connected to the World Wide Web (WWW). The WWW is a set of protocols and software that allows the global computer network called the Internet to display multimedia documents. Web sites may include text, photographs, illustrations, video, music, or computer programs. They also often include links to other sites in the form of hypertext, highlighted or colored text that the user can click on with their mouse, instructing their computer to jump to the new site [WIKI2007].

2.4 World Wide Web (WWW)

World Wide Web (WWW), computer-based network of information resources that combines text and multimedia. The information on the World Wide Web can be accessed and searched through the Internet, a global computer network. The World Wide Web is often referred to simply as ―the Web‖ [ENCA2005].

The proponents used the web in uploading web pages to the Internet. The web is also use in accessing web pages from the server.

(27)

2.5 Hypertext Transfer Protocol (HTTP)

This is the protocol used to transfer data over the World Wide Web. That is why all Websites addresses begin with "http://". Whenever you type a Uniform Resource Locator (URL) into your browser and press enter, your computer sends an HTTP request to the appropriate Web server. This is the protocol used to transmit Web pages and their graphics, video, news, sounds, etc. across the Internet [CANA2007].

The viewer’s computer browser can use this protocol in order to view the pages of the website. This is the most commonly used protocol nowadays.

2.6 Client and Server

Client Server is a common form of distributed system in which software is split between server tasks and client tasks. A client sends requests to a server, according to some protocol, asking for information or action, and the server responds [WASH2005].

The server makes resources available to computers acting as workstations on the network. The server is considered as the central part of the network because it provides access to hardware, software and other resources [ENCA2005].

A client is the requesting program or user in a client/server relationship. For example, the user of a Web browser is effectively making client requests for pages from servers all over the Web. Clients, on the

(28)

other hand are those computer that work and re ly on the server’s resources [ENCA2005].

The proponents used the concept of client/server architecture in the system. The website has a server that stores records and other information in the database that can be requested by the client.

2.7 Information System (IS)

It is an organized collection, storage, and presentation system of  data and other knowledge for decision-making, progress reporting and for planning and evaluation of programs. It can be either manual or computerized, or a combination of both [GLOS2006].

2.8 Graphical User Interface (GUI)

Graphical User Interface (GUI), in computer science, a display format that enables the user to choose commands, start programs, and see lists of files and other options by pointing to pictorial representations (icons) and lists of menu items on the screen. Choices can generally be activated either with the keyboard or with a mouse [ENCA2005]

One of the key factors that the proponents adopted during this study is the concept of Graphical User Interface. When the proponents say user friendly, it means that users can use the system easily without knowing further about it. All the forms and modules that will be used and viewed by the user must be easy to understand. Through this concept and design, the proponents will not based their study on the user’s knowledge about computers but rather on how they can adapt on the system.

(29)

2.9 Database Management System (DBMS) 2.9 Database Management System (DBMS)

Database Management System is a software system designed to Database Management System is a software system designed to store manages and facilitates access to database. It is used for defining, store manages and facilitates access to database. It is used for defining, constructing and manipulating databases for various applications. DBMS constructing and manipulating databases for various applications. DBMS may be general purpose (business application) or special purpose may be general purpose (business application) or special purpose (biological databases, geographic databases…). The function of the (biological databases, geographic databases…). The function of the DBMS is to control data redundancy, restrict unauthorized access, provide DBMS is to control data redundancy, restrict unauthorized access, provide multi-user interfaces, represent complex table relationships, enforce multi-user interfaces, represent complex table relationships, enforce integrity constraints and provide back-up and recovery [STIC2005].

integrity constraints and provide back-up and recovery [STIC2005].

Database is a collection of data organized for storage in a computer Database is a collection of data organized for storage in a computer memory and designed for easy access by authorized users. The data may memory and designed for easy access by authorized users. The data may be in the form of text, numbers, or encoded graphics. Databases are be in the form of text, numbers, or encoded graphics. Databases are usually manipulated using database software like MS Access and MySQL. usually manipulated using database software like MS Access and MySQL. Using these software, data can be added, deleted, updated or edited Using these software, data can be added, deleted, updated or edited [ENCA2005].

[ENCA2005].

The proponents used the concept of the Database Management The proponents used the concept of the Database Management System (DBMS) because the system manipulates records on the database. System (DBMS) because the system manipulates records on the database. All of the information that a user wants to view in the website will come All of the information that a user wants to view in the website will come from the database of the system.

from the database of the system.

2.9.1 Database Normalization 2.9.1 Database Normalization

Database Normalization is a process for assigning attributes to Database Normalization is a process for assigning attributes to entities. Normalization reduces data redundancies and, by extension, entities. Normalization reduces data redundancies and, by extension, helps eliminate the data anomalies that result from those redundancies. helps eliminate the data anomalies that result from those redundancies.

(30)

Normalization does not eliminate data redundancies; instead, it Normalization does not eliminate data redundancies; instead, it produces the controlled redundancy that let us link database tables produces the controlled redundancy that let us link database tables [CORO2000].

[CORO2000].

Normalization works through a series of stages called normal Normalization works through a series of stages called normal forms. The first three stages are described as first normal form (1NF), forms. The first three stages are described as first normal form (1NF), second normal form (2NF), and third normal form (3NF).

second normal form (2NF), and third normal form (3NF). 

 First Normal Form (1NF)First Normal Form (1NF)

The term first normal form describes the tabular format in which: The term first normal form describes the tabular format in which:

All the key attributes are defined. All the key attributes are defined.

There are no repeating groups in the table. In other words, each There are no repeating groups in the table. In other words, each row/column intersection can contain one and only one value, not a set row/column intersection can contain one and only one value, not a set of values.

of values.

All attributes are dependent on the primary key. All attributes are dependent on the primary key. 

 Second Normal Form (2NF)Second Normal Form (2NF)

A table is in the second normal form (2NF) if: A table is in the second normal form (2NF) if:

It is in first normal form (1NF). It is in first normal form (1NF).

It includes no partial dependencies; that is; no attribute is It includes no partial dependencies; that is; no attribute is dependent on only a portion of the primary key.

dependent on only a portion of the primary key. 

 Third Normal Form (3NF)Third Normal Form (3NF)

A table is said to be in the third normal form (3NF) if: A table is said to be in the third normal form (3NF) if:

It is in second normal form (2NF). It is in second normal form (2NF). It contains no transitive dependencies. It contains no transitive dependencies.

(31)

The proponents used the concept of the Database Normalization to The proponents used the concept of the Database Normalization to reduce the redundancy of records.

reduce the redundancy of records.

2.9.2 Relational Database 2.9.2 Relational Database

Relational Database is a type of database or database Relational Database is a type of database or database management system that stores information in tables

management system that stores information in tables —  — rows androws and columns of data

columns of data —  — and conducts searches by using data in specifiedand conducts searches by using data in specified columns of one table to find additional data in another table. In a columns of one table to find additional data in another table. In a relational database, the rows of a table represent records (collections of  relational database, the rows of a table represent records (collections of  information about separate items) and the columns represent fields information about separate items) and the columns represent fields (particular attributes of a record). In conducting searches, a relational (particular attributes of a record). In conducting searches, a relational database matches information from a field in one table with information database matches information from a field in one table with information in a corresponding field of another table to produce a third table that in a corresponding field of another table to produce a third table that combines requested data from both tables.

combines requested data from both tables.

For example, if one table contains the fields EMPLOYEE-ID, For example, if one table contains the fields EMPLOYEE-ID, LAST-NAME, FIRST-NAME, and HIRE-DATE, and another table LAST-NAME, FIRST-NAME, and HIRE-DATE, and another table contains the fields DEPT, EMPLOYEE-ID, and SALARY, a relational contains the fields DEPT, EMPLOYEE-ID, and SALARY, a relational database can match the EMPLOYEE-ID fields in the two tables to find database can match the EMPLOYEE-ID fields in the two tables to find such information as the names of all employees earning a certain salary such information as the names of all employees earning a certain salary or the departments of all employees hired after a certain date. In other or the departments of all employees hired after a certain date. In other words, a relational database uses matching values in two tables to relate words, a relational database uses matching values in two tables to relate information in one to information in the other. Microcomputer database information in one to information in the other. Microcomputer database products typically are relational databases [ENCA2005].

(32)

2.10 Fourth Generation Techniques

The term ―Fourth Generation Techniques‖ (4GT) encompasses a broad array of software tools that have one thing in common. Each enables the software engineer to specify some characteristics of  software at a high level. The tool then automatically generates source code based on the developer’s specification. The Fourth Generation Techniques for software Engineering focuses on the ability to specify software, using specialized language forms or a graphic notation that describes the problem to be solved in terms that the customer can understand. Requirements Gathering Design Strategy Implementation using 4GL Testing

(33)

The proponents decided to use 4GT because it is the methodology that fits their system.

The 4GT is a systematic approach to problem solving and is composed of several phases:

Requirements Gathering

The first stage in 4GT is the requirements gathering wherein the proponents gather all the information needed to support the accomplishment of their system. Gathering of information usually comprises of different methods such as interview with some of the people involved in the business, survey forms, and questionnaires.

Design Strategy

This is the stage wherein the technical blueprint of the system is created by designing the technical architecture and designing the system’s model. Designing the technical architecture of the system is done by the architectural design hardware and software that will best suit the organization’s system and future needs. The second process during the design stage is to design graphically a model from the graphical user interface (GUI), GUI screen and databases to be used for storing the data to be entered in those objects in the screen.

Implementation using Fourth Generation Language (4GL)

In this stage, building the technical architecture must be built by purchasing the materials needed to build the system. Moreover, starting of the actual writing of programs’ code is done and the databases are

(34)

created. In this stage, the system is designed into a usable system. The detailed tasks include coding and designing of input and output database structure.

The developers starting to develop program codes using 4GL. A well-organized and structured program design is the main factor to be considered. This design comprises of top to bottom hierarchy of  modules, functions and procedures. During this stage, several attempts are made to execute the program to identify and correct program code errors.

Testing

The initial support with the finalization of documentation, training programs, and on going user assistance on the implementation phase. In order to find and correct some errors, which can be a combination of  logical and/or syntax errors, the programmers must test the individual and sub-modules together with the users.

The proponents in conducting the changeover from the old to the new system will request the users to take part to the test whether all the requirements have been met as included in the system. After the system has been installed, programs will be tested to ensure it meets the design specification with the main objective of optimizing and fine-tuning the system.

(35)

2.11 Summary

In designing and developing the system, the proponents studied and adopted the theory of internet, website, WWW, HTTP, Browser, Client and Server, PHP, HTML, HTML Editor, My SQL, FTP, Information System, GUI and the DBMS. These theories are put together in order to come up with the proposed system.

(36)

Chapter 3 An Online Information System with Reservation for Ligaya Village 3.1 Introduction

The Online Information System with Reservation for Ligaya Village will give information and allow reservations for the customers on the internet. It will also display different kinds of information regarding the company. The system will speed up the reservation process and allow the reservation for the customer available at anytime of the day. Furthermore, it will also provide an online database that will be used for storing employees’ records in the company and company's transactions. In addition, it will allow easy and secure access of files. The maintenance of records will also be easier to manage.

This chapter contains all information about the proposed system such as the components and functionalities.

3.2 System Design Specification

3.2.1 Software Components

3.2.1.1 Front End

The front-end is composed of web pages that can be viewed by the visitor through the Internet using the web browser. The pages were developed using the Hyper Text Mark-up Language (HTML),

PHP: Hypertext Preprocessor (PHP), Cascading Style Sheets (CSS), MYSQL or Structured Query Language and the scripting language JavaScript.

(37)

Front End Components/Web Pages

 Registration module  Reservation module  Search module

 Feedback and Complaints module  Cancellation of reservation

 Gallery

 Deed of restrictions

 Downloadable forms (Reservation application and the PBR)  Mode of payment guideline

 Pricelist

 Frequently Asked Questions (FAQ)  Vicinity map

 Site map

 Site Development Plan  Contact Us

 Company Profile  Virtual Tour

(38)

3.2.1.2 Back End

The backend is a browser-based system with Graphical User Interface (GUI) that is designed to manipulate and maintain databases used by the front-end. It was developed using PHP:

Hypertext Preprocessor (PHP) that is a powerful server-side scripting language for creating dynamic and interactive websites.

Back End Components/Modules

 Maintenance Lot User Employee Client Gallery Content Category

Feedbacks and Complaints

 Transaction

Client inquiries Registration Assessment

(39)

 Utilities

Archive Audit trail

Back up and Restore database Edit Template  Reports Customers Employees Users Available lots Reserved lots Sold lots Reservations  Help

About the company About the system About the developers

(40)

3.2.2 Hardware Components 3.2.2.1 Server

It is the computer unit where the database, web pages, and the database-manipulating system (back-end) are located. It is connected to the Internet, receives requests from clients and sends responses to those requests. It is the place where the requests are processed, inputs from web pages are being stored to the database, and retrieval of information from the database occurs [WIKI2007].

Server Components

Hard Disk - 40 Gigabytes Memory – 512 Megabytes Mouse and Keyboard Processor – 1.8 Gigahertz Monitor – colored

(41)

3.2.2.2 Client

The computer unit that sends requests through the Internet and receives responses from the server. Using the web browser, it displays information that are requested and processed by the server [WIKI2007].

Client Components

Any Computer Unit connected to the Internet and has a web browser.

(42)

3.2.3 Context Diagram

3.2.3.1 Context Diagram of the Current System

Customer Employee Administrative Visitor An Online Information System with Reservation for

Ligaya Village Feedback or Complaints Client Information Employee Information Account Information Unconfidential Information Feedback or Complaints Inquiries Client information Inquiry Company information Schedule for tripping

Reservation form

Application form System Users

Reservation confirmation

Approved reservation Rejected reservation

List of available lots Company updates

Unconfidential Information Request Reservation

Request Reservation

3.2.3.2 Context Diagram of the Proposed System

Customer Administrator

An Online Information System with Reservation for

Ligaya Village

List of reserved lots List of sold lots

Feedbacks or Complaints Request Reservation

Account Information Feedback or Complaints

Inquiries Customer information

Inquiries

Company information Schedule for tripping

Reservation Application

Registration form System Users

Reservation confirmation

Approved reservation

Rejected reservation

List of available lots

Company updates

Unconfidential Information

Log in

(43)

3.2.3.2 Context Diagram of the Proposed System Customer Employee Administrator Visitor An Online Information System with Reservation for

Ligaya Village

List of reserved lots List of sold lots

Feedbacks or Complaints Request Reservation Employee Information Account Information Unconfidential Information Feedback or Complaints Inquiries Customer information Inquiries Company information Schedule for tripping

Reservation Application

Registration form System Users

Reservation confirmation

Approved reservation

Rejected reservation

List of available lots

Company updates

Unconfidential Information

Log in

Request Reservation

3.2.3.3 Data Flow Diagram

3.2.3.4 Data Flow Diagram of the Current System

Inquiry of  Related Information 1.0 Customer Inquiry of related information Inquiries Record Unconfidential information Selected  information Registration of  Customer 3.0 Customer Customer Information Registered Customer R 4.0  Registered  Customer  Customer Submit requirements Selected lot Requirement Verification Reservation Record List of  Available Lots Verify Requirements 5.0 Selected Lot  Customer Mode of  payment 6.0 Receipt Front desk  Reservation for Lot Administrator Customer Tripping of  Customer around the Village 2.0 Customer

Request for tripping

Front desk  Approved request Schedule of  Tripping List of  Scheduled Customers Scheduled Customer  Tripping Record Registration Form

(44)

3.2.3.3 Data Flow Diagram

3.2.3.4 Data Flow Diagram of the Current System

Inquiry of  Related Information 1.0 Customer Inquiry of related information Inquiries Record Unconfidential information Selected  information Registration of  Customer 3.0 Customer Customer Information Registered Customer R 4.0  Registered  Customer  Customer Submit requirements Selected lot Requirement Verification Reservation Record List of  Available Lots Verify Requirements Customer’s Assessment 5.0 Selected Lot  Customer Mode of  payment Breakdown of charges Assessment Slip Assessment Record Assessment fee  Reservation fee Customer’s Payment 6.0 Approved reservation Reservation fee Reserved Lot Customer information Reservation fee Receipt Receipt Approved reservation Front desk  Reservation for Lot Administrator Finance Officer Customer Administrator Cashier Payment Record Tripping of  Customer around the Village 2.0 Customer

Request for tripping

Front desk  Approved request Schedule of  Tripping List of  Scheduled Customers Scheduled Customer  Tripping Record Registration Form

3.2.3.5 Data Flow Diagram of the Proposed System

Inquiry of  Related Information 1.0 Customer Inquiry of related information Content table Unconfidential information Selected information Registration of Customer 2.0 Customer Registration form Account table New account

 Regist ered Cust omer 

Customer Information 3.0 Reservation for Lot Customer request

Request Reservation table

Customer Submit requirements Selected lot Administrator Submitted requirements Verified Requirements Requirements Verification Customer 4.0 Mode of  Payment Breakdown of  Finance officer Assessment fee 5.0 Customer Reservation fee Confirmation of reservation Receipt Selected Lot  Lot table Reserved lot Customer’s Inquiries

(45)

3.2.3.5 Data Flow Diagram of the Proposed System Inquiry of  Related Information 1.0 Customer Inquiry of related information Content table Unconfidential information Selected information Registration of Customer 2.0 Customer Registration form Account table New account

 Regist ered Cust omer 

Customer Information 3.0 Reservation for Lot Customer request

Request Reservation table

Customer Submit requirements Selected lot Administrator Submitted requirements Verified Requirements Requirements Verification Customer 4.0 Mode of  Payment Breakdown of  Charges Assessment slip Assessment Assessment table Customer Assessment Finance officer Assessment fee

 Reserva tio n Fee

5.0 Payment Of  Reservation Customer Administrative Cashier Reservation fee Confirmation of reservation Receipt Approved reservation Receipt Reservation fee Selected Lot  Lot table Reserved lot Customer’s Inquiries

3.2.3.6 Entity Relationship Diagram

Lot Has Reservation Terms Contains makes (1:1) (1:m) (1:1) (1:1) (1:1) (1:m) Lot_Id Block_No Lot_No Phase_No Price_Sq Area Term_Id Year/s Term Res_Id User_Id Res_Date Lot_Id Cust_Id Date

(46)

3.2.3.6 Entity Relationship Diagram

3.2.3.7 Hierarchy Input Process Output chart Lot Has Reservation Terms Contains makes Customer Request For Tripping (1:1) (1:m) (1:1) (1:1) (1:1) (1:1) (1:m) (1:m) Lot_Id Block_No Lot_No Phase_No Price_Sq Area Term_Id Year/s Term Res_Id User_Id Res_Date Lot_Id L_Name F_Name Cust_Id M_Name Time Date

(47)

3.2.3.7 Hierarchy Input Process Output chart (HIPO) Maintenance 1.2 User 1.1 Lot 1.3 Employee 1.4 Customer 1.5 Gallery 1.6 Content 1.7 Feedbacks and complaints 1.8 Category 1.0

(48)

Maintenance 1.2 User 1.1 Lot 1.3 Employee 1.4 Customer 1.5 Gallery 1.6 Content 1.7 Feedbacks and complaints 1.8 Category 1.0 Transactions 2.1 Client Inquiries 2.0 2.2 Registration 2.3 Assessment 2.4 Reservation and Payments

(49)

Transactions 2.1 Client Inquiries 2.0 2.2 Registration 2.3 Assessment 2.4 Reservation and Payments Utilities 3.1 Archive 3.0 3.2 Audit Trail 3.3 Backup/restore 3.4 Edit template

(50)

Utilities 3.1 Archive 3.0 3.2 Audit Trail 3.3 Backup/restore 3.4 Edit template 4.2 Clients 4.3 Users 4.4 Available lots 4.5 Reserved lots 4.6 Sold lots 4.7 Reservations Reports 4.1 Employee 4.0

(51)

4.2 Clients 4.3 Users 4.4 Available lots 4.5 Reserved lots 4.6 Sold lots 4.7 Reservations Reports 4.1 Employee 4.0 Help 5.1

About the company

5.0

5.2 About the sys tem

5.3

(52)

Help

5.1

About the company

5.0

5.2 About the sys tem

5.3

About the developers

3.3 Summary

An Online Information System with Reservation for Ligaya Village is composed of back end, which manipulates the database, and the Front end, which is composed of web pages. Both systems run in the server, which receives requests and sends responses to the customer.

(53)

3.3 Summary

An Online Information System with Reservation for Ligaya Village is composed of back end, which manipulates the database, and the Front end, which is composed of web pages. Both systems run in the server, which receives requests and sends responses to the customer.

(54)

CHAPTER 4 Performance Analysis

4.1 Introduction

In this chapter, after all the major requirements have been accomplished, the proponents have conducted some experiments on the working prototype of  the software. The major objective of this experiment is to test whether the system achieved the objectives of the software.

The proponents have categorized the software into some aspects for them to have criteria or bases on evaluating or quantifying the overall output of the system. These criteria are as follows: functionality, reliability, usability, efficiency, maintainability and portability.

To be able to perform the experiment, the proponents invited some possible users of the system. These users comprise the employees of Ligaya Village and other people including instructors, classmates and co-developers.

4.2 Experimental

Experiments were conducted by letting the possible users of the system on how to use the system and after navigating some parts of the system, the users were given survey forms that serve as evaluation forms. Each criterion is quantified using the Likert’s scale. It is a scale that has a five point scale that corresponds to the equivalent range of rations.

(55)

Table 4.2.1 Likert’s Scale

Range Scale Ratings

4.51-5.00 Very Good (VG) 5

3.51-4.50 Good (G) 4

2.51-3.50 Fair (F) 3

1.51-2.50 Poor (P) 2

1.00-1.50 Very Poor (VP) 1

The system’s performance on one criterion will be quantified in terms of a weighted mean of the ratings. This involves summation of the ratings multiplied by their tally scores and divide by the total number of respondents [DELS2006].

Formula: X = ∑f(x)/n where:

Xis the weighted mean for each criterion

f is the frequency score or tally score

xis the numerical rating (e.g. 5,4,3,2,1)

(56)

Each criterion is listed below and put under its corresponding aspect or part of the system:

Functionality

1. Mode of payment guidelines are presented with accurate payment calculations.

2. The system complies with all the rules of the company and its deed of  restrictions.

3. Level of access is implemented to improve the security of files and maintain customers’ privacy.

Reliability

1. A backup is made regularly to ensure stability and restoration of the system in case of failure.

2. The system has its own module for error handling that notifies the user when errors occur.

Usability

1. Help files are provided to instruct the user on how the system works.

2. The system uses a user-friendly interface to easily familiarize the user with the system.

Efficiency

1. Good coding practices are followed to achieve optimization in the processing of data and improve performance.

2. The system makes sure that its resources are appropriately allocated and properly freed/released to save space and bandwidth.

(57)

Maintainability

1. The system is designed to adapt to changes through system upgrades like template changing and bug fixing.

Portability

1. The installation of the system requires at least knowledge in setting up a server.

2. The system can be accessed or found by a wide range of users because it implements search engine optimization.

All the stated criteria above will be evaluated by the invited potential users. Each user was given an evaluation form after he had navigated some parts of the system. Users were only given the chance to use and evaluate the part of the system that corresponds to their position in the company. The table below illustrates how the proponents applied the Likert’s scale in quantifying the scores of the respondents.

(58)

Table 4.2.2 Example of an Evaluation Tally (Respondents = 10)

Reliability and Usability VG-5 G-4 F-3 P-2 VP-1 N/A Mean

1.) A backup is made regularly to ensure stability and restoration of the system in case

of failure. 6 2 2

4.4

2.) The system has its own module for error handling that notifies the user when errors

occur. 8 2 4.8

3.) Help files are provided to instruct the

user on how the system works. 3 5 2 4.1

4.)The system uses a user-friendly interface

to easily familiarize the user with the system 7 2 1 4.4

From the exam in Table 4.2.2, the mean was computed using the formula x=∑ f(x)/ n. And so, substituting the values for the number 1 criterion we will have:

4.4 = (6*5) + (2*4) + (2*3) + (0*2) + (0*1) 10

The resulting rating of 4.4 will then be compared to Likert’s scale (Table 4.2.1) where it is with in the range of 3.5-4.50 that is GOOD.

The two main areas/aspects that the proponents focused were on usability and functionality. These criteria are the bases if the system had achieved its objectives.

(59)

4.3 Results and Analysis

After various experiments have been successfully conducted, the proponents observed the following.

1. Minor bugs, both logical and runtime errors are still present in the system.

2. Inappropriate punctuations, misspelled words and capitalization of  words that need to be capitalized.

3. Some input validations were accidentally omitted.

(60)

4.4 Summary

To sum-up all the experiment and testing conducted, the proponents were able to quantify the system’s performance using Likert’s scale. Moreover, the proponents were able to witness the possible errors of the system especially those errors that were not encountered during the development phase of the system.

(61)

Chapter 5 Conclusion

Ligaya Village is currently using a manual system in its daily transactions.

The said Village is having difficulties in terms of advertising and giving information to those people who are interested in buying lots or house and lot. Since the company lacks ways of presenting advertisements to its customers, the company does not benefit much in this strategy.

The present reservation process takes a lot of time and effort for the customer. The manual reservation requires the customer to fill-out forms which is inconvenient for some customers that are located far from Ligaya Village and especially to those customers who have very busy schedules.

The Online Information System with Reservation for Ligaya Village will give information and allow reservations for the customers on the internet. It will also display different kinds of information regarding the company. The system will speed up the reservation process and allow the reservation for the customer available at anytime of the day. Furthermore, it will also provide an online database that will be used for storing employees’ records in the company and company's transactions. In addition, it will allow easy and secure access of files. The maintenance of records will also be easier to manage.

To have the benefits of the system, it must be properly installed provided with the compliance of the minimum requirements of hardware, software and

(62)

proper installation (refer to Chapter 3 of this documentation to see farther the system requirements).

The output of this project will be put on the library of STI San Fernando. This will be a great basis or reference to the future researcher who will be developing an on-line system.

This online system was developed and recommended by the proponents not only for Ligaya Village, but to all the companies that operate in the same manner as Ligaya Village. The recommendation of this system was based by the proponents in data that were gathered, surveys and experiments conducted.

(63)

Bibliography

SMIT1991] Angell, I.O. and Smithson S. (1991) Information Systems Management: Opportunities and Risks.

http://en.wikipedia.org/wiki/Information_system

[MIFF2004] "real." The American Heritage® Dictionary of the English  Language, Fourth Edition.Houghton Mifflin Company, 2004.

http://en.wikipedia.org/wiki/Real_estate

Polo, Luciano (2003). "World Wide Web Technology Architecture: A Conceptual Analysis.

http://en.wikipedia.org/wiki/World_Wide_Web

Copyright© 2005 Premier Properties Lake Country Real Estate http://www.lakecountrync.com/reservationform.asp

Michael De La Rosa LAST UPDATED: 26 Jul 2001

http://searchsoa.techtarget.com/sDefinition/0,,sid26_gci213352,00.html

Computer World, 2002, Retrieved on June 22, 2006 from the World Wide Web http://en.wikipedia.org/wiki/Fourth Generation Techniques

[REHM2007] Rehmeyer, Julie J. 2007. Mapping a medusa: The Internet spreads its tentacles. Science News 171(June 23):387-388.

http://en.wikipedia.org/wiki/Internet

http://www.webopedia.com/TERM/H/HTTP.html

http://encarta.msn.com/encnet/refpages/search.aspx?q=what+is+server%3F http://encarta.msn.com/encnet/refpages/search.aspx?q=what+is+client

(64)

http://i.cf.glossary.com/cfhttp/show_glossaryByKeyword.cfm?num=100&query =what+is+information+system%3F

[kend2004] Kenneth E. Kendall, Julie E. Systems Analysis and Design fifth edition Pearson Education Asia Pte Ltd Original American Edition published by Prentice Hall, Inc Upper Saddle River, New Jersey 07458

[BROW] Mariann Barsolo, Tracy Brown HTML, complete SYBEX Inc., 1151 Marina Village Parkway, Alameda, CA 94501.

[HARR2001] Gary B. Shelly, Thomas J. Cashman, and Harry J. Rosenblatt Systems Analysis and Design

Course Technology a division of Thomas Learning Asia, a division of Thomas Asia Pte Ltd.

References

Related documents

Derimod var de enige om, at det var Europas fyrster og øvrige elite, der indledte jødeforfølgelserne (BBC 2008). Eksemplet fra BBC viser den uoverensstemmelse, der findes

To examine the benefits of "double" certification, that is to examine the benefit to the issuer from using commercial banks as both letter of credit guarantors

In order to realize the robust optimal design of chiller plant, the most important job is to ensure the PLR (part load ratio) and COP (coefficient of performance) of operating

For example, see Water Code section 386 (as to State Board approval of certain water transfers), section 1706 (as to a transfer under a pre-1914 water right), section 1707 (as to

• Service portfolio • ERP/ CRM • Business Intelligence • Mobility • Digital solutions • Collaboration • System integration 25 Offices 1,300 Employees 30 Offices 1,100

Trabelsi, “A new multi-objective optimization procedure based on particle swarm algorithm for optimum design of in-wheel permanent magnet motor”, Tur. Lipo, “Comparison

time in finding effective ways of bearing witness to the truth.” Pope John Paul went on to say: “May people learn to fight for justice without violence, renouncing class struggle