Today, I am gonna publish my first database project which is based on hospital management.
Here’s a brief video on it:
It involves the below list of tables (with mentioned structure):
Please find below the lucid chart for better explaination:
I have provided sql files for table creations which includes the sample data to be inserted for PATIENT, PATIENT_DIAGNOSIS and DOCTOR.
Apart from this, I have also included the trigger/sequence file which includes the trigger/sequence creation statements along with the sample insertions for fine table in which we only need to insert value for columns BILL_NO and AMOUNT and the remaining details are fetched automatically using triggers from the status tables ( PATIENT, PATIENT_DIAGNOSIS and DOCTOR).
Here’s the link for all files: CLICK HERE (Github Repository)
If you liked the stuff, please leave positive comment and in case you have any feedback, feel free to share that in comments!
5 thoughts on “Hospital Management System (Using Database)”
Hospital Management System and Healthcare Informatics. Spigot drive you a right path
Sir, kindly post the source code
Hey Harsha the link was mentioned at the bottom of the page – https://github.com/shubhamgulati12/DatabaseHospitalManagement
Sir can you please post the source code for front end?
Can you please share the source code?