Dental Clinic Reservation System

Abstract:

Clinic Reservation System (CRS): When a patient opens hisher PC or ODA to schedule a new appointment or change an existing appointment, the system first asks for the person’s name and password (if they have one) to see if they are an existing patient. The patient provides this information and the system checks the patient Database to see if they are a current patient. CRS will add a new patient by an application form which the patient must fill in. Then, CRS will add all of this new patient information to the patient DB. Finally, CRS will create a password for the new patient and provide this password for the patient for future use.

CRS allows the patient to make an appointment. The system checks the Appointment Schedule DB for an available day and time and gives the patient a list of possible appointments. The patient provides the system with the chosen appointment (Appt ID) and provides their password once more. CRS sends the chosen appointment to the doctor to confirm the appointment if heshe can see the patient. If the doctor confirms the appointment, he will send the invoice to the billing system for payment.

Scope:

The scope of our project is to implement a system which automates clinical reservation in order to ease, improve efficiency, and protect the process from common errors.

Objectives:

• Create a system that will reduce the time consumed and error in the reservation process.

• Create a system that that will reduce the operational cost of the company.

• Create a system that will ease the reservation process by making it possible from any place where the access to the Internet is provided.

• Automate the process of reserving appointments at clinics

• Reach the 20th century standards and globalization of efficient use of technology.

• Improve customer satisfaction.

Advantage:

• Facilitate patient reservation for an appointment through the web browser.

• Reduces miscommunication issues.

• Save time.

Limitations:

• More options are required such as the ability to cancel a reservation or to change its date.

• Better interface design.

4.2 Project tools

CoffeeCup

CoffeeCup is a website provides the users with web design software and services so they can make better Websites. one of the tool (building forms) allows rapid and non-technical forms development. It is simply drag and drop editor that enable you to design sophisticated web forms and applications. A form may consist of tools enables you to view a layout of each page as you work. It also allows you to set properties, behaviors, and workflow associated with the form, page or objects. SQL Server 2008

SQL Server Management Studio (ssms) is a software application first launched with the Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server. A central feature of SQL Server Management Studio is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server. Microsoft Visio

Formerly known as Microsoft Office Visio, is a commercial diagramming program for Microsoft Windows that uses vector graphics to create diagrams. Due to its proprietary file format, few other programs can read Visio files. However, Visio can read and write files as VDX files. VDX is a XML Schema based (“DatadiagramML”) and well documented file format. With VDX it is possible to work with an XML based file format without the need to use the old binary file format VSD. Microsoft Office Word

Microsoft Office Word It is a component of the Microsoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. Among its features, Word includes a built-in spell checker, a thesaurus, a dictionary, and utilities for manipulating and editing text. The following are some aspects of its feature set: WordArt, Macros, Bullets and numbering, and AutoSummarize

Aviary Screen Capture

Aviary helps to incorporate editing features such as color, image and effect. We use it as a very simple screen capture tool. It Captures any webpage by adding Aviary.com/ to the beginning of the URL. It takes the shot along the page. Adobe Photoshop

Adobe Photoshop is a graphics and image editing program developed and published by Adobe Systems.

4.3 Tables

The following figures represents the SQL database we used in our system to add, delete, update, and select.

4.4 User manual

The following figures show the steps the patient goes through to complete a registration process.

The first figure is the log in form; if the patient already has an account in the system he/she enters their ID and enters the system

Log in form:

The next form is for new patients, if the patient does not have an account he/she should complete this form to get an ID to be able to enter the system

Registration form:

The following two figures illustrate how the registration form is filled,

When the patient enters his/her birth date, a calendar will pop out to choose from

Here, a validation error occurs, if the phone number field is left empty it will be bordered with red lines and an error message appears telling the patient that this field is required.

After completing registration, the patient now can make an appointment

Appointment form:

This is how the form looks like; first, the patient will choose a department,

Then he/she will choose the doctor they would like to see,

Then they will select a date from the pop up calendar, the system automatically submits the available dates of the specified doctor, making it easier for the patient to choose a possible date,

Finally, the patient is asked if they would like to confirm the appointment. Then click on the submit button to finish he reservation process;

The final form shows the doctors side of the system, after seeing the patient; the doctor will fill the invoice form with the specified fields then click on send to submit the invoice.