Online Transaction System SMS Notification Capstone Project Document

Introduction

Nowadays, the expansion of internet is undoubtedly widespread and has developed a new-socio-economic environment. With the help of internet, online transaction has been developed which allows businesses to automate manual operations and process information much faster.

The adoption of internet transactions is expected to enhance the business performance to reduce transaction cost and to improve coordination of economic activity among partners in business (Olatukun and Bankole, 2011) .The real effect of online transactions on the economy is that it reduces costs and prices and makes doing business more efficient.

BSJ Orthopro Aid and Services offers products and services such as prosthetics and orthodontics for people with amputations. It provides services through job order from hospitals and through Facebook account. Transaction  made manually which is inconvenient and ineffective in promoting the products and services. The proponents identify these problems and come up with an idea to develop a system that can help to manage transactions easily. It will also manage the reservation records accurately and provide quality  service for the business to become competitive.

Background of the study

The BSJ Orhtopro Aid and Services is known for its products that offers services on prostheses and body braces for people with amputations owned and managed by Mr. Sylvester Buenavista. It was formerly called Buenavista Orthodontics and Prosthetic Shop which started operating in the year 1992.

Later it was replaced to Ace Prostheses Enterprise in partnership with his brother located at Santa Rosa City, Laguna. Mr Sylvester Buenavista finished his licensure degree in Master of Orthodontic and Prosthetic 10 months ago decided to develop a business of his own here in Bacolod City which is known as BSJ Orthopro Aid and Services.

Currently, the BSJ Orthopro Aid and Services has one branch which is located at Purok Gonzaga, Lopez Jaena St. Barangay Taculing, Bacolod City. The business aims to aid people with disabilities through quality and durable Prosthetics and Orthotics such as body braces and artificial limbs.

Statement of the Objective

The manual transactions of reservations are time-consuming and uncompetitive in the business.

Generally, the proposed study is designed to:

Develop an online transaction system with SMS notifications that will help the BSJ Orthopro Aid and Services to manage their business easily as well as to promote their products and services online.

Specifically, the proposed study is intended to:

  1. Provide an automated system that is efficient, timely and productive for both customer and business itself.
  2. A system that generates reports.
  3. Provide an online store.
  4. Provide an SMS support for customers.

Conceptual Framework

The figure shown below describes the conceptual framework of BSJ Orthopro Aid and Services Online Transaction System with SMS Notification. It is  how information being processed in order to achieve the desired output of the proposed system. The proposed study is intended to improve the manual reservation process of BSJ Orthopro Aid and Services.

Conceptual Framework

Scope and Delimitation of the Study

This section covers the scope of the study and the delimitation of the proposed system.

Scope

The study covers the BSJ Orthopro Aid and Services Online Transaction System with SMS Notification which is accessible through the World Wide Web. With the proposed system, the management can easily add, edit, and update new products. All information encoded in the system is automatically saved in the database. The proposed study also offers quality services to their customers wherein transactions are made conveniently. Customers are being notified with their order and  schedule of appointment. The proposed system is consists of unique username and password in order for the customer to reserve or buy a product. The system has the ability to generate and printout reports depends on a specific date range. The system can easily monitor the availability of stocks in the system. Customers can purchase one or more product they can also check the number of products they purchased. The system automatically calculate the initial price of products purchased. In terms of payments customers can pay though paypal. The system uses NowSMS application as a modem in sending SMS to customers.

Delimitation

The study limits to display the products in a 3 dimensional view due to the absence of tools to be used and the greater number of memory needed. Users are required to have a registered account in making transaction otherwise no possible transactions may be done. In terms of

Shipment of products, it will be delivered personally since the products are too fragile and need extra careful. Only administrators are allowed to make to changes in the system. They are also required to have a username and password for security purposes

Significance of the study

The proponents established an online system entitled BSJ Orthopro Aid and Services Online Transaction System with SMS Notification that allows customer to select different types of prosthetic product and notify them about the status of their reservation. The following are the various people who could benefit in the system. The company being studied, the customers, the proponents and the future researchers.

Owner. The proposed system will be a big help for the owner in his business in monitoring the development of its sales and reports as well as ease management. The system can acquire more customers since the proposed system caters online transaction with a larger of population that can be access. It aims to lessen the time in doing transactions, improve the business process,and  provide effortless management of the business.

Customers. The system will be beneficial to the customer since it gives direct access to the company. It will minimize the time, money and effort spent by customers in purchasing the products. The proposed system provides convenience. Customers can select the prosthesis that fits to their needs anywhere without visiting the company.

Proponents. This study helps the researchers to apply their learnings in their four years stayin Carlos Hilado Memorial State College. The proposed study will help the researchers to enhance their skills both in research as well as in software development. The proposed study will contribute to the completion of the requirements for the degree of Bachelor of Science in Information System.

Future Researchers. This study will be beneficial to other students in the future for  their capstone project. The proposed study will serve as their guide  particularly for online based-websites and similar systems.

Definition of Terms

The proponents defined the following terms operationally based on their use in the study and the system.

Customer. One that purchases a commodity or service (Merriam-Webster Dictionary, n.d).

Internet. An electronic communications network that connects

computer networks and organizational computer facilities around the world(Merriam-Webster Dictionary, n.d).

Inventory. The act or process of making a complete list of the things that are in a place : the act or process of making an inventory( Merriam-Webster Dictionary, n.d).

Notification. Something that gives official information to someone: the act of notifying someone. (Merriam-Webster Dictionary, n.d).

Online. Connected to, served by, or available through a system and especially a computer or telecommunications system (as the Internet)(Merriam-Webster Dictionary, n.d)

Prostheses. An artificial device that replaces a missing or injured part of the body(Merriam-Webster Dictionary, n.d).

Report. An official document that gives information about a particular subject(Merriam-Webster Dictionary, n.d).

Reservation. An arrangement to have something (such as a room, table, or seat) held for your use at a later time. (“Merriam-Webster Dictionary”, n.d)

System. A group of devices or artificial objects or an organization forming a network especially for distributing something or serving a common purpose (Merriam-Webster Dictionary, n.d).

Transaction. A business deal: an occurrence in which goods, services, or money are passed from one person, account, etc., to another.(Merriam-Webster Dictionary, n.d).

Review of Related Literature

This chapter includes the compilation of related topics and studies that are relevant to the proposed study.

Local Studies

Online Dental Reservation with SMS Notification

The Online Dental Reservation with SMS Notification of Dr. Ricky Salvador Clinic facilitates appointment reservation and save a huge data in terms of patients information records. It uses SMS Notification to confirm the client request that has been reserve. The system is a big improvement over the manual system of the clinic. Dr. Ricky Salvador’s relationship  and will take a lot of work off from the patient and to Dr. Salvador.The patients of Dr. Salvador will have a great benefit from the system because of its authentication from the site  and in identifying the patient if he/she set an appointment online. The system comprises in terms of Functionality, Reliability, Usability, Portability, Efficiency and Maintainability of the system.

Online Medical Reservation System

The Online Medical Reservation System is a software innovation intending to revolutionize in doing regular check up with doctors. The system can easily make an appointment with a preferred doctor online for consultation and check up to prevent long line waiting. The system covers a wide range of options specifically the list of doctors by specialization alongside their schedule and availability. Once the first five patientswere scheduled for that specific date and time, the system will not further entertain other appointment application. The system helps people especially those who are busy but need constant check up.

Foreign Studies

Vorum / Canfit Prosthetics and Orthotics CAD

The Canfit computer-aided design (CAD) software application empowers to quickly design all types of custom prosthetic and orthotic devices. Vorum’s computer-based design tools enables to make shape modifications that are more anatomically correct: Quickly make sophisticated shape modifications. The users can rotate, align, and twist in ways alike in doing a plaster.

PRO.create Prosthetics

PRO.create prosthetic construction software allows the prosthetist to input the patient information; from weight to clearance and the system will generate a list of the products that can be used for that patient. Select the componentry in minutes, not hours. It is simple and easy-to-use software guides the user through the entire configuration of the prosthesis by entering patient data, selecting the products and a simple online-order form, with PRO.create the days of catalog searching are over.

Synthesis

Based on the related systems that are stated above both foreign and local were all formed for the benefits of the customers. It also shows which features are available on the system and features that are not available to others.

The proponents have noticed that automatic system will be of big help to company’s side wherein business  are more competitive by using online websites in making transactions. Proponents look ahead to develop a system that can provide better quality of services to customer. It enables customer select products that fits to their needs.

Therefore, the proponents took the features lacking in the related systems and included it to the system so that it would gain control, making it more likely to be profitable and beneficial to its users.

Methodology

This chapter showcases the system flows and the phases it goes through. This will also provide a User’s Acceptance Survey, the target population of the study, the cost benefit analysis. This chapter  also discusses the functionalities and detailed description of the different components of the system.

The proponents followed the standard software development life cycle (SDLC)

to describe and present solutions for the problems identified in this study using the prototype model.

The Prototyping Model is a systems development method (SDM) in which a prototype (an early approximation of a final system or product) is built, tested, and then reworked as necessary until an acceptable prototype is finally achieved from which the complete system or product can now be developed. This model works best in scenarios where not all of the project requirements are known in detail ahead of time. It is an iterative, trial-and-error process that takes place between the developers and the users.

Requirements gathering

The researchers recruit group members and identify the roles and responsibilities of the proponents according to their specialty for the various activities in the Development Life cycle stage.

The researchers look for a company to be interviewed and selected the BSJ Orthopro Aid and Services as the leading area of the study.

The researchers conducted a study, analyzed the business process, determined the existing problems and with these  the researchers came with up an idea to make the business  more competitive. An online transaction system with SMS notification for BSJ Orthopro Aid and Services should be developed.

The researchers conducted a title hearing for the proposed study which is based on the chosen company. The proposed study is entitled “ BSJ Orthopro Aid and Services Online Transaction System with SMS Notification”.

The researchers gathered and collected data which are being  used in the  business operation to be used to be included in the documentation of the proposed system such as the functional requirements and non-functional requirement. In this phase the proponents started to create their documentation from Chapter 1 and 2

Prototyping

In this, the proponents developed the prototype of the proposed system based on the gathered output on initial design. The collected design is used by the proponents in identifying and analyzing the input, process and output of the proposed system which is used in developing the conceptual framework.

Customer

After the proponents developed the prototyping the customer review was work. The proponents implement the developed prototype and then assessed by the customer or user. Customer feedback is used to develop the requirements for the software. As well as for further enhancement of the proposed system under the development phase.

Design

prototype model

In this phase proponents developed the representation of the features of system that is visible to customer or end user. It comprises modeling of system methodology, data flow diagram, entity relationship diagram, system architecture as well as the Graphical User Interface of the system.

The design phase comprises of Prototyping, Customer and Review.

Review

As the proponents undertaking the design phase there are revision and enhancement for the developed prototypes. The proponents discuss and review the finalize prototypes that the developed prototypes will act in accordance with the user and customer expectations to meet the customer’s satisfaction. At the same time the proponents completely understands what the customer’s needs are and how to fulfill them.

Development

In this phase the proponents are working on the chapter 4 and  5 of documentation. The proponents undertake vigorous coding of back end and front end of the system as well as system debugging. Cost Benefit Analysis was also developed by proponents by identifying the developmental, operational, benefit of the system as well as the return of investment if the proposed study will be implemented. The proponents use laptops and personal computer, with Windows 7 and 8 as the operating system for the development of the system. Sublime Text as the text editor for using HTML as the markup language and Java script for the client side scripting language. CSS is used for the design development, in order to make the system user-friendly. For the server side scripting language, the proponents will use PHP and MySql for the database storage.

Testing

In these phase the proponents perform testing of system and conduct system testing to the owner. Discovery of defects are corrected. Verify that system is scalable and will meet performance requirements. The assessment of whether or not the system is usable in an operational situation. The proponents conduct User Acceptance Survey in order for the proponents to identify if the developed system is reliable and if the system meets objectives   through the User Acceptance Survey questionnaire.

Maintain

As requirements evolve and bug reports come in from the field. The proponents perform system maintenance; establish operation and maintenance of system; ensure effective implementation and control the performance of maintenance in a operation activities in a efficient and safe manner and Ensure that operator knowledge and performance will support safe and reliable plant operation.

Population of the Study

The primary target population of the study is the customers. But due to the nature of the study, the target population also expanded to society and companies which also offers identical products and use the system to operate their business. Perhaps as long as the users are computer literate, they can surely benefit from the system.

Requirement Specifications

Operational Feasibility

As of the moment, BSJ Orthopro Aid and Services uses social media to advertise their products and make transactions .As a result the business become uncompetitive since most businesses uses website to compete to the global market. This system will provide them a bridge to expand the progress of the business not just only in Negros Island but also in the whole Philippines. Therefore, the system will for sure be beneficial to the company.

Program Environment

Front End

HTML is also known as  HyperText Markup Language, a computer language devised to allow website creation. These websites can then be viewed by anyone else connected to the Internet. It is relatively easy to learn, with the basics being accessible to most people in one sitting; and quite powerful in what it allows you to create. It is constantly undergoing revision and evolution to meet the demands and requirements of the growing Internet audience under the direction of the » W3C, the organisation charged with designing and maintaining the language. HyperText is the method by which you move around on the web — by clicking on special text called hyperlinks which bring you to the next page. The fact that it ishyper just means it is not linear — i.e. you can go to any place on the Internet whenever you want by clicking on links — there is no set order to do things in. Markup is what HTML tags do to the text inside them. They mark it as a certain type of text. HTML is a Language, as it has code-words and syntax like any other language.

CSS was first developed in 1997, as a way for Web developers to define the look and feel of their Web pages. It was intended to allow developers to separate content from design so that HTML could perform more of the function that it was originally based on – the markup of content, without worry about the design and layout. CSS is one of the most powerful tools a Web designer can learn because with it you can affect the entire mood and tone of a Web site. Well written style sheets can be updated quickly and allow sites to change what is prioritized or valued without any changes to the underlying XHTML.

jQuery is a JavaScript library that allows web developers to add extra functionality to their websites. It is open source and provided for free under the MIT license. In recent years, jQuery has become the most popular JavaScript library used in web development. jQuery can also work with Ajax code and scripting languages, such as PHP and ASP to access data from a database. Since jQuery runs on the client side (rather than the web server), it can update information on a webpage in realtime, without reloading the page.

Bootstrap is a small strap or loop at the back of a leather boot that enables you to pull the entire boot on. In computers, to bootstrap (or “to boot“) is to load a program into a computer using a much smaller initial program to load in the desired program (which is usually an operating system). In general usage, bootstrapping is the leveraging of a small initial effort into something larger and more significant. There is also a common expression, “pulling yourself up by your own bootstraps,” meaning to leverage yourself to success from a small beginning. 

Back End

PHP is an alternative to Microsoft’s Active Server Page (ASP) technology. As with ASP, the PHP script is embedded within a Web page along with its HTML. Before the page is sent to a user that has requested it, the Web server calls PHP to interpret and perform the operations called for in the PHP script.An HTML page that includes a PHP script is typically given a file name suffix of “.php””.php3,” or “.phtml”. Like ASP, PHP can be thought of as “dynamic HTML pages,” since content will vary based on the results of interpreting the script.

MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP. LAMP is a Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language. (Sometimes Perl or Python is used instead of PHP.)

NowSMS is a powerful multi-protocol content delivery solution for SMS and MMS messaging.NowSMS is a Windows-based server software product that allows rapid deployment of these services with performance scalability that ranges from small test environments to full production mobile operator systems.NowSMS is an SMS Server, MMS Server, WAP Push Proxy Gateway and Multimedia Messaging Center (MMSC).NowSMS supports a wide range of SMS and MMS protocols, and simultaneous connectivity to multiple SMSC and/or MMSC connections.Applications can use standard protocols such as HTTP, SMPP, SMTP and MM7 to interface with NowSMS, or they can use sample APIs provided for PHP, Java and command line interfaces.

Technical Feasibility

Hardware Specifications 

The proponents decided to use the following hardware to be used in developing the BSJ Orthopro Aid and Services Online Transaction System with SMS Notification in order to meets its requirements.

Minimum Requirements

  • Core i3-4130 3.4 GHz Processor
  • 4GB RAM
  • 250 GB Hard Drive
  • Compatible mouse and keyboard
  • Monitor: 800x 600resolution
  • Printer

Recommended Requirements

  • Core i5-4690 3.0 GHz Processor
  • 8GB RAM
  • 500 GB Hard Drive or higher
  • Compatible mouse and keyboard
  • LCD Monitor:1366x 768 resolution

Server Requirements

  • Intel Core i3 4th Generation Processor
  • 2GB DDR3 RAM
  • 1Tb Hard Disk Drive

Software Specifications (Minimum Requirements)

The proponents decided to use the following software to meet the requirements for BSJ Orthopro Aid and Services Online Transaction System with SMS Notification.

  1. Customer side
  • Any desktop or laptop running a Windows 7 or any updated OS.
  • NowSMS Software
  • Android phone 2.3 Gingerbread or higher version of Android OS with WiFi and mobile network connectivity
  • GSM Modem supporting ETSI GSM 07.05 / 07.07 and/or 3GPP TS 27.005 / 27.007
  1. Administration side
  • Any desktop or laptop running a Windows 7 or any updated OS.
  • Any browser

System Architecture

System Architecture

Figure 3 displays the structural design of the system wherein the administrator (BSJ Orthopro Aid and Services) connects to the database wherein all the data including the product, customer, stocks and inventory records are being saved. The system is accessible in browser which is being connected on the Network. With the help of internet, customers can visit the website, view, select and reserve products. After the customer reserve the product the administrator will directly send SMS to the schedule of appointment, customers are notified though their Smartphone.

Feasibility Schedule

The feasibility schedule contains the record of the amount of time the proponents spent on developing the system. The proponents uses prototype model which includes the requirements gathering, design, development, testing and maintain phase.

Gantt Chart

Requirements Gathering Phase
Figure 4.0: Requirements Gathering Phase

The figure above shows the work breakdown under Requirements Gathering Phase wherein the proponents performs different task to complete the requirements gathering phase.

Design Phase

Figure 4.1 Design Phase

The figure above shows the work breakdown under the Design Phase.The Proponents performs different task including the modeling of the System methodology, Entity Relationship Diagram, Data Flow Diagram and System Architecture as well as develop design for Graphical User Interface, Conceptual Framework and Review Prototype.

Development Phase

Figure 4.2 Development Phase

The figure above shows the work breakdown under the Development Phase. The proponents performs different task which includes the creation of documentation from chapter 4 to 5, coding of front end and back end the system, debugging as well as identifying the Cost Benefit Analysis of the proposed study.

Testing Phase

Figure 4.3: Testing Phase

The figure above shows the work breakdown under Testing Phase. The proponents performs different task to complete the testing phase which includes testing of the system, conduct system testing to the owner of the business and conduct User Survey Acceptance. Discovery of defects in the system was also being corrected.

Software Development Summary

Figure 4.4 : Software Development Summary

The figure above shows the Software Development Summary of all the phases under the Prototype Model. The Requirements Gathering compose of 83 days with an average of 68%.The Design Phase compose of 40 days with an average of 69%.The development phase compose of 134 days with an average of 68%. Lastly, the testing phase compose of 21 days with an average of 80%.The proposed study has an  interpretation of 9 months with 9 days and 21 hours to complete the development of the study.

Summary of Findings, Conclusions and Recommendations

This chapter presents the summary or the research work undertaken, the conclusions drawn and the recommendations made as an outgrowth of this study.

Summary of Findings

The proponents conducted series of interviews to the company and to the customers to identify the main problem of administration. The proponents started to create a system that would help the company to minimize and improve the business process.

BSJ Orthopro Aid and Services offers products and services such as prosthetics and orthodontics on facebook page and job order from hospital which is incompetent in promoting the business especially nowadays that there is a lot of competitors uses website in advertising products and doing transactions via internet.

The BSJ Ortophro Aid and Services Online Transactions Systems with SMS Notification focus on the automatic scheduling of transactions wherein customer are notified directly, transactions are more easier and more convenient. The administration can manage the business efficiently and effectively, inventories and reports of products can  easily monitor and save customer’s information directly.

The proponents conducted a user acceptance survey to evaluate the acceptability of the users to the online transactions system with SMS Notification if it could get a good average rate when it comes to its system effectiveness, efficiency, quality, timeliness and productivity. As the result shown in the Chapter 4, the system get an average rate of 4.2 which is not a bad outcome from the users if they are going to use the system.

Conclusion

In line with all results, data and feedback that was being gathered in the whole chapter, the proponents concluded that the system is useful to the company because it can directly generate inventories such as the profit of sales of products and can directly monitor the availability of product. The proposed study will provide the customer a direct access to the company. The displayed product in the system will give the customer the idea or they can picture out the prosthetics and orthotic product they ordered.

Recommendation

Based from the conclusions given above the proponents recommends that the BSJ Orthopro Aid and Services must adopt and implement the system in order to improve the transaction process.The administration should change their manual transaction into an automated system. With the use of the proposal system, the company will become more competitive and attract more customers and can offer better quality of service. The administration should use the system so they there can easily manage their business; The website have the assurance to record accurate information and customer friendly system.

Share This Post!

Categories

Recent Posts

Archives