A Project Report
on
Hospital Management System
Informatics Practices (065)
2024-25
Submitted By:
YOUR NAME
Class: 12th A
Roll No: Your class roll no
Under the guidance of:
Mrs. Nidhi Shinde
Rosary Senior Secondary School
Radio Colony, Kingsway Camp
Delhi 110009
Page 1 of 13
CONTENTS
S.No Topic Name Page No.
1 Certificate
2 Acknowledgement
3 Introduction
6 Source Code
7 Sample Output
8 Limitations of the project
9 Conclusion
10 Bibliography
Page 2 of 13
CERTIFICATE
This is to certify that the project titled, “ Hospital Management
System” is a piece of work done by Name of the student of class XIIth –
A, in partial fulfillment of CBSE’S AISSCE 2024-25 and has been
carried out under my supervision and guidance. This report or an
identical report on this topic has not been submitted for any other
examination and does not form a part of any other course undergone by
the candidate.
..............................
Signature of Teacher/Guide
Name: Mrs. Nidhi Shinde
Designation: PGT (Informatics Practices)
Place: Rosary Sr. Sec. School, Delhi
Date: --/--/2024-25
Page 3 of 13
ACKNOWLEDGEMENT
I would like to extend my gratitude to the Principal Rev. Fr. Savariraj
and Head Mistress Sr. Carmen for providing me with all the facility that
was required.
I would also like to express my gratitude to my guide Mrs. Nidhi Shinde
for her able guidance and support in completing my project.
Last but not the least I would like to thank my parents and friends who
helped me a lot.
…………………………
Signature of Student
Name:
Class & Section:
Place: Rosary Sr. Sec. School, Delhi
Date: --/--/2024-25
Page 4 of 13
INTRODUCTION
(What is your project, reasons for selection of the dataset, write the source of the
dataset whether created or taken from any reliable source and write what analytics
can be done on the project.)
FRONT END: Python
BACK END: CSV File
NAME OF THE CSV FILE:
Page 5 of 13
SOURCE CODE
import sys
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',passwd='manager')
cur=conn.cursor()
cur.execute("create database dental_management_system")
print("Database created succefully")
conn=sql.connect(host='localhost',user='root',passwd='manager',database='dental_management_s
ystem')
cur.execute('create table patient_record( Patient_Name varchar(50),
Age int(3),
Doctor_Conculted varchar(50),
Address varchar(150),
Phone_Number bigint(15))')
cur.execute('create table salary_record( Employee_Name varchar(50),
Proffession varchar(20),
Salary_Amount varchar(9),
Address varchar(150),
Phone_Number bigint(15))')
cur.execute('create table accounts( User_Name varchar(20) primary key, password varchar(30)
unique)')
print('Tables created successfully')
conn.commit()
user=input("Enter New User Name : ")
user=user.upper()
passwrd=input("Enter New Password : ")
passwrd=passwrd.upper()
cur.execute("insert into accounts values('" + user + "','" + passwrd + "')")
print("ACCOUNT ADDED SUCCEFULLY")
Page 6 of 13
conn.commit()
if conn.is_connected:
print(" Dental Management System ")
print("1. Login")
print("2. Exit")
print()
option=int(input("Enter your choise : "))
if option==1:
print()
user=input('User Name : ')
user=user.upper()
cur.execute("select * from accounts where User_Name like '" + user + "'")
datas=cur.fetchall()
for i in datas:
value_1=i[0]
value_2=i[1]
if user==value_1:
password=input('Password : ')
password=password.upper()
if password==value_2:
age=int(input('Age : '))
doc=input('Doctor Consulted : ')
doc=doc.upper()
add=input('Address : ')
add=add.upper()
phone_no=int(input('Phone Number : '))
cur.execute("insert into patient_record values('" + name + "'," + str(age) + ",'" + doc
+ "','" + add + "'," + str(phone_no) + ")")
conn.commit()
print('Record added')
if choise==2:
Page 7 of 13
print()
emp_name=input( 'Employee_Name : ')
emp_name=emp_name.upper()
proffesion=input('Proffession : ')
proffesion=proffesion.upper()
salary=int(input('Salary Amount : '))
add=input('Address : ')
data=cur.fetchall()
if data!=0:
for row in data:
print()
print("Patient Details : ")
print()
print('Name : ',row[0])
print('Age : ',row[1])
print('Doctor consulted : ',row[2])
print('Address : ',row[3])
print('Phone Number : ',row[4])
input()
else:
print()
print("Patient Record Doesnot Exist") if choise==4:
print()
name=input('Name of the patient : ')
name=name.upper()
cur.execute("delete from patient_record where Patient_Name like '" + name + "'")
print('Record Deleted Succefully')
else:
print('Invalid Password')
print('Tryagain')
elif option==2:
Page 8 of 13
SAMPLE OUTPUT
OPTION – 1:
Page 9 of 13
OPTION – 2:
Page 10 of 13
LIMITATIONS OF THE PROJECT
Page 11 of 13
CONCLUSION
Page 12 of 13
BIBLIOGRAPHY
1. Informatics Practices With Python - Class XII By : Preeti Arora
2. Website: https://www.w3resource.com
Page 13 of 13
