We have built a simple hospital DBMS, that manages relations between the different entities in a hospital like wards, doctors, patients and users. Our database allows users to insert update and delete these entities.
We have decided to create a simple HOSPITAL database for maintaining information regarding Patients, doctors and wards in a hospital environment, as well as the ways these entities are related to one another. The database contains 5 tables such as Patient, Ward, Doctor, Treats, Works_For and 2 extra tables: Users and Logging which help keep track of the people handling the database. The GUI allows non specialist users to manage the system in an organized way.
The following are the actions users can carry out in the system
- Carry our CRUD on the information of a doctor, ward, patient or a user
- Add/Delete treatments which link doctor and patient.
- Assign/Release doctor to work for a ward.
- View patients residing in a specific ward.
- View patients being treated by a specific doctor.
Project is created with:
- NetBeans IDE 8.2
- jawa swing library
- JDCB API
- Oracle SQL developer
