ALMA MATER

DAY BOARDING SCHOOL

SESSION : 2022 – 23

Computer Science Project

On
“Hospital Management
System”

Submitted To: Submitted By:

Mr Saurabh Verma Eva Verma
(PGT Computer Science)
 ACKNOWLEDGEMENT
I express my deep sense of gratitude to

Mr Saurabh Verma (PGT – CS) for giving

me the opportunity to undertake the project on

Hospital Management.

I convey my sincere thanks to Ms Poonam

(Principal – Alma Mater School,

Bareilly) for her consort encouragement and

support. I would also like to extent my special

thanks to parents, all the academic staff and

my friends for helping me at each step in

proper direction.

Eva Verma
XII - B

CERTIFICATE

This is to certify that the project of

Computer Science (083) submitted
by Eva Verma of Class XII.

Embodies the record for his/her own

work carried out under our supervision
& guidance. It is an informative &
appreciable piece of work.

We gladly approve this project work

Mr Saurabh Verma Ms Poonam

 (PGT – CS) (Principal)

Contents:
1. Python History and Versions
2. Python Features
3. Program Listing
4. Outputs
5. Conclusion
6. Bibliography
Python History and Latest Version
o Python laid its foundation in the late 1980s.

o The implementation of Python was started in December 1989 by Guido Van

Rossum at CWI in Netherland.
o In February 1991, Guido Van Rossum published the code (labeled version
0.9.0) to alt.sources.
o In 1994, Python 1.0 was released with new features like lambda, map, filter,
and reduce.
o Python 2.0 added new features such as list comprehensions, garbage
collection systems.
o On December 3, 2008, Python 3.0 (also called "Py3K") was released. It was
designed to rectify the fundamental flaw of the language.
o ABC programming language is said to be the predecessor of Python language,
which was capable of Exception Handling and interfacing with the Amoeba
Operating System.
o The following programming languages influence Python:

o ABC language.

o Modula-3

Why the Name Python?

There is a fact behind choosing the name Python. Guido van Rossum was reading
the script of a popular BBC comedy series "Monty Python's Flying Circus". It was
late on-air 1970s.

Van Rossum wanted to select a name which unique, sort, and little-bit mysterious.
So he decided to select naming Python after the "Monty Python's Flying
Circus" for their newly created programming language.
 Python 1.4, documentation released on 25 October 1996.
Python Features
Python provides many useful features which make it popular and valuable from the
other programming languages. It supports object-oriented programming, procedural
programming approaches and provides dynamic memory allocation. We have listed
below a few essential features.

1) Easy to Learn and Use

Python is easy to learn as compared to other programming languages. Its syntax is
straightforward and much the same as the English language. There is no use of the
semicolon or curly-bracket, the indentation defines the code block. It is the
recommended programming language for beginners.

2) Expressive Language
Python can perform complex tasks using a few lines of code. A simple example, the
hello world program you simply type print("Hello World"). It will take only one
line to execute, while Java or C takes multiple lines.

3) Interpreted Language
Python is an interpreted language; it means the Python program is executed one
line at a time. The advantage of being interpreted language, it makes debugging
easy and portable.

4) Cross-platform Language
Python can run equally on different platforms such as Windows, Linux, UNIX, and
Macintosh, etc. So, we can say that Python is a portable language. It enables
programmers to develop the software for several competing platforms by writing a
program only once.

5) Free and Open Source

Python is freely available for everyone. It is freely available on its official
website www.python.org. It has a large community across the world that is
dedicatedly working towards make new python modules and functions. Anyone can
contribute to the Python community. The open-source means, "Anyone can
download its source code without paying any penny."

6) Object-Oriented Language
Python supports object-oriented language and concepts of classes and objects come
into existence. It supports inheritance, polymorphism, and encapsulation, etc. The
object-oriented procedure helps to programmer to write reusable code and develop
applications in less code.
7) Extensible
It implies that other languages such as C/C++ can be used to compile the code and
thus it can be used further in our Python code. It converts the program into byte
code, and any platform can use that byte code.

8) Large Standard Library

It provides a vast range of libraries for the various fields such as machine learning,
web developer, and also for the scripting. There are various machine learning
libraries, such as Tensor flow, Pandas, Numpy, Keras, and Pytorch, etc. Django,
flask, pyramids are the popular framework for Python web development.

9) GUI Programming Support

Graphical User Interface is used for the developing Desktop application. PyQT5,
Tkinter, Kivy are the libraries which are used for developing the web application.

10) Integrated
It can be easily integrated with languages like C, C++, and JAVA, etc. Python runs
code line by line like C,C++ Java. It makes easy to debug the code.

11) Embeddable
The code of the other programming language can use in the Python source code. We
can use Python source code in another programming language as well. It can embed
other language into our code.

12) Dynamic Memory Allocation

In Python, we don't need to specify the data-type of the variable. When we assign
some value to the variable, it automatically allocates the memory to the variable at
run time. Suppose we are assigned integer value 15 to x, then we don't need to
write int x = 15. Just write x = 15.

Python is also versatile and widely used in every technical field, such as Machine
Learning, Artificial Intelligence, Web Development, Mobile Application, Desktop
Application, Scientific Calculation, etc.
PROGRAM
LISTING
##hospital management software
##PRINTING WELCOME NOTE
while(True):
print("""\
n=======================================================
========\n
WELCOME TO KK HOSPITAL PVT. LTD.\n

\
n=======================================================
========
""")
##creating database connectivity
import mysql.connector
psw=str(input("ENTER THE DATABASE PASSWORD;"))

mysql=mysql.connector.connect(host="localhost",user="root",pass
wd=psw)
mycursor=mysql.cursor()
#creating database
mycursor.execute("create database if not exists kvk_hospitals")
mycursor.execute("use kvk_hospitals")
#creating the tables we need
mycursor.execute("create table if not exists patient_details(puid
int(10) primary key,name varchar(30) not null,age int(3),address
varchar(50),doctor_recommended varchar(30))")
 mycursor.execute("create table if not exists doctor_details(name
varchar(30) primary key,specialisation varchar(40),age
int(2),address varchar(30),contact varchar(15),fees
int(10),monthly_salary int(10))")
mycursor.execute("create table if not exists nurse_details(name
varchar(30) primary key,age int(2),address varchar(30),contact
varchar(15),monthly_salary int(10))")
mycursor.execute("create table if not exists
other_workers_details(name varchar(30) primary key,age
int(2),address varchar(30),contact varchar(15),monthly_salary
int(10))")
#login or signup option
#creating table for storing the username and password of the
user
mycursor.execute("create table if not exists user_data(username
varchar(30) primary key,password varchar(30) default'000')")
#printing option
while(True):
print("""
1. SIGN IN (LOGIN)
2. SIGN UP (REGISTER)
""")

r=int(input("enter your choice:"))

#IF USER WANTS TO REGISTER

if r==2:
print("""
========================================================
=========================
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PLEASE
REGISTER YOURSELF!!!!!!!!!!!!!!!!!!!!!!!!!!!

========================================================
=========================
""")
u=input("ENTER YOUR PREFERRED USERNAME!!:")
p=input("ENTER YOUR PREFERRED PASSWORD (PASSWORD
SHOULD BE STRONG!!!:")
#ENTERING THE ENTERED VALUE TO THE USER_DATA TABLE
mycursor.execute("insert into user_data
values('"+u+"','"+p+"')")
mysql.commit()

print("""

========================================================
=========================
!!!!!!!!!!!!!!!!!!!!!!!!!!!REGISTERED
SUCCESSFULLY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

========================================================
=========================
""")
 x=input("enter any key to continue:")
#IF USER WANTS TO LOGIN
elif r==1:

#PRINTING THE SINGIN OPTION AGAIN TO THE USER AFTER

REGISTRATION

print("""

========================================================
=========================
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! {{SIGN
IN }} !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

========================================================
=========================
""")
un=input("ENTER THE USERNAME!!:")
ps=input("ENTER THE PASSWORD!!:")

mycursor.execute("select password from user_data where

username='"+un+"'")
row=mycursor.fetchall()
for i in row:
a=list(i)
if a[0]==str(ps):
while(True):
 ##displaying the task you can perform
print("""
1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE
PROCESS)
3.SIGN OUT

""")

##asking for the task from user

a=int(input("ENTER YOUR CHOICE:"))
#if user wants to enter administration option
if a==1:
print("""
1. SHOW DETAILS
2. ADD NEW MEMBER
3. DELETE EXISTING ONE
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
if b==1:
print("""
1. DOCTOR DETAILS
 2. NURSE DETAILS
3. OTHER WORKERS
""")

#ASKING USER'S CHOICE

c=int(input("ENTER YOUR CHOICE:"))
#if user wants to see the details of doctors
if c==1:
mycursor.execute("select * from
doctor_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)

k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","FEE
S","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of nurses
elif c==2:
mycursor.execute("select * from
nurse_details")
row=mycursor.fetchall()
for i in row:
 v=list(i)

k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MO
NTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of
other_workers
elif c==3:
mycursor.execute("select * from
other_workers_details")
row=mycursor.fetchall()
for i in row:
v=list(i)

k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MO
NTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#IF USER WANTS TO ENTER DETAILS
elif b==2:
print("""

1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
 """)
c=int(input("ENTER YOUR CHOICE:"))
#FOR ENTERING DETAILS OF DOCTORS
if c==1:
#ASKING THE DETAILS
name=input("ENTER DR. NAME:")
spe=input("ENTER SPECIALISATION:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
fees=input("ENTER FEES:")
ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED INTO THE
DOCTORS_TABLE
mycursor.execute("insert into doctor_details
values('"+name+"','"+spe+"','"+age+"','"+add+"','"+cont+"','"+fees+
"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering nurse details
elif c==2:
#ASKING THE DETAILS
name=input("ENTER NURSE NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
 cont=input("ENTER CONTACT NO.:")
ms=int(input("ENTER MONTHLY_SALARY:"))
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into nurse_details
values('"+name+"','"+age+"','"+add+"','"+cont+"','"+str(ms)+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering workers details
elif c==3:
#ASKING THE DETAILS
name=input("ENTER WORKER NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into
other_workers_details
values('"+name+"','"+age+"','"+add+"','"+cont+"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#if unser wants to delete data
elif b==3:
print("""
1. DOCTOR DETAILS
 2. NURSE DETAILS
3. OTHER WORKERS
""")
c=int(input("ENTER YOUR CHOICE:"))
#deleting doctor's details
if c==1:
name=input("ENTER DOCTOR'S NAME:")
mycursor.execute("select * from
doctor_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data?
(y/n):")
if p=="y":
mycursor.execute("delete from
doctor_details where name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")

#deleting nurse details

elif c==2:
name=input("ENTER NURSE NAME:")
 mycursor.execute("select * nurse_details
where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data?
(y/n):")
if p=="y":
mycursor.execute("delete from
nurse_details where name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
#deleting other_workers details
elif c==3:
name=input("ENTER THE WORKER NAME:")
mycursor.execute("select * from
workers_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data?
(y/n):")
if p=="y":
mycursor.execute("delete from
other_workers_details where name='"+name+"'")
mysql.commit()
 print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
elif b==4:
break

#entering the patient details table

elif a==2:

print("""
1. SHOW PATIENT DETAILS
2. ADD NEW PATIENT
3. DISCHARGE PATIENT
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
#if user wants to see the details of PATIENT
if b==1:
mycursor.execute("select * from
patient_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)
k=["NAME","SEX","AGE","ADDRESS","CONTACT"]
d=dict(zip(k,v))
print(d)

#adding new patient

elif b==2:
name=str(input("ENTER NAME: "))
sex=str(input("ENTER SEX: "))
age=str(input("ENTER AGE: "))
address=str(input("ADDRESS: "))
contact=str(input("CONTACT NUMBER: "))
mycursor.execute ("insert into patient_details
values('"+str(name)+"','"+str(sex)+"','"+str(age)+"','"+str(address)
+"','"+str(contact)+"')")
mysql.commit()
mycursor.execute("select * from
patient_details")
for i in mycursor:
v=list(i)
k=['NAME','SEX','AGE','ADDRESS','CONTACT']
print(dict(zip(k,v)))
print("""

========================================================
=========================
 !!!!!!!!!!!!!!!!!!!!!!!!!!!REGISTERED
SUCCESSFULLY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

========================================================
=========================
""")
#dischare process
elif b==3:
name=input("ENTER THE PATIENT NAME:")
mycursor.execute("select * from patient_details
where name='"+name+"'")
row=mycursor.fetchall()
print(row)
bill=input("HAS HE PAID ALL THE BILLS ? (y/n):")
if bill=="y":
mycursor.execute("delete from
patient_details where name='"+name+"'")
mysql.commit()
#if user wants to exit
elif b==4:
break
###SIGN OUT
elif a==3:
break
 #IF THE USERNAME AND PASSWORD IS NOT IN THE
DATABASE
else:
break

OUTPUTS:
12345
 CONCLUSION
Employee Records Management System can be
used to maintain the records easily. Achieving
this objective is difficult using the manual
system as the information is scattered, can be
redundant, and collecting relevant information
may be very time-consuming. All these
problems are solved by this project.
This system helps in maintaining the
information of pupils of the organization. It can
be easily accessed by the manager and kept safe
for a long period of time without any changes

BIBLIOGRAPHY
1. Computer Science With Python
(Sumita Arora)
2. Let Us Python
(Yashavant Kanetkar, Aditya
Kanetkar)
3. Basics of Python Programming
(Dr. Pratiyush Guleria)