The Dentist Online Reservation System

The Dentist Online Reservation System Design and Implementation 

Web Based Application and Database Management System Project 

1. Introduction 
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 online dentist reservation system, the process gets
much faster and more efficient than traditional way. Thousands of business and organizations have already
discovered the advantage gained by using the online reservation system. [4] Online dentist reservation
system allows the system administer to access and manage the database online, quickly pull data and create
strong reports right from the online reservation system with most practical to find the fastest information,
instead of having to maintain and manage separate data files, folders and spreadsheets. They simply navigate
to the system just as any Web Site. The data will be housed securely and safely online. 


2. Scope and Objective 
The scope of this project will focus on the patients and dentist who will use the system, to make the
appointment via online service. This project will be implements for a small Dental clinic. The prototype can
be used by the dentist to manage the appointment for the patients those who would like to do the
appointment for the dentist date via online system anytime and anywhere.
The proposed system will save the effort and the time of patients from waiting to make the appointment
as well as reduce the work of system administrator to access to information for report and easier to manage
the appointment. The system administrator needs to maintain the record of patients. Patients should be able
to know the availability a particular date. They should be able to reserve the available rooms according to
their need in advance. In this project, the dentist will play as the role of administrator. The dentist can update,
delete and add the patients’ information, appointment schedule and record of patients’ booking online easily.



3. Web Application Architecture 
Within the mobile computing sector, web applications are different from native applications which are
developed for a particular platform or device and installed on that device. The two are not mutually exclusive
because many applications contain elements of both native and Web application. A web application can be
divided into three different layers. Presentation layer which forms the first tier of the application consists of
web server and the web browser, which is responsible for assembling the data into presentable format.
Application layer constitutes the second tier of the application and is consisting of server side program and
scripts. Finally the third tier provides the programmable access to the databases. When a user which is first
tier, send a request to the web server, web server process the request which is second and third tier, formats
the result and finally sends the formatted results from first tier to the client. In this process server side scripts
play a very important role of processing the users request and in the generation of dynamic pages, based on

user and its input.

4. Requirement and Design 
The system should be able to satisfy the requirement in keeping the records of the patients safely,
patients should be able to know the availability schedule of dentist, patients should be able to book for an
appointment online anytime and anywhere, patients should be able to check their appointment schedule
online. The system design is for making decision, for the system operation for the software, hardware and for
network infrastructure. [1] The first step in the design phase is to develop the design strategy. The interface
design specifies how the users moved through the system. The database and file specifications define what
data stored and developed. To describe the whole structure of the system, object oriented approach
implemented in the system’s requirement design by the representation of use case diagram and class diagram.

5. Result Discussion 
This stage present the usability of the proposed evaluated and the user solidification determined. The
proposed system was tested by running the system on the Mozilla Firefox and Internet Explorer with the
local host server. The user evaluation of the prototype was conducted on 20 students from Rangsit University
International College. Each of them was given brief explanation regarding the usage and the user interface of
the prototype, test the system, and answer the survey questionnaire. The questionnaire consists of 10
questions to assess the user satisfaction and to prove the usability of the proposed system. Figure 7 shows the
result and level of usability of the system based on the feedback of 20 students. The result shows high
number of users agrees that system is usable, helpful and meet the main objective of the project.