Jawahar navodaya

vidyalaya

Diphu, k/a, assam

COMPUTER SCIENCE PROJECT

Topic: Hotel Management

Submitted By: Submitted To:

Arfena Beypi Poonam Chandra

1
 CERTIFICATE

This is to certify that Miss Arfena Beypi of class XII Science

has successfully completed her Computer Science project on
the topic Hospital Management under the guidance of Sir
Poonam Chandra (PGT Computer Science) during the
academic year 2023-24. The certified student has been
dedicated throughout her research and completed her work
before the given deadline without missing any important details
from the project. It is also certified that this project is the
individual work of the student and can be submitted for
evaluation.

Invigilator’s Signature Teacher’s Signature

Principal Signature

2
 ACKNOWLEDGEMENT

I would like to express my special thanks of gratitude to my

teacher Sir Poonam Chandra (PGT Computer Science) as
well as our principal Deepak Kumar Paul sir who gave me
golden opportunity to do this project of Computer Science,
which also helped me in doing a lot of research and I came to
know new things about it. Without their help, guidance and
support it would be impossible to complete this project.
Secondly, I would also like to thank my parents and friends
who helped me a lot in finishing this project within limited
time. I am making this project not only for marks but also to
increase my knowledge.
Once again thanks to all who helped me in doing this project.

3
 INDEX
Sr. No. Particulars Page

4
 BACKGROUND OF THE
Project
In today’s world, all the things have become
computerized. Generally, the hospital works on paper
work.
To register patient information, there is need of a lot
paper work. So, this software is useful for doing
hospital work easy. It registers the patient’s
information such as- aadhar no., patient name, age,
gender, phone no., blood group.
Generally, to take appointment, the patient has to call
or meet the receptionist of the hospital. By using this
software, you can easily take the appointment to the
consultant doctor with date and time and appointment
no. of that day.
Hence, this software makes easy work for both patient
and hospital management.

5
 FUNCTIONS AND
MODULES

MODULES
import mysql.connecter:
By importing this package, we are able to
establish the connection between SQL and
Python.
import datetime:
This package provides basic functions for
display date related values in the program.
import random:
This package has functionality to generate
random numbers and select numbers within a
range.

6
 FUNCTIONS
connect():

This function establishes connection between

Python and MySQL.
cursor():

It is a special control structure that facilitates

the row-by-row processing of records in the
result set.
The syntax is:

<cursor object>=<connection object>.cursor()

execute():

This function is use to execute the sql query

and retrieve records using python.
The syntax is:

<cursor object>.execute(<sql query string>)

7
fetchall():

This function will return all the rows from the

result set in the form of a tuple containing
the records.
commit():

This function provides changes in the

database physically.

8
 FLOW OF THE PROJECT

 Our project is based on HOSPITAL

MANAGEMENT. The project consists of 3
modules :
1. PATIENT
2. DOCTOR
3. EXIT
In the PATIENT MODULE, you can have 5
options i.e.
I. REGISTER YOURSELF:
In this option, the patient can register
himself/herself by entering their AADHAR
NO., PATIENT NAME, AGE, GENDER, and
PHONE NO. And BLOOD GROUP.
II. APPOINTMENT:
In this option, the patient can take
appointment by entering AADHAR NO.
After entering it, you will get list of doctor
9
 i.e. CARDIOLOGIST, RHEUMATOLOGIST,
PSYCHITRIST, NEUROLOGIST,
OTOLARYNGONOLOGIST and MI ROOM.
III. LIST OF DOCTORS:
In this option, you will get the LIST OF
DOCTORS with their SPECIALITY and
ROOM NO.
IV. SERVICES AVAILABLE:
In this option, you will get the list of
services available in our hospital such as:

 X-RAY
 MRI
 CT SCAN
 ENDOSCOPY
 DIALYSIS
 ULTRASOUND
 EEG
 ENMG
 ECG

10
V. TO MODIFY DATA:
In this option, you can change/modify the
registered details given by patient.

 In the DOCTOR (ADMIN) MODULE,

doctor has to enter his/her ID NO. And
PASSWORD to know the appointment of
the patient with their names, age, and
appointment no. he/she has.

 In the last and final module i.e. EXIT

MODULE, user can end the program.

At last, program will display THANK YOU with

giving a positive message i.e. ”STAY SAFE,
STAY HEALTHY.” and “HEALTH IS WEALTH.” It
will also display the names of developers.

11
 HARDWARE AND SOFTWARE
REQUIREMENT
SYSTEM:
OS- Windows 7 Professional 32-Bit (6.1, Build 7601)
Language: English
System Manufacture-Gigabyte Technology Co., Ltd
BIOS:-BIOS Date: 08/03/13 09:45:07 Ver:
04.06.05
Processor:- Intel (R) Core ™ i3-3220CPU @3.30 GHz
(4CPUs), ~3.3GHz
Memory: 2048 MB RAM DirectX
Version: Direct XII
DISPLAY DEVICE:

Name:-Intel(R) HD Graphics Manufacturer: -

Gigabyte Technology Co., Ltd
Chip Type: - Intel(R) HD Graphics Family DAC
Type:-Internal
Approx. Total Memory:-775 MB Current Display
mode: - 1336 X 768 (32 Bit)(60Hz)
Monitor:- Generic PnP Monitor

12
DRIVER:
Main Driver: - igdumdim 32.dll,igd loiumd
32.dll,igd lo
Version:-10.18.10.3345
Date:-10/28/13 WHQL
logo’s:- Yes DDI Version:
II
Driver Model:-WDDM 1.1

13
 REFERENCES

COMPUTER SCIENCE TEXTBOOK

CLASS 12: SUMITA ARORA
https://www.google.com
https://www.python.org.in
https://www.mysql.org
https://www.tutorialaicsip.com

14