Scribd
Upload
10 views57 pages

Hospital Management System Project 2024

The document outlines a Hospital Management System (HMS) project submitted by students from Veer Savarkar Sarvodaya Kanya Vidyalaya for the session 2024-25. It includes an introduction to the HMS, objectives, MySQL table structures, source code, and functionalities for managing doctors, patients, and staff. The project aims to automate hospital operations, improve patient experience, and streamline data management across departments.

Uploaded by

Mannat 25
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views57 pages

Hospital Management System Project 2024

The document outlines a Hospital Management System (HMS) project submitted by students from Veer Savarkar Sarvodaya Kanya Vidyalaya for the session 2024-25. It includes an introduction to the HMS, objectives, MySQL table structures, source code, and functionalities for managing doctors, patients, and staff. The project aims to automate hospital operations, improve patient experience, and streamline data management across departments.

Uploaded by

Mannat 25
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Hospital

Management
System
VEER SAVARKAR SARVODAYA
KANYA VIDYALAYA NO.1
Kalkaji new delhi-19

Session 2024-25
Hospital management

SUBMITTED BY: SUBMITTED TO:


BHUMIKA SHARMA MS. PURNIMA KHURANA
LECTURER(CS)

MAMTA SHARMA

HARSHITA
ACKNOWLEDGEMENT

I would like to express my special thanks of


gratitude to my Computer Teacher “Ms. Purnima
Khurana” for her able guidance and support in
completing this project. I would also like to extend
my gratitude to our principal “Ms. Sandhya
Yadav” for providing me with all the required
facilities

DATE: CANDIDATE:
certificate

This is to certify that Bhumika Sharma, Mamta


Sharma, Harshita of class XII A has successfully
completed the project work of computer science
titled “Hospital Management” for the session
2024-25. It is further certified that this project is
the group work of candidates and under guidelines
as issued by CBSE.

EXAMINER SIGNATURE
content
S. no. Table of contents Page no.

01
1. INTRODUCTION
02
2. OBJECTIVE
03-06
3. MY SQL TABLE
07-30
4. SOURCE CODE
31-49
5. OUTPUT
50
6. CONCLUSION
51
7. BIBLIOGRAPHY
introduction
The Hospital Management System (HMS) is
designed for any hospital to replace their existing
manual-paper based system. This system targets to
provide complete solution for hospital and health
care services. This system can be used in any
Hospital, Clinic, Diagnostics or Pathology labs for
maintaining patient details and their test results. It
integrates the entire resources of a hospital into
one integrated software application.
Objective
A Hospital Management Software designed to manage
all the areas of a hospital such as medical, financial,
administrative and the corresponding processing of
[Link] main objectives of the system are:

• Computerize all the details of the patient and


hospital.
• To perform automation of workflows
• Design a system to improve patient experience
• Connect all departments on a single platform and
bring in better coordination across.
• Provide the administration with a single point to
retrieve any data
• Reduce hospital operating cost.
mysql
DOCTOR

PATIENT
OTHER STAFF

EQUIPMENTs
MEDICINEs
python code
#HOSPITALMANAGEMENT SYSTEM
import [Link]
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",\
charset="utf8")
mycursor=[Link]()

# function to insert details of doctor


#DOCTOR TABLE
def insert1():
try:
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",charset="utf8")
Doctor_ID=input("Enter the Doctor_ID:")
Name=input("Enter your Name:")
Ph_no=int(input("Enter the Phone No:"))
Gender=input("Enter the Gender:")
DOB=input("Enter DOB:")
Designation=input("Enter your Designation:")
Salary= int(input("Enter the Salary:"))
Aadhar_no=input("Enter Aadhar No:")
Experience=input("Enter the Experience:")
data=(Doctor_ID,Name,Gender,DOB,Ph_no,Aadhar_no,Designation,Salary,
Experience)
mycursor=[Link]()
query="INSERT INTO Doctor values (%s,%s,%s,%s,%s,%s,%s,%s,%s)"
[Link](query,data)
[Link]()
print([Link],"Record Inserted Successfully!!")
[Link]()
[Link]
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")
#function to update details of doctor
def update1():
try:
Doctor_ID = input("Enter the Doctor_ID to be updated: ")
query = "SELECT * FROM Doctor WHERE Doctor_ID = %s"
[Link](query, (Doctor_ID,))
r = [Link]()
if r:
Name = input("Enter the Name:")
Experience = input("Enter the Experience:")
Ph_no = int(input("Enter Phone No:"))
update_query = "UPDATE Doctor SET Name = %s, Experience = %s,
Ph_no= %s WHERE Doctor_ID = %s"
[Link](update_query, (Name, Experience, Ph_no, Doctor_ID))
[Link]()
print([Link], "Record Updated Successfully!!")
[Link]()
[Link]()
else:
print("ID not Found")
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

# function to delete details of doctor


def delete1():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Doctor_ID = int(input("Enter the Doctor_ID:"))
mycursor = [Link]()
query = "SELECT * FROM Doctor WHERE Doctor_ID = %s"
[Link](query, (Doctor_ID,))
r = [Link]()
if r:
query1 = "DELETE FROM Doctor WHERE Doctor_ID = %s"
[Link](query1, (Doctor_ID,))
[Link]()
print([Link], "Record Deleted Successfully!!")
[Link]()
[Link]()
else:
print("Record not found!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to display details of doctor


def display1():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
print("1. To search by Doctor_ID")
print("2. To search by Name")
print("3. Display all Records")
choice2 = int(input("Enter your searching choice: "))
mycursor = [Link]()
if choice2 == 1:
doctor_id = input("Enter the Doctor_ID to be Searched: ")
query = "SELECT * FROM Doctor WHERE Doctor_ID = %s"
[Link](query, (doctor_id,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Doctor_ID.")
elif choice2 == 2:
name = input("Enter the Name: ")
query = "SELECT * FROM Doctor WHERE Name = %s"
[Link](query, (name,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Name.")
elif choice2 == 3:
query = "SELECT * FROM Doctor"
[Link](query)
results = [Link]()
if results:
print("Doctor_ID| Name |Gender| DOB | Phone Number |
Aadhar_no| Designation | Salary | Experience | ")
for row in results:
print(row)
else:
print("No records found in the Doctor table.")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to insert details of doctor


#PATIENT TABLE
def insert2():
try:
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",charset="utf8")
Patient_ID=input("Enter Patient ID:")
Name=input("Enter Patient Name:")
Gender=input("Enter the Gender:")
DOB=input("Enter DOB:")
Ph_no=int(input("Enter Phone No:"))
Aadhar_no=input("Enter Aadhar No:")
Med_history=input("Do you have any Medical History? Yes/No:")
Doctor_ID=input("Enter Doctor ID:")
data=(Patient_ID,Name,Gender,DOB,Ph_no,Aadhar_no,Med_history,Doctor_ID)
mycursor=[Link]()
query="INSERT INTO Patient values(%s,%s,%s,%s,%s,%s,%s,%s)"
[Link](query,data)
[Link]()
print([Link],"Record Inserted Successfully!!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to update details of doctor


def update2():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Patient_ID = input("Enter the Patient_ID to be updated:")
mycursor = [Link]()
query = "SELECT * FROM Patient WHERE Patient_ID = %s"
[Link](query, (Patient_ID,))
r = [Link]()
if r:
Name = input("Enter Name: ")
Ph_no = int(input("Enter Phone No:"))
Doctor_ID = input("Enter Doctor_ID:")
query1 = """UPDATE Patient SET Name = %s, Ph_no = %s, Doctor_ID =
%sWHERE Patient_ID = %s"""
[Link](query1, (Name, Ph_no, Doctor_ID, Patient_ID))
[Link]()
print([Link], "Record Updated Successfully!!")
[Link]()
[Link]()
else:
print("ID not Found")
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")
#function to delete details of doctor
def delete2():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Patient_ID = input("Enter Patient_ID:")
mycursor = [Link]()
query = "SELECT * FROM Patient WHERE Patient_ID = %s"
[Link](query, (Patient_ID,))
r = [Link]()
if r:
query1 = "DELETE FROM Patient WHERE Patient_ID = %s"
[Link](query1, (Patient_ID,))
[Link]()
print([Link], "Record Deleted Successfully!!")
[Link]()
[Link]()
else:
print("Record not found!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to display details of doctor


def display2():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
print("1. To search by Patient_ID")
print("2. To search by Name")
print("3. Display all records")
choice2 = int(input("Enter your searching choice: "))
if choice2 == 1:
patient_id = int(input("Enter the Patient_ID to be searched: "))
query = "SELECT * FROM Patient WHERE Patient_ID = %s"
[Link](query, (patient_id,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Patient_ID.")
elif choice2 == 2:
name = input("Enter the Name: ")
query = "SELECT * FROM Patient WHERE Name = %s"
[Link](query, (name,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Name.")
elif choice2 == 3:
query = "SELECT * FROM Patient"
[Link](query)
results = [Link]()
if results:
print("Patient_ID| Name |Gender| DOB | Ph_no | Aadhar_no
|Medical History| Doctor_ID |")
for row in results:
print(row)
else:
print("No records found in the Patient table.")
else:
print("Invalid choice! Please choose a valid option.")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")
#function to insert details of doctor
#STAFF TABLE
def insert3():
try:
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",charset="utf8")
Staff_ID=input("Enter Staff ID:")
Name=input("Enter Staff Name:")
Gender=input("Enter the Gender:")
DOB=input("Enter DOB:")
Ph_no=int(input("Enter the Phone No:"))
Aadhar_no=input("Enter Aadhar No:")
Work_type=input("Enter Work Type:")
Salary= int(input("Enter the Salary:"))
data=(Staff_ID,Name,Gender,DOB,Ph_no,Aadhar_no,Work_type,Salary)
mycursor=[Link]()
query="INSERT INTO Other_Staff values(%s,%s,%s,%s,%s,%s,%s,%s)"
[Link](query,data)
[Link]()
print([Link],"Record Inserted Successfully!!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to update details of doctor


def update3():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Staff_ID = input("Enter the Staff_ID to be updated:")
mycursor = [Link]()
query = "SELECT * FROM Other_Staff WHERE Staff_ID = %s"
[Link](query, (Staff_ID,))
r = [Link]()
if r:
Name = input("Enter the Name: ")
Ph_no = int(input("Enter the Phone no:"))
Work_type = input("Enter the Work Type:")
query1 = """UPDATE Other_Staff SET Name = %s, Ph_no = %s, Work_type=
%s WHERE Staff_ID = %s"""
[Link](query1, (Name, Ph_no, Work_type, Staff_ID))
[Link]()
print([Link], "Record Updated Successfully!!")
[Link]()
[Link]()
else:
print("Id not found")
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to delete details of doctor


def delete3():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Staff_ID = input("Enter your Staff_ID:")
mycursor = [Link]()
query = "SELECT * FROM Other_Staff WHERE Staff_ID = %s"
[Link](query, (Staff_ID,))
r = [Link]()
if r:
query1 = "DELETE FROM Other_Staff WHERE Staff_ID = %s"
[Link](query1, (Staff_ID,))
[Link]()
print([Link], "Record Deleted Successfully!!")
[Link]()
[Link]()
else:
print("Record not found!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to display details of doctor


def display3():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
print("1. To search by Staff_ID")
print("2. To search by Name")
print("3. Display all records")
choice2 = int(input("Enter your searching choice: "))
if choice2 == 1:
staff_id = int(input("Enter the Staff_ID to be searched: "))
query = "SELECT * FROM Other_Staff WHERE Staff_ID = %s"
[Link](query, (staff_id,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Staff_ID.")
elif choice2 == 2:
name = input("Enter the Name: ")
query = "SELECT * FROM Other_Staff WHERE Name = %s"
[Link](query, (name,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Name.")
elif choice2 == 3:
query = "SELECT * FROM Other_Staff"
[Link](query)
results = [Link]()
if results:
print("Staff_ID| Name |Gender| DOB | Phone Number | Aadhar_no |
Work Type | Salary |")
for row in results:
print(row)
else:
print("No records found in the Other_Staff table.")
else:
print("Invalid choice! Please choose a valid option.")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to insert details of doctor


#EQUIPMENTS
def insert4():
try:
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",charset="utf8")
Eqp_ID=input("Enter Eqp_ID:")
Name=input("Enter Equipment Name:")
DOP=input("Enter the Date of Purchase:")
Qauntity=int(input("Enter the Qauntity:"))
Staff_ID=input("Enter Staff_ID:")
data=(Eqp_ID,Name,DOP,Qauntity,Staff_ID)
mycursor=[Link]()
query="INSERT INTO Equipment values(%s,%s,%s,%s,%s)"
[Link](query,data)
[Link]()
print([Link],"Record Inserted Successfully!!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to update details of doctor


def update4():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Eqp_ID = input("Enter the Eqp_ID to be updated:")
mycursor = [Link]()
query = "SELECT * FROM Equipment WHERE Eqp_ID = %s"
[Link](query, (Eqp_ID,))
r = [Link]()
if r:
Name = input("Enter the Name:")
Staff_ID = input("Enter the Staff_ID:")
Quantity = input("Enter the Quantity:")
try:
Quantity = int(Quantity)
except ValueError:
print("Quantity must be an integer.")
return
query1 = """UPDATE Equipment SET name = %s, Staff_ID = %s, Quantity
=%s WHERE Eqp_ID = %s"""
[Link](query1, (Name, Staff_ID, Quantity, Eqp_ID))
[Link]()
print([Link], "Record Updated Successfully!!")
[Link]()
[Link]()
else:
print("Id not found")
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")
#function to delete details of doctor
def delete4():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Eqp_ID = input("Enter your Eqp_ID:")
mycursor = [Link]()
query = "SELECT * FROM Equipment WHERE Eqp_ID = %s"
[Link](query, (Eqp_ID,))
r = [Link]()
if r:
query1 = "DELETE FROM Equipment WHERE Eqp_ID = %s"
[Link](query1, (Eqp_ID,))
[Link]()
print([Link], "Record Deleted Successfully!!")
[Link]()
[Link]()
else:
print("Record not found!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to display details of doctor


def display4():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
print("1. To search by Eqp_ID")
print("2. To search by Name")
print("3. Display all records")
choice2 = int(input("Enter your searching choice: "))
if choice2 == 1:
eqp_id = int(input("Enter the Eqp_ID to be searched: "))
query = "SELECT * FROM Equipment WHERE Eqp_ID = %s"
[Link](query, (eqp_id,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Eqp_ID.")
elif choice2 == 2:
name = input("Enter the Name: ")
query = "SELECT * FROM Equipment WHERE Name = %s"
[Link](query, (name,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Name.")
elif choice2 == 3:
query = "SELECT * FROM Equipment"
[Link](query)
results = [Link]()
if results:
print("Eqp_ID | Name | DOP | Quantity | Staff_ID |")
for row in results:
print(row)
else:
print("No records found in the Equipment table.")
else:
print("Invalid choice! Please choose a valid option.")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")
#function to insert details of doctor
#MEDICINE
def insert5():
try:
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Hospital_Management",charset="utf8")
Med_ID=input("Enter Med_ID:")
Name=input("Enter Medicine Name:")
Company=input("Enter the Company:")
Qauntity=int(input("Enter the Qauntity:"))
Exp_Date=input("Enter the Expiry Date:")
Price=int(input("Enter the Price:"))
data=(Med_ID,Name,Company,Qauntity,Exp_Date,Price)
mycursor=[Link]()
query="INSERT INTO Medicine values(%s,%s,%s,%s,%s,%s)"
[Link](query,data)
[Link]()
print([Link],"Record Inserted Successfully!!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to update details of doctor


def update5():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Med_ID = input("Enter the Med_ID to be updated:")
mycursor = [Link]()
query = "SELECT * FROM Medicine WHERE Med_ID = %s"
[Link](query, (Med_ID,))
r = [Link]()
if r:
Name = input("Enter the Name: ")
Company = input("Enter the Company:")
Quantity = input("Enter the Quantity:")
Exp_Date = input("Enter the Expiry Date:")
try:
Quantity = int(Quantity)
except ValueError:
print("Quantity must be an integer.")
return
query1 = """UPDATE Medicine SET Name = %s, Company = %s, Quantity
=%s, Exp_Date = %s WHERE Med_ID = %s"""
[Link](query1, (Name, Company, Quantity, Exp_Date,
Med_ID))
[Link]()
print([Link], "Record Updated Successfully!!")
[Link]()
[Link]()
else:
print("ID not found")
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to delete details of doctor


def delete5():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
Med_ID = input("Enter your Med_ID:")
mycursor = [Link]()
query = "SELECT * FROM Medicine WHERE Med_ID = %s"
[Link](query, (Med_ID,))
r = [Link]()
if r:
query1 = "DELETE FROM Medicine WHERE Med_ID = %s"
[Link](query1, (Med_ID,))
[Link]()
print([Link], "Record Deleted Successfully!!")
[Link]()
[Link]()
else:
print("Record not found!")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to display details of doctor


def display5():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
print("1. To search by Med_ID")
print("2. To search by Name")
print("3. Display all records")
choice2 = int(input("Enter your searching choice: "))
if choice2 == 1:
med_id = int(input("Enter the Med_ID to be searched: "))
query = "SELECT * FROM Medicine WHERE Med_ID = %s"
[Link](query, (med_id,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Med_ID.")
elif choice2 == 2:
name = input("Enter the Name: ")
query = "SELECT * FROM Medicine WHERE Name = %s"
[Link](query, (name,))
result = [Link]()
if result:
print(result)
else:
print("No record found for the given Name.")
elif choice2 == 3:
query = "SELECT * FROM Medicine"
[Link](query)
results = [Link]()
if results:
print("Med_ID| Name | Company |Quantity| Exp_Date | Price ")
for row in results:
print(row)
else:
print("No records found in the Medicine table.")
else:
print("Invalid choice! Please choose a valid option.")
[Link]()
[Link]()
except Exception as e:
print("An Error Occurred")
print(f"Error: {str(e)}")

#function to join query


def join1():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
query = """SELECT
A.DOCTOR_ID, [Link] AS DOCTOR_NAME, A.PH_NO AS
DOCTOR_PHONE,
B.PATIENT_ID, [Link] AS PATIENT_NAME, B.PH_NO AS
PATIENT_PHONE, B.MED_HISTORY
FROM DOCTOR A JOIN PATIENT B ON A.DOCTOR_ID =
B.DOCTOR_ID"""
[Link](query)
myrecords = [Link]()
no_rec = [Link]
print("The number of records:", no_rec)
print("\nDOCTOR_ID, DOCTOR_NAME, DOCTOR_PHONE, PATIENT_ID,
PATIENT_NAME, PATIENT_PHONE, MED_HISTORY\n")
for record in myrecords:
Doctor_ID, Doctor_Name, Doctor_Phone, Patient_ID, Patient_Name,
Patient_Phone, Med_history = record
print(Doctor_ID, ",", Doctor_Name, ",", Doctor_Phone, ",", Patient_ID, ",",
Patient_Name, ",", Patient_Phone, ",", Med_history, "\n")
except Exception as e:
print("An Error Occurred!!!!!!!")
print(f"Error: {str(e)}")

#function to join query


def join2():
try:
mydb = [Link](
host="localhost",
user="root",
password="root",
database="Hospital_Management",
charset="utf8")
mycursor = [Link]()
query = """SELECT
A.OTHER_STAFF_ID, [Link] AS STAFF_NAME, A.PH_NO AS
STAFF_PHONE,
B.PATIENT_ID, [Link] AS PATIENT_NAME, B.PH_NO AS
PATIENT_PHONE
FROM STAFF A JOIN PATIENT B ON A.STAFF_ID = B.STAFF_ID"""
[Link](query)
myrecords = [Link]()
no_rec = [Link]
print("The number of records:", no_rec)
print("\nOTHER_STAFF_ID, STAFF_NAME, STAFF_PHONE, PATIENT_ID,
PATIENT_NAME, PATIENT_PHONE\n")
for record in myrecords:
OTHER_STAFF_ID, STAFF_NAME, STAFF_PHONE, PATIENT_ID,
PATIENT_NAME, PATIENT_PHONE = record
print(OTHER_STAFF_ID, ":", STAFF_NAME, ",", STAFF_PHONE, ",",
PATIENT_ID, ",", PATIENT_NAME, ",", PATIENT_PHONE, "\n")
except Exception as e:
print("!!! AN ERROR OCCURRED !!!")
print(f"Error: {str(e)}")

#MENU DRIVEN CODE#


print("SUCCESSFULLY CONNECTED")
print("WELCOME TO HOSPITAL MANAGEMENT ")
while True:
print("[Link] DETAILS")
print("[Link] DETAILS")
print("[Link] STAFF DETAILS")
print("[Link] DETAILS")
print("[Link] DETAILS")
print("[Link] DOCTOR DETAILS AND PAITENTS DETAILS")
print("[Link] OTHER STAFF DETAILS AND EQUIPMENT DETAILS ")
print("[Link]")
ch=int(input("ENTER YOUR CHOICE(1-8):"))
if ch==1:
while True:
print("[Link] NEW DOCTOR DETAILS")
print("[Link] DOCTOR DETAILS")
print("[Link] DOCTOR DETAILS")
print("[Link] DOCTOR DETAILS")
print("[Link] MENU")
c=input("ENTER YOUR CHOICE(a-e):")
if [Link]()=="A":
insert1()
elif [Link]()=="B":
update1()
elif [Link]()=="C":
delete1()
elif [Link]()=="D":
display1()
elif [Link]()=="E":
break
else:
print("WRONG INPUT")
elif ch==2:
while True:
print("\nWELCOME TO PAITEINT DETAILS \n")
print("[Link] NEW PAITEINT DETAILS")
print("[Link] PAITEINT DETAILS")
print("[Link] PAITEINT DETAILS")
print("[Link] PAITEINT DETAILS")
print("[Link] MENU")
c=input("ENTER YOUR CHOICE(a-e):")
if [Link]()=="A":
insert2()
elif [Link]()=="B":
update2()
elif [Link]()=="C":
delete2()
elif [Link]()=="D":
display2()
elif [Link]()=="E":
break
else:
print("WRONG INPUT")
elif ch==3:
while True:
print("\nWELCOME TO OTHER STAFF DETAILS \n")
print("[Link] OTHER STAFF DETAILS")
print("[Link] OTHER STAFF DETAILS")
print("[Link] OTHER STAFF DETAILS")
print("[Link] OTHER STAFF DETAILS")
print("[Link] MENU")
c=input("ENTER YOUR CHOICE(a-e):")
if [Link]()=="A":
insert3()
elif [Link]()=="B":
update3()
elif [Link]()=="C":
delete3()
elif [Link]()=="D":
display3()
elif [Link]()=="E":
break
else:
print("WRONG INPUT")
elif ch==4:
while True:
print("\nWELCOME TO EQUIPMENT DETAILS")
print("[Link] EQUIPMENT DETAILS")
print("[Link] EQUIPMENT DETAILS")
print("[Link] EQUIPMENT DETAILS")
print("[Link] EQUIPMENT DETAILS")
print("[Link] MENU")
c=input("ENTER YOUR CHOICE(a -e):")
if [Link]()=="A":
insert4()
elif [Link]()=="B":
update4()
elif [Link]()=="C":
delete4()
elif [Link]()=="D":
display4()
elif [Link]()=="E":
break
else:
print("WRONG INPUT")
elif ch==5:
while True:
print("\nWELCOME TO MEDECINES DETAILS \n")
print("[Link] MEDECINES DETAILS")
print("[Link] MEDECINES DETAILS")
print("[Link] MEDECINES DETAILS")
print("[Link] MEDECINES DETAILS")
print("[Link] MENU")
c=input("ENTER YOUR CHOICE(a-e):")
if [Link]()=="A":
insert5()
elif [Link]()=="B":
update5()
elif [Link]()=="C":
delete5()
elif [Link]()=="D":
display5()
elif [Link]()=="E":
break
else:
print("WRONG INPUT")
elif ch==6:
join1()
elif ch==7:
join2()
elif ch==8:
print("SUCCESSFULLY EXIT FROM HOSPITAL MANAGEMENT.")
break
else:
print("WRONG INPUT")

[Link]()
[Link]()
OUTPUT
DOCTOR
INSERTING NEW RECORD

UPDATING THE RECORD


DELETING THE RECORD

DISPLAY ALL RECORD


PATIENT
INSERTING NEW RECORD

UPDATING THERECORD
DELETING THE RECORD

DISPLAY ALL RECORD


OTHER STAFF
INSERTING NEW RECORD

UPDATING THE RECORD


DELETING THE RECORD

DISPLAY ALL RECORD


EQUIPMENT
INSERTING NEW RECORD

UPDATING THE RECORD


DELETING THE RECORD

DISPLAY ALL RECORD


MEDICINE
INSERTING NEW RECORD

UPDATING THE RECORD


DELETING THE RECORD

DISPLAY ALL RECORD


DOCTOR AND PATIENT DETAILS
STAFF and equipment DETAILS
EXIT
conclusion

A HOSPITAL MANAGEMENT System is a


computerized management system. This system
keeps the records of hardware assets besides
software of this organization. This proposed
system keep a track on overall things i.e. Doctor
details, Patient Details, Other Staff Details,
Equipment Details and Medicine Detail. It also
saves hospital resources and expenses.
bibliography
To make this project we have taken source from the following
links:
1. Computer science textbook by Preeti Arora
2. https:// [Link]
3 [Link]
4. [Link]

You might also like