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 Platform
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 table.
Modules of the System
We have for main modules for our project. First module is patient appointment and test result module, which allows patients to make appointments from their home or office at their desired time. With patient module, patients are no longer need to wait in the lines for seeing their test results or making appointments.
Second module is inventory module which allows that to the all employees can make transactions on their departments. Also managers and supervisor can check for inventory results whenever they want by department depending on their privileges.
With third module, admission module, newly coming patients can be registered with just one click from admission table. An automatic and random password created for patients for logging in the website because of usage for appointment and test results module.
Lastly for doctors, there is a doctor module created, which allows doctors to entering the test results for patients. Also they can see their schedule for the patients that previously created appointments.
Admission Module
This is the page that the person from admission table can log in:
The next function is modifying existing patients’ information. It is done via 2 pages, at first admission chooses the patient and after clicking next, the patient’s information comes. The last function in admission is resetting calendar. At every week’s end, admission person can reset the calendar for patients and doctors so they can arrange new appointments next week.
Doctor Module
This is the page that all users except admission can log in:
After logging in as doctor, the main page comes as this:
For doctor, there are 4 functions exist: Personal Information, See appointments, Record Patient’s Test Results and Changing Password.
Clicking on the see appointments button, user’s appointment’s seems like:
For patient’s test result, there exist two scroll bars; one of them is for choosing the type of the report, other one is for choosing the patient, and a text box for entering the report:
Patient Module
For patient module, there are two different main function exists: Arranging Appointments and See Test Results. On click Arrange Appointment this example page comes:
After clicking add new appointment, the scroll bar of the available doctor’s comes, and after selecting the doctor wanted, selecting time table comes. Already appointed times are disabled:
Other option for appointment module is deleting the existing appointments. On clicking the delete appointment button, a scroll comes with the already appointed times. It can be deleted from this page.
Last function for the patient’s is seeing test results. After clicking the test results button on the left menu, the reports that had been entered from doctors comes, and after selecting the report wanted, it comes as this:
Employee Module
For employee module; there are 6 main functions: adding and modifying doctor information, adding and modifying employee info and adding and modifying inventory information. Also these functions depend on the privileges employee have. For example a driver’s main page looks like this:
But a privileged user like supervisor can manage the other information. An example add doctor page with the scrolls of department and specialty:
Modify doctor function consists of 2 pages, firstly a scroll comes for the choosing the desired doctor, second is a table coming with old information of employee:
As like as add and modifying doctor information, employee add and modify functions works similar.
Add inventory and modify inventory works as well the other two. The only difference is between in them for because of the changing inventories in the department, it should firstly choose department, after choosing department the inventory scroll comes. Lastly, the inventory modification can be done in the areas with amount, min. amount and max amount. When amount goes down from min amount, a warning goes to specific employee which is tasked for:
Team Members
GORKEM MARAL & OZGUR ALP
[[File:Photo_May_09,_18_01_47.jpg]
