Hospital management database
This type of project is a more complex database and it can allow you to deal with the working of a hospital or any other medical setup. It should keep records of patients, doctors, and rooms, which can then be queried and used. If this database was to expand, there could be separate modules for hospital admission, patients’ summary, duties of nurses, medical stores, etc.
We will have the following data in this database:
- Patients information: name, surname, date of birth, SSN, insurance number, age, etc.
- We can have records for the patient's chronic diseases
- Doctor's information: name, surname, date of birth, employment date, specialty, salary, etc.
- Patient's treatments and doctor consultations - date, patient Id, doctor Id, notes from the consultation, diagnosis
- Rooms in the hospital can be managed by keeping data about roomNumber, category (operation hall, doctor's office, etc.), availability, etc...
A bonus for this project is if you go a step further and do actual hospital departments, with specialist doctors, and all available treatments for patients.
Query examples: 1. Find all the doctors employed for more than 5 years, that have treated patients with diagnosis X in the past 10 days.
- Find all the patients younger than 45 that have not come to the hospital in the past year.
For the purpose of this tutorial, we will show you a shortened example of the hospital database ER diagram, that according to the needs can be extended into a larger database.
