Rationale of The Study: South East Asian Institute of Technology College of Information and Communication Technology

SOUTH EAST ASIAN INSTITUTE OF TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

National Highway, Crossing Rubber, Tupi, 9505
SouthChapter 1
Cotabato, Philippines
INTRODUCTION
RATIONALE OF THE STUDY
A dental clinic is technically any place where dental services are rendered.
Customers must manually put up their information in the registration form using the
usual approach, and the information is only kept in files. The files will be placed in the
rack after registration, which will cause issues such as taking longer to retrieve
information, making mistakes while writing, or misplacing the files.
However, many dental practices still require patients to make a phone call in
order to schedule appointments. Not only is this a major inconvenience for the patient
that may make them reluctant to schedule their next appointment, but it's also an
inefficient use of your staff's time. Fortunately, there are a few systems on the market
that can help dental practices facilitate online bookings.
As healthcare workers are experiencing an increase in their workload, a patient
scheduling system could be a way to relieve some of the stress. With patient
appointments scheduled in advance, healthcare facilities can plan resource allocation in
advance, increasing efficiency and reducing staff’s stress levels. Moreover, they can
regulate the patient flow better with appointment booking solutions. (Thamrin, 2020)
According to Paldez (2018), some dental clinics still use manual operations to
run their business, like storing all their data in a secured drawer. The room for errors is
very wide when it comes to keeping and updating records. Also, keeping track of a
dentist's performance and business is also hard. Typically, an appointment system
1|Page
includes a variety of analytics tools
Souththat showPhilippines
Cotabato, when they receive a high volume of
reservations, what types of people prefer property, and what upgrades sell the best.
This valuable information will outline the areas where they need to focus, saving time,
effort, and money on approaches and activities that simply don’t work for them.
The proposed solution for the above-listed concerns is a DR. Arenas Dental
Clinic Appointment System. Clients can utilize the system to reserve services by
selecting a convenient date and time, entering their information, selecting a payment
option, and submitting an appointment. The system also includes an SMS notification
feature, which notifies clients about their upcoming bookings and displays data analysis
of their service performance on a scale. The system will improve customer service in
general.
OBJECTIVES OF THE STUDY
2|Page
General Objectives South Cotabato, Philippines
The proposed project aims to develop a system that would facilitate appointment
reservations with SMS notification and to display data analysis.
Specific Objectives
a) To develop an automated forecasting system that can classify the services
offered by Dr. Arenas dental clinic.
b) To identify which services offered are the most availed by the patients in Dr.
Arenas dental clinic.
c) To develop a system that can display the total number of patients in Dr.
Arenas dental clinic.
d) To develop an automated system that can display the monthly record of the
dental clinic services.
SCOPE AND LIMITATIONS OF THE STUDY
Scope
The patients and healthcare providers who will use the system will be the focus
of this project. It will be easy to schedule an appointment using the system, and it will be
the most convenient way to save patient information. The project will be implemented in
the Dr. Arenas dental clinic.
The prototype can be used by dental admin to manage the appointments of
those patients who need them and for those who would like to make them via a system
anytime and anywhere. The proposed system will save the time and effort of patients
3|Page
from waiting to make an appointment, as Philippines
South Cotabato, well as reduce the work of system
administrators by accessing information for reporting purposes.
The system administrator needs to maintain the records of patients. A user
should be able to know the availability of a particular date. They should be able to
reserve the available date and time in advance, according to their needs. In this project,
the dentist personnel will play the role of administrator or maybe the admin. The dentist
can update and add the patients' information and appointment schedule. This system
also generates data analysis reports and can view the previous and current patient
records. The system can provide SMS notifications for those clients who take their
schedule as confirmation that they already have an appointment.
Limitation
The system is only accessible at Dr. Arenas Dental Clinic. In addition, the system
restricts accounting and finance. It simply functions as an appointment and transaction
for Dr. Arenas Dental Clinic. The software would not include billing features or the ability
to accept payments from patients via the internet. The system unable to offer printing
reports.
SIGNIFICANT OF THE STUDY
The system that the proponent will develop will benefit the concerns of Dr. Arenas
Dental Clinic. The system will provide patient information, a powerful appointment
4|Page
handling system with SMS notification, and service
South Cotabato, scale performance. It will have
Philippines
significance for the following:
E & R Arenas Dental Clinic's owner: The doctor of this clinic, who is also the owner,
has an advantage over other clinics in using advanced technology in terms of having an
organized, simplified but effective appointment system. It will be of great assistance in
their day-to-day operations easy. It will be an instrument to make it more competitive in
the market. That gives the possibility of increasing potential patients and developing
more loyal patients.
Future Researchers: The study can serve as the basis for their version of the Dental
Clinic Appointment System. The output of the project comes in two forms, the document
and the source code of the system. Completed documents will serve as the literature
while the system will serve as their guide in development.
Patients: This study will benefit the patients for ease access of viewing services for
effortless since it displays in the system. It provides more quality service, and it will be
more convenient for them. It will reduce the time it takes for them to book an
appointment. It will also give them easy access to their records anytime and anywhere
to help them monitor their dental information.
Researchers: The success of this study will contribute to their knowledge and skills as
developers and programmers. Aside from technical skills, the development of the
system will enhance their capabilities and will make them critical thinkers by thinking of
solutions to implement an effective system to solve the problems of the company.
5|Page
Staff: The study will benefit the staff
Southdue to technology
Cotabato, Philippinesadvancement by accessing the
patient's transaction.
FLOW OF THE STUDY
INPUT PROCESS OUTPUT
6|Page
 Patient South Cotabato, Philippines
 Records of  Total of
information patient
patients
 Dentist appointment
 List of service
schedules  Encode dentist
 Top service
 Appointment schedule and
data patient data  Service
 Input service  Service performance

performance
data analysis
 SMS notification
for confirmation
DEFINITION OF TERMS
7|Page
Admin-a person legally appointedSouth
to manage
Cotabato,and dispose of the estate of an intestate,
Philippines
deceased person, debtor, or other individual, or of an insolvent company. It refers to the
person managing or in charge of the system of the dental clinic.
Appointment Handling-the process of checking all the necessary information needed
to avoid conflicting schedules and obtain the approval of the concerned individual.
Appointment-the act or process of entering information about something into a book or
system of public records.
Dental Clinic-is technically any place where dental services are rendered.
Owner/Doctor-the term refers to a person who is able to do planning, organizing,
leading, coordinating, and controlling. It refers to the person who operates the system
and does services for the clinic.
Patient records-organized data of a patient’s profile.
Performance Scale-a scale from which the level of achievement may be calculated for
any given level of actual performance for such Performance Measure.
Reports- informational works made with the specific intention of relaying information or
recounting certain events in a widely presentable form.
System-standalone application in which this system is just to save the data as
computerized and not connected to any network. This system is also focused on
improving the current system in part of recording patient tooth treatment.
8|Page
SMS Notifications- a out-of-band
Southtext messages
Cotabato, sent in response to events or
Philippines
transactions which occur somewhere else.
CHAPTER II
Related Literature and Studies
This chapter is about studies and literature that are related to the dental clinic
appointment system that the proponents made use of different reading materials (such
9|Page
as thesis, articles, and other web South
articles) that will
Cotabato, help extending the knowledge of the
Philippines
proponents. These reading materials will also guide the proponents to improve and
develop their proposed system more effectively.
LOCAL STUDY
Dr. Joanne Sapotin-Lozano Dental Clinic Management System by Lotayo et al.,
(2020) Dental Clinic is an organization that is responsible in providing a health
medication and treatment for all types of dental patients. Surely, everyday there are
people that need to use the dental clinic services. But how can clinic provide a faster
and efficient services if they are still using the traditional method on their daily
operation? The traditional method means the customers need to fill in their detail in
registration form manually and the information will only keep in files. After the
registration, the files will be place in the rack and this will cause problems like taking a
longer time to retrieve the information, make mistakes during writing or misplaced the
files.
Nowadays, technology has changed many aspects of life and people’s daily life
is becoming indivisible from the network due to the development of Internet. With dental
clinic management system, the process gets much faster and more efficient than
traditional way. Even t0hough the dental clinic had a system, but they still do not use the
application. It is because there are facing several problems during process
management.
As proponents, this study aims to propose the Dental Clinic Appointment System
specialized designed to let the clinic staff has a high efficiency management tools,
10 | P a g e
computerized and systematic patient’s record,Philippines
South Cotabato, and detail of treatment records. This
system also provides appointment feature, which allow staffs to view the appointment
that already made by doctors. This new system will replace the current system that is
used in clinic and surely this system will improve the clinic services and make their daily
operation running smoothly. Patient treatment module consist the information about the
tooth examination and record and list of treatment that has done. The objectives of the
project are to develop decision support system for dental clinic, to improve part of
record patient examination form and analysis the cause of tooth disease, prevention
and treatment.
Dental Management Information System with Online Appointment and Billing
System Through SMS for Dra. Lumibao Dental Clinic by Clemente et al., (2020). The
dental profession of all the doctors and dentist has an obligation and responsibility for
patientcare properly maintained patient record by the Dentist Secretary is a very
important aspect of this patient care. In general, a (record or data) can be defined as
information generated as the official records or transactions and one that is documented
to acts as a source of reference and a tool by which an organization is governed. The
dental record is the official office document that records all diagnostic information,
treatment performed and patient related communications that occur in the dental office
including on how they request an appointment to their dentist even in their doctor.
Based on the foregoing findings of the study the following are recommended for
future enhancement of the develop Dental Management Information System with Online
Appointment and Billing System through SMS for “Dra. Lumibao Dental Clinic” the
11 | P a g e
following recommendation are suggested to the
South Cotabato, future proponents of users of the
Philippines
system.
In order to meet the requirements needed on developing the system the proponents
base" on objectives of the study for accurate result.
Baque-Manalang Dental Clinic Online Reservation by Finch (2017). The use of
online go nowadays becomes more than necessary in the various palm. It is because of
the advantage and useful effects to well-nigh people when it comes to online taciturnity
because our society is facing rapid growths of learn, avail mightiness and discipline of
una same commercial web-based application. The online taciturnity work differs from
the traditional transcription in the capacity to provide services regardless of temporal
and spatial constraints. They be also different from traditional interpersonal services that
are delivered face-to-face. It allows persons to employ Information Technology with
expose being tied to a bangle location. This technology enables users to rile the pose at
any time in any location. A suitable use of the online reservation services and piano
tuner technology allows new application, focus and reservation for alveolar consonant
clinic via online services. The objective of online reservation is to snip the driving force
and the time for the nodes to set day of the month and to receive services and improved
the reservation validation efficiency
Foreign Study
Dental Clinic Management System for Abokor Artan Dental Clinic and Pharmacy
by Sanjib et al., (2017). Dental Management System is a system which is a first step to
12 | P a g e
change the medical industry methodology of keeping
South Cotabato, the data of patients as well as the
Philippines
other important information. This system will help the users to manage the dental
information and make sure that all important data will be able to use in the future time.
All technical support guided by best web design company in Kolkata
Bhavitra Technologies Including for the future treatment, as well as to do
research from the data that had kept in the database system as this system will be used
for the dental management, the dental industry will soon be a high standard industry,
which all the process will be done through the computer and specified system.
Dental Clinic Management System by Kwan (2018). This project is a clinic
management system that will be used to solve the current problems that facing by the
local clinic in Malaysia. Clinic Management System is a web-based platform system.
The main objectives of this project are to improve the business process of the clinic in
Malaysia by using the information technology and also enhance the current clinic
management software in the market. The scope of this project includes systematic
scheduling in queue list, appointment module with SMS notification, patient’s
registration using MyKad reader and generate medical certificate (MC) to print out.
Systematic scheduling can sort the patient in the queue fairly and display the waiting
time of each patient. Patient can make appointment and notification will be send to their
phone. Besides, patient can use MyKad during the registration at the counter which is
quite convenient and save time. Other than that, MC can be generated and print out on
the paper and doctor just need to sign the MC and chop with his name. As this is a web-
based platform system, C# is the programming language and the project is developed
under ASP.Net framework. The software development methodology that used in this
13 | P a g e
project is phased development because of fast implementation
South Cotabato, Philippines and short time schedule.
The clinic management system can divide into few phases and each phase consist of
few modules which can easily develop and build up the system in short time.
Dr. Rushin Mehta Dental Clinic Information Management System by AMA
Healthcare LLP (2019). System The project Hospital Management System (HMS) is for
computerizing the working in a hospital. The software takes care of all the requirements
of an average hospital and is capable to provide easy and effective storage of
information related to patients that come up to the hospital. It generates test reports;
provide prescription details including various tests, diet advice, and medicines
prescribed to patient and doctor. It also provides injection details and billing facility on
the basis of patient’s status whether it is an indoor or outdoor patient. The system also
provides the facility of backup as per the requirement.
Local Literature
Dental and Medical Inventory, Order and Traceability Management Software by
Tardieu (2019). All clinics are facing the same issues related to items orders,
traceability, inventory, real time evaluation of the inventory, expire dates management,
price of same items sold by different distributors, medico-legal constraints, consumption
evaluation of all Items or of some dedicated items, export of payment details to
accountancy, etc.
The aim of this paper is to define these needs, specific to medical practices. It is also
analyzing the solution offered with a new on-line software (Easy Stock-in®) to get an
answer to these problems. This new online software created by dentists for dentists is
14 | P a g e
answering the problems related to order
South and Philippines
Cotabato, stock management specific to medical
practices.
All the tools are accessible online and the intuitive way to work with it allows a
very fast and easy implementation whatever size is the dental practice.
All users of this program have been surprised by the amount of money stuck in
inventory. Based on this information, users have been able to modify their protocol of
decision to order items in a better way. It is a real satisfaction to get access to much
information in one click. Substantial savings have been done on expenses by all users.
Full version access to Easy Stock-in is available on the web site of ANPA MEDICAL
SUPPLIES DMCC
Foreign Literature
Safety Net Dental Clinic by See Levin (2017). Before beginning operations, the
clinic will need to develop policies and procedures controlling the purchasing of all
supplies (both dental supplies and office supplies) for the clinic. In most circumstances,
the dental director or chief medical officer will delegate those staff members who have
the authority to order and purchase supplies. Payment for such supplies are usually
handled by personnel in the business office based on pre-determined budgets.
Policies and procedures should specify who on the staff will have access to the
inventory and what protocols will be in place to deter misuse and theft. A dentist, dental
hygienist, and/or dental assistant should have purchasing authority to maintain stock of
dental materials and supplies. On the other hand, a clerk, office manager, receptionist,
15 | P a g e
or other non-clinical person should be delegated
South to order the office and miscellaneous
supplies. Limit the number of people who have access to the clinic's monetary
resources, but maintain adequate ordering flexibility to ensure that supplies can be
purchased during staff absences or turnover.
It is advisable to have a system to purchase, stock, and track supplies, including
monitoring expiration dates. In addition, it is crucial to monitor all overhead expenses for
a dental operation. Inventory control is one area that needs to be reviewed on a
consistent basis for variances. If the clinic is purchasing some or all dental supplies from
mail-order sources, logistical considerations are important. For example, many dental
materials have a finite shelf life that must be taken into consideration. Personnel must
be proficient in tracking the rate of use of these items to prevent running out of critical
supplies and to ensure that the items do not get used past their expiration date.
Therefore, inventory monitoring is essential. The lack of any critical supply can bring
clinic operations to a halt. By setting clear inventory targets, one can establish a
process that allows the practice to purchase supplies on a regular basis, avoid
mistakes, and maintain expenses. Depending on practice volume and types of oral
health services provided, it is recommended that total expenses for dental supplies
(excluding office supplies) range between 6 percent and 12 percent of overall expenses
for a dental operation. Exceeding this benchmark compromises the budget for the
dental practice.
16 | P a g e
Furthermore, the geographic locationPhilippines
South Cotabato, of the clinic and environmental
considerations may influence the timing of ordering for delivery. Some dental materials
should not be exposed to either extremely hot or extremely cold temperatures. Local
anesthetics, for example, should never be allowed to freeze while being shipped or
stored. Freezing can weaken the seal of the rubber plunger in the carpule, allowing the
introduction of air into the solution, which enhances the degradation of the anesthetic
before its expiration date. Therefore, if your clinic is located in a cold climate, adequate
supplies of local anesthetic should be purchased before the onset of freezing
temperatures. Such considerations will ensure ample inventory of anesthetic throughout
the winter months. Note that if this ordering cannot be done without risking expiration of
the anesthetic, then a local vendor should be used for that material.
If the clinic is located in a region with other clinics, one might consider developing
a cooperative purchasing agreement. Coordinated purchasing and the ability to buy
large quantities in bulk may make it possible to obtain better prices. Volunteer dental
clinics have discovered that having the clinic administrator or dental director attend state
or regional dental meetings to meet with manufacturers and suppliers is one way to
secure discounted prices and/or donations. Always let vendors know if your
organization is a volunteer or nonprofit organization.
Information Systems in Dentistry by Masic (2017) In the era of paper (which is
still present), patient information is stored in their medical records. Results of laboratory
17 | P a g e
analysis, recording with radiological devices,Philippines
South Cotabato, findings and opinions of dentists,
anamnestic data, recorded in the material (hard copy) and inserted into folders.
Distribution of these data is very poor and problematic. They must be manually
transferred to any place where needed, they often lose, their value is little, if any, and
many of them simply–because of the nature of such a system–must re-enter or obtain
again.
Therefore, the electronic dental record is an important part of medical information
system in health facilities that include a dental office.
Presented solution for the electronic dental record is part of a medical information
system intended for use in primary care and as such meets the needs of both dental
clinics and smaller dental offices. When making this module, particular attention was
paid to the appearance of the user interface so that it now accurately reflects the look of
standard, printed dental records with the aim that the clinic staff as much as possible
facilitates the process of transition from the use of classical records to the use of
electronic ones.
Electronic record introduces new functionality to the document on paper where it
was not possible (detailed historical overview of the teeth, simplified invoicing of
services, data protection from unauthorized access, etc.). The quality of solution is
provided using the latest technologies such as ADO.NET Entity Framework to access
the database and the Windows Presentation Foundation to implement certain parts of
the user interface. An additional advantage provides already tested database server
Microsoft SQL Server 2005.
18 | P a g e
Comparison of the process of Cotabato,
South dentistsPhilippines
work with printed records and work
processes with electronic dental record shows a number of advantages of electronic
solutions. This fully justifies the initial cost of introducing an information system that
consists of the cost of computer equipment, software and training of medical personnel
for the new process of work.
Ten of the Top Dental Inventory Management Software Programs Reviewed by
Downs (2021). It’s best to pay attention to regional options when purchasing inventory
software for your dental office. Some of these software products are not available in all
countries, and it can be difficult to get on-site support depending on where you are
located. Make sure to call or email the company to get all your questions answered
before committing to an inventory control system. Talk to as many software companies
as necessary to find the one that is right for you. Once you are set up, you will notice
savings of time and money. A good software company will check in with you periodically
to see how the system is working for you, so look for a platform that provides excellent
customer service and support. You don’t want to find yourself without help when you
need it most. Check out each of those dental inventory software packages and start
getting your dental office organized and more efficient today. Managing inventory at a
dental office can mean the difference between blowing the budget and staying on
budget. Waste, expired products, lack of product, or delayed product can all stall the
progress of a busy dental clinic. Every dental office needs an inventory control system,
and some offices are still upgrading their old paper systems for new electronic inventory
systems.
19 | P a g e
Basic inventory management byCotabato,
South DonigerPhilippines
(2021).We have a lot of items in our
dental offices, and the list of supplies can be overwhelming. The question is: who is in
charge of keeping the inventory under control? As a team member, you would like all
the pieces in place when you start the day.
Who is the point person for ordering in your office? Who should order which
supplies? There should not be any blame game going on. You never want to be caught
in the middle with team members, with one thinking the other is responsible for
inventory control and supply purchase.
The easiest way is to have an accounting of necessary supplies so the practice
never runs short. You remember old Murphy and his law? A missed item never comes
at an opportune time. There is no phrase more catastrophic than, “We ran out of A2
composite.” Well, unless you need another shade and that one is missing too.
The dental office usually works on a teamwork model. As there is a place for
everything and everything has its place, there is a role for everyone and those roles
may be interchangeable or reliant on others for support. Inventory control involves
communication between all team members; it’s not merely one assistant’s responsibility.
Does your office have a protocol for inventory control? Is there a standard to
order? Do you have a preferred vendor list? These items are frequently told to
employees via word of mouth. Sometimes, new employees are randomly informed of
their duties and rely on the “telephone game” — Susie told Jane, Jane told Margaret,
Margaret told the new person. On rare occasions, the new person may not be informed
by anyone and be expected to miraculously deduce what is needed and where it is
20 | P a g e
ordered from. As we all know, this leads
South to major
Cotabato, disaster. There are also the major
Philippines
team members — the dentist, dental hygienist, and dental assistant. All of them know
what they’re doing and what they need, but where is it codified?
Dental office manuals, which set forth policies and procedures, should have a
section for inventory control. Discuss delegation responsibilities as well as protocol for
ordering. Setting up an ordering system is one way to help the office run smoother, and
ensures excellent communication between all team members. All items should be
assessed once a year, catalogued, and included in this very important system manual.
Dental products change. Your clinician’s preference may go from sticking with the
product used for 30 years, or changing with new technology each year. Regardless, it is
imperative that a master list be created. This way, if a new team member is hired, he or
she may check with the product catalogue and be aware of the need for each item.
Another reason for inventory assessment is to check for expired products. We
are not in charge of dental suppliers’ stockrooms. As we assume, they will send us the
freshest product available, we may have a short time usage for particular products. It is
also useful to assess and evaluate if the clinician is using certain restoratives. Offices
are only so large. It’s best to clean out supplies not used in a timely manner.
Establishing a routine of inventory control allows it to be reviewed periodically
during the month. This should definitely be part of a job description. Although everyone
should be knowledgeable about the products they routinely use, a point person should
do the actual supply ordering. It goes without saying that the dentist should be kept in
the loop about all products ordered. An inventory control template (Table 1) is an
21 | P a g e
example of how to catalogue the South
office. Once a
Cotabato, routine is established and the correct
Philippines
amount is decided upon, a monthly assessment of products on hand can be easily
determined. Ordering becomes easier and less stressful.
Chapter III
METHODOLOGY
This chapter presents the methods used to prevail the data of the system design
selection and description of respondents, research instruments, data collection
procedures, and statistical treatments employed.
Environment
Setting of the study
The study took place at South East Asian Institute of Technology, Inc. specific
only into library. Southeast Asian Institute of Technology, Inc. is a private school
located at Purok 2 Poblacion, Tupi, South Cotabato, 9505 and it is owned by Arenas
Family.
22 | P a g e
SOFTWARESouth
ENGINEERING METHODOLOGY
System Development Life Cycle was chosen as the initial methodology for the
development of the Dr. Arenas Dental Clinic appointment system with SMS
notification and service scale performance as its stages fits the requirements on its
development.
23 | P a g e
Software Development Life Cycle
South Cotabato, Philippines
Figure 3.1 Software Development Life Cycle (SDLC) Diagram.
24 | P a g e
Requirements Analysis South Cotabato, Philippines
This phase signifies the gathering of requirements. The researchers set an
interview with the nurse at the Dr, arenas dental clinic and gathered all the
information about the problem in their current manual system by interviewing and
observing. After gathering all the data needed. The researchers started to analyze
about the process on how they gather all manual research projects of the students.
Planning
In this stage the proponents plan to develop a Dr. Arenas Dental Clinic
appointment system with SMS notification and service scale performance. The team
determines the cost and resources required for implementing the analyzed
requirements. It also details the risks involved and provides sub-plans for softening
those risks.
Design
At this stage of the project the team must define the main features of the future
code. The team will develop and design a system that will provide the needs of
students, faculty and staff in the library. Researchers share responsibilities at the
stage of designing. Each person on the team is responsible for the design of a
certain part of the code.
Build
25 | P a g e
In this phase, the team start build
South the entire
Cotabato, system by writing code using the
Philippines
chosen programming language. After the decided design and features of the system,
the programmer starts to developing the system.
Coding Testing
In this stage, we test for defects and deficiencies. We fix those issues until the
product meets the original specifications. After the design and successful coding,
testing is performed to expose defects in the interfaces and in the interactions
between integrated components of the system.
Deployment/Maintenance
At this stage, where all the designing and coding is done to the system,
maintenance will cover up all those problems, that are being discovered while testing
the system. The plan rarely turns out perfect when it meets reality. Further, as
conditions in the real-world change, we need to update and advance the software to
match.
26 | P a g e
Planning/Conception-Initiation Phase
Business Model Canvas
Figure 3.2 Business Model Canvas
Gantt chart
27 | P a g e
South Cotabato, Philippines Janua
MONTH SEPTEMBER OCTOBER NOVEMBER DECEMBER
ry
WEEK 1
WEEK 2
WEEK 4
WEEK 2
WEEK 4
WEEK 1
WEEK 4
WEEK 2
WEEK 5
WEEK 3
WEEK 1
WEEK 3
WEEK 2
WEEK 3
WEEK 5
WEEK 1
WEEK 3
WEEK 4
WEEK 1
WEEK 2

REQUIREMENT
ANALYSIS

PLANING

DESIGN

BUILD

CODE TESTING

DEPLOYMENT/
MAINTENANCE

LEGEND
FINISHED
ONGOING
Table 3.1 Gantt chart.
Functional Decomposition Diagram
DR. ARENAS DENTAL CLINIC APPOINTMENT SYSTEM WITH SMS NOTIFICATION AND
SERVICE SCALE PERFORMANCE
28 | P a g e
MANAGE SERVICE MANAGE ADMINISTRATION

PATIENT MODULES PERFORMANCE MODULES0 MODULES
+
APPOINTMENT
DATA ANALYSIS SET APPOINTMENT
RESERVATION
DISPLAY SERVICE SCALE

SMS NOTIFICATION ADD CLIENT INFORMATION
PERFORMANCE
CONFIRMATION UPDATE AND DELETE CLIENT
STORE INFORMATION
Figure 3.3 Dr. Arenas Dental Clinic appointment system with SMS notification and service scale
performance Functional Decomposition Diagram.
29 | P a g e
Analysis Design Phase South Cotabato, Philippines
Use Case Diagram
Figure 3.4 Dr. Arenas Dental Clinic appointment system with SMS notification and service
scale performance Case Diagram.
30 | P a g e
Storyboard South Cotabato, Philippines
Open the Dr. Arenas Dental Clinic appointment system with SMS notification and
service scale performance.
INPUT USERNAME
AND PASSWORD
TO LOGIN
31 | P a g e
ADD CLIENT
SET APPOINTMENT FOR CLIENT
LIST OF PATIENTS
LIST OF APPOINTMENTS
ADD NEW SERVICE
LIST OF SERVICES
DATA ANALYSIS
32 | P a g e
LIST OF SERVICES AVAILABLE

IN DENTAL CLINIC
MONTHLY SERVICES
PERFORMANCE
TOTAL CLIENT
SERVICES CHART
Database Design
33 | P a g e
scale performance Database Design.
Entity Relationship Diagram
34 | P a g e
scale performance Entity Relationship Design.
35 | P a g e
DATA DICTIONARY South Cotabato, Philippines
APPOINMENT TABLE
Column Type Null Default Comments
appointmentID (Primary) int(11) No PK ID OF THE CLIENT
patientName varchar(100) No
appDate varchar(100) No
appTime varchar(100) No
appStatus varchar(100) No Pending
appService varchar(100) No
PATIENTS TABLE
Numberofpatients) int(11) No PK PATIENT NUMBER
patientName varchar(100) No
pateintAddress text100) No
birthdate varchar(100) No
patientContactNumber int(11) No
SERVICES TABLE
service_id int(11) No PK SERVICE NUMBER
36 | P a g e
service_type varchar(100) No
service_desc text100) No
service_charge double No
date_added timestamp No
count int(11)
USERACCESSLEVEL TABLE
userId int(11) No PK USER ID
dateAdded timestamp No
username varchar(100) No
password varchar(100) No
fullName varchar(100) No
role varchar(100)
37 | P a g e
Network Design South Cotabato, Philippines
Network design is the integration of different network devices to achieve end-to-
end communication between network hosts, and to identify what type of network is
going to be used in Dr. Arenas Dental Clinic appointment system with SMS
notification and service scale performance.
Network model
The network topology that will be used will be a peer-to-peer network. Dr. Arenas Dental
Clinic appointment system with SMS notification and service scale performance system is
an Offline platform that makes all resources available only in the admin/ personnel. The
network used wireless personal area network (PAN) connections.
Development/Construction/Build Phase
38 | P a g e
Technology stack (development)
WINDOWS Operating
System
JSP
XAMPPSERVER Database
NETBEANS
scale performance Technology Stack.
Software Specification
Operating System : Microsoft Windows 10
Hardware Specification
1. Processor : Intel(R) Celeron(R) CPU N3160 @ 1.60GHz
2. Hard Disk : 443GB
3. RAM : 4.00 GB
Program Specification
39 | P a g e
Language: : JSP South Cotabato, Philippines
Database : XAMPPSERVER
IDE : NetBeans Ide 8.0.2
List of Modules
Patient Modules
In these modules, a patient needs to reserve an appointment and wait for
confirmation.
Manage Service Performance Modules
Manage Service Performance modules will display the data analysis.
Manage Administration Modules
These admin-like modules give you a quick and easy way to manage the
appointment system.
References
40 | P a g e
Baque-Manalang Dental Clinic Online
SouthReservation. (2017, Oct 18). Retrieved from
https://customnotepads1.blogspot.com/baque-manalang-dental-clinic-online-
reservation-essay
Clemente, R., Fuensalida, L., Martinez, J., & Sañosa, R. (2017, March 1). Dental
Management Information System with Online Appointment and Billing System Through
SMS for Dra. Lumibao Dental Clinic. Https://Www.Academia.Edu/. Retrieved 2021, from
https://www.academia.edu/31589913/
College_of_Computer_Studies_IN_PARTIAL_FULFILLMENT_OF_THE_REQUI
REMENTS_OF_CS_CAPSTONE_PROJECT_DENTAL_MANAGEMENT_INFOR
MATION_SYSTEM_WITH_ONLINE_APPOINTMENT_AND_BILLING_SYSTEM
_THROUGH_SMS_FOR_DRA_LUMIBAO_DENTAL_CLINIC
Sanjib A. (2017). Dental Clinic Management System for Abokor Artan Dental Clinic and
Pharmacy. Academia.Edu. Retrieved 2021, from
https://www.academia.edu/37731980/Dental_Clinic_Management_System
Lotayo, J., Batuto, J., & Miasis, J. (2020, August 6). Dr. Joanne Sapotin-Lozano Dental
Clinic Management System. Capstone Guide. Retrieved 2021, from
https://capstoneguide.com/dental-clinic-management-system-capstone-project-
document/
Kwan, A. (2017). Dental Management System. Abstract, 01(33), 1–90.
http://eprints.utar.edu.my/1558/1/DENTAL_MANAGEMENT_SYSTEM.pdf
41 | P a g e
AMA Healthcare LLP. (2019). Dr. Rushin Mehta Philippines
South Cotabato, Dental Clinic Information Management
System. Http://Www.Techama.In/. Retrieved 2021, from
http://www.techama.in/Pdf/Dentalclinic.pdf
Tardieu, P. (2019, August). Dental and Medical Inventory, Order and Traceability
Management Software (+97143948222). Dr. Philippe Tardieu.
https://doi.org/10.4172/2332-0702.1000183
Masic, F. (2017). Information Systems in Dentistry. Acta Informatica Medica, 1(20), 47–
55.
https://doi.org/10.5455/aim.2017.20.47-55
Downs, T. (2021, June 4). Ten of the Top Dental Inventory Management Software
Programs Reviewed. Titan Web Agency. Retrieved 2021, from
https://blog.titanwebagency.com/dental-inventory-management-software
See Levin, R. 2004. Inventory control. Journal of the American Dental Association. 135(9):

1319–1320.
42 | P a g e
CURRICULUM VITAE South Cotabato, Philippines
ROMEJANE JOY R. DADO

Pantua, Zone 3, Koronadal, South Cotabato, 9506
Cell Number: 09502554335q
Email Address: romejane1628@gmail.com
PERSONAL INFORMATION:
Civil Status: Single
Date of Birth: July, 03, 1999
Dialect Spoken: Filipino, English, and Ilonggo
Religion: Roman Catholic
Father’s Name: Romeo D. Dado
Mother’s Name: Rhoda R. Dado
EDUCATIONAL BACKGROUND:
TERTIARY: Bachelor of Science in Information Technology
Major in Business Analytics
South East Asian Institute of Technology, Inc.
2018 – Present
SECONDARY
*SENIOR HIGHSCHOOL: Green Valley College Foundation Inc. – TVL

Km2, Bo.2, General Santos Drive,
Koronadal City, South Cotabato
2016-2018
*JUNIOR HIGHSCHOOL: Koronadal National Comprehensive High School (KNCHS)

Rizal Street, Koronadal City, South Cotabato
2012-2016
ELEMENTARY: Koronadal Central Elementary School 1 (KCES)

Rizal Street, Koronadal City, South Cotabato
2006-2012
43 | P a g e
GERSON A. CAGA South Cotabato, Philippines
Prk. 2, Tupi, South Cotabato, 9505
Cell Number: 09639461929
Email Address: cagajerson@gmail.com
Date of Birth: July 18, 1993
Dialect Spoken: Cebuano, Tagalog, English, Ilonggo
Father’s Name: Pedro M. Caga Sr.
Mother’s Name: Lydia A. Caga
2018 – Present
JUNIOR HIGH SCHOOL: Tupi National High School

Tupi, South Cotabato
2010-2011
ELEMENTARY: Santos Hill Elementary School

Tupi, South Cotabato
2006 – 2007
Hernan E. Trillano Jr.

Purok Vicente Fin, Brgy. Magsaysay,
44 | P a g e
Polomolok, South Cotabato, 9504 South Cotabato, Philippines
Cell Number: +639683057215
Email Address: hernantrilla@gmail.com
Date of Birth: August 26, 1999
Dialect Spoken: Filipino, English, Ilonggo, and Cebuano
Father’s Name: Hernan E. Trillano Sr.
Mother’s Name: Ailyn E. Trillano
2018 – Present
JUNIOR HIGH SCHOOL: Poblacion Polomolok National High School

SHS – Science, Technology, Engineering and Mathematics
2012-2018
ELEMENTARY: Polomolok Central Elementary School

2007-2012
APPENDICES
PROJECT PROPOSAL
45 | P a g e
Name of Proponents: CAGA, GERSON A.

DADO, ROMEJANE JOY R.
TRILLANO, HERNAN JR., E.
1.0 Proposed Case Study Title
DR. ARENAS DENTAL CLINIC APPOINTMENT SYSTEM WITH

SMS NOTIFICATION AND SERVICE SCALE PERFORMANCE
2.0 Area of Investigation
E & R Arenas Dental Clinic, Tupi
3.0 Cited Problems
3.1 Dr. Arenas Dental Clinic has no available automated system to

forecast future service scale performance.
3.2 The dental clinic staff is doing all transactions as well as the
appointment manually.
3.3 The loss of patient records may lead to misconception and errors.
3.4 Setting an appointment is not organized and time consuming.
3.5 The Dr. Arenas Dental Clinic doesn’t have a real-time schedule of
availability.
3.6 Dr. Arenas Dental Clinic doesn’t have monitoring scales on its
offered services.
4.0 Method of Research
Interview and Observation
5.0 Functions of the Proposed Title
46 | P a g e
The proposed project seeksSouth
to optimize
Cotabato,the service performance of
Philippines
Dr. Arenas Dental Clinic through the organized representation and
elaboration of data using an Appointment System with SMS
Notification.
6.0 Features of the Proposed System

6.1.1 User-Friendly Interface
6.1.2 Accurate Calculation and Service Report
6.1.3 Customizable Panel for Graphical Reports
6.1.4 Data Visualization
6.1.5 Hassle Free Appointment
6.2 Programming Language and Database
6.2.1 Front End:

Programing Language: Java
6.2.2 Back End:

Database Language: MySQL
7.0 Reason for the Choice

To create an automated appointment system that features the scale
performance of a dental clinic that will secure and provide fast access to
record of patient transactions.
8.0 Target Users / Beneficiaries

 Dr. Arenas Dental Clinic Admin
 Personnel
 Patient
QUESTIONNAIRES
47 | P a g e
The following are the questions that has
South been ask
Cotabato, to the admin during the interview to
Philippines
gather information about the Dr. Arenas dental clinic and determine the problems:
1. What is the current situation in the dental clinic?
2. What are the problems encountered in the dental clinic with the current
process?
3. What are the services you offered?
4. How do you set the appointment?
5. Where do the record the patients report?
MAP OF RESEARCH ENVIRONMENT
Dr. Arenas Dental Clinic
48 | P a g e
49 | P a g e

Rationale of The Study: South East Asian Institute of Technology College of Information and Communication Technology

Uploaded by

Copyright:

Available Formats

Rationale of The Study: South East Asian Institute of Technology College of Information and Communication Technology

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Rationale of The Study: South East Asian Institute of Technology College of Information and Communication Technology

Uploaded by

Copyright:

Available Formats

What problems are encountered in Dr. Arenas Dental Clinic?

What problems are encountered in Dr. Arenas Dental Clinic?

What services does Dr. Arenas Dental Clinic offer?

What services does Dr. Arenas Dental Clinic offer?

SOUTH EAST ASIAN INSTITUTE OF TECHNOLOGY

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

RATIONALE OF THE STUDY

information, making mistakes while writing, or misplacing the files.

that can help dental practices facilitate online bookings.

As healthcare workers are experiencing an increase in their workload, a patient

appointments scheduled in advance, healthcare facilities can plan resource allocation in

dentist's performance and business is also hard. Typically, an appointment system

OBJECTIVES OF THE STUDY

reservations with SMS notification and to display data analysis.

a) To develop an automated forecasting system that can classify the services

offered by Dr. Arenas dental clinic.

Arenas dental clinic.

Arenas dental clinic.

dental clinic services.

SCOPE AND LIMITATIONS OF THE STUDY

the Dr. Arenas dental clinic.

The prototype can be used by dental admin to manage the appointments of

administrators by accessing information for reporting purposes.

The system administrator needs to maintain the records of patients. A user

schedule as confirmation that they already have an appointment.

restricts accounting and finance. It simply functions as an appointment and transaction

SIGNIFICANT OF THE STUDY

significance for the following:

organized, simplified but effective appointment system. It will be of great assistance in

their day-to-day operations easy. It will be an instrument to make it more competitive in

more loyal patients.

while the system will serve as their guide in development.

to help them monitor their dental information.

solutions to implement an effective system to solve the problems of the company.

FLOW OF THE STUDY

INPUT PROCESS OUTPUT

data patient data  Service

 Input service  Service performance

deceased person, debtor, or other individual, or of an insolvent company. It refers to the

person managing or in charge of the system of the dental clinic.

Appointment Handling-the process of checking all the necessary information needed

Appointment-the act or process of entering information about something into a book or

system of public records.

Owner/Doctor-the term refers to a person who is able to do planning, organizing,

and does services for the clinic.

Patient records-organized data of a patient’s profile.

any given level of actual performance for such Performance Measure.

recounting certain events in a widely presentable form.

System-standalone application in which this system is just to save the data as

improving the current system in part of recording patient tooth treatment.

transactions which occur somewhere else.

Related Literature and Studies

develop their proposed system more effectively.

Dr. Joanne Sapotin-Lozano Dental Clinic Management System by Lotayo et al.,

(2020) Dental Clinic is an organization that is responsible in providing a health

application. It is because there are facing several problems during process

Dental Management Information System with Online Appointment and Billing

patientcare properly maintained patient record by the Dentist Secretary is a very

to acts as a source of reference and a tool by which an organization is governed. The