Healthcare System

Introduction

Project Description

Our project is about a healthcare system depended on a hospital automation system on a website. This is a system that takes all the information recorded which from our databases and combines them in a controllable way. It includes all doctors, nurses, patients, health personals, employees, administrative personals and all the information about them. It also contains inventory levels of the every department that a hospital have. In other words, it is a database system that takes all information about a hospital and its parts and arranges them from just one server. Thanks to this system, these databases can be controlled and can be accessible online depending on given permissions, so privileges given to the users are important.

Benefits of the Project

• The project provides and inner integrated hospital system with that all information is gathered in one program.
• Brings easiness for doctors, patients and employees with the modules of their own. People can arrange their schedule easily.
• With the plus of online usability of the program, reaching data from anywhere is possible so doctors, patients and employees can take advantage of the system like patients can check their results from online and can get an appointment from a doctor that can be chosen or employees can arrange information out of work.
• With inventory tracking, managers and supervisors can easily control supply chain movements.
• Any errors can be noticed via tracking records from database.
• All paper work can be hold online, therefore there is less effort required for the hospital organization. Since hospitals are profitable companies, in the long term this system can make a big difference.

Technical Documentation

Software

The technologies we used for healthcare system are:

• NetBeans IDE for Web Application Program
• Glass Fish for Web Application Server
• SqlBuddy for Web Applications Database Program
• WampServer for Applications Database Server
• HTML and CSS for Design
• JSP and Servlets for Web Application Language
• MySQL for Database Language

Hardware

For this application design, we worked locally first in our computers because of the small budget we have and because of that we didn’t used a real server. But in real life for applying this project the hospital should obtain a webserver since it is an inner integrated system. Also from the other chain hospitals, the information like patient records can be reached, so a server is a must. There is no need for software deployment in the computers on the hospitals, because it is a web application and it can be reached via an internet connection.

Database of the System

There are 9 tables and two different connection network this project's database has. First is the doctor and patient's connection for test results and appointments. Second is for employee which is connected the inventory via departments. Here are the two entity relationship diagrams of the database that we used for this project:

Doctor & Patient Diagram:

Employee & Inventory Diagram:

Additional information: The appointment module is handled by dp_relation.