Page 1 of 35

COMPUTER
SCIENCE
PROJECT
2022-23

TITLE OF THE PROJECT

COVID MANAGEMENT
(C-19MS)
SYSTEM

SUBMITTED BY:
Krishna Priyadarshan Behara, XI (Science)

UNDER THE GUIDANCE OF :

Sh. Ashish Jain, Comp. Sc.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 2 of 35

Certificate
KENDRIYA VIDYALAYA No 2, ARMY VADODARA
Nr. METRO HOSPITAL, SAMA – SAVLI ROAD, BARODA
(GUJARAT) - 390022 PH. (0265) 2481551

This is to certify that Krishna Priyadarshan Behara, Mukund Jha,

and Vivek Kumar Sethi, students of Class XI A, Kendriya Vidyalaya

No. 2 ARMY Baroda have satisfactorily completed their computer

science project titled “Covid Management System (C-19MS)” as

prescribed by the course during the academic year 2022-23

towards partial fulfillment of credit for the computer practical

evaluation, and submitted satisfactory report, as compiled in the

following pages, under my supervision.

Sh. Ashish Jain

Computer Science
K.V. No.2 ARMY Baroda

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 3 of 35

Acknowledgement

"There are times when silence speaks so much more loudly than words of
praise to only as good as belittle a person, whose words do not express, but
only put a veneer over true feelings, which are of gratitude at this point of
time."

First and foremost, I would like to express my sincere gratitude to my teacher

Sh. Ashish Jain who gave us the opportunity to do our project on the title
’Covid Management system’ and without whom this project would not have
come forth. I sincerely thank for his valuable guidance, support and
supervision all throughout the project.

I would also like to place on record my sincere gratitude to my team members

and to one and all who supported and encouraged us in successfully
completing the project.

Last but not the least, I am immensely grateful to my parents who were with
me all the time to encourage and support.

Thank You Very Much

Krishna Priyadarshan Behara

Class – XI A, Roll No. 13
K.V. No.2 Army Baroda

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 4 of 35

Contents

Sl. No. Topic Page No.

1 Certificate 02
2 Acknowledgement 03
3 Introduction 04
4 Information Gathering 05
5 Feasibility Study 08
6 Analysis 11
7 Design 14

o Pseudo Code 14

o Algorithm 15

o Flow Chart 16
8 Source Code 17
9 Output 19
10 Conclusions 16
11 References / Bibliography 17

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 5 of 35

COVID
MANAGEMENT SYSTEM
[C-19MS]

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 6 of 35

Introduction

The Covid Management System (C-19MS) is designed for any hospital to keep
a record of Covid-19 patients reported/ registered (as in-patient or out-
patient) replacing their existing manual, paper-based system. This System
targets to provide complete data pertaining to COVID pandemic for the ease
of 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 COVID data of a Hospital into One
Integrated Software Application.

Objectives of the Project

The objective of this project is to let the students apply the programming
knowledge into a real-world situation and/or problem and to get exposure how
programming skills helps in developing a good software. It enhances the
knowledge with respect to:

⮚ Writing programs, utilizing modern software tools.

⮚ Applying object-oriented programming principles effectively when

developing small to medium sized projects.

⮚ Writing effective procedural code to solve small to medium sized

problems.

⮚ Demonstrating a breadth of knowledge in computer science, as

exemplified in the areas of systems, theory and software development.

⮚ Demonstrating ability to conduct a research or applied Computer

Science Project, requiring writing and presentation skill, which
exemplify scholarly style in computer science.

Information Gathering

Python and its uses

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 7 of 35

Python is a high-level, interpreted, general-purpose programming language.

Its design philosophy emphasizes code readability with the use of significant
indentation.
Python can serve as a scripting language for web applications. Web
frameworks like Django, Pylons, Pyramid, TurboGears, web2py, Tornado,
Flask, Bottle, and Zope support developers in the design and maintenance of
complex applications.

Libraries such as NumPy, SciPy, and Matplotlib allow the effective use of
Python in scientific computing with specialized libraries such as Biopython and
Astropy providing domain-specific functionality. SageMath is a computer
algebra system with a notebook interface programmable in Python: its library
covers many aspects of mathematics, including algebra, combinatorics,
numerical mathematics, number theory, and calculus.

Relational Databases:
A database may be defined as a collection of interrelated data stored together
to serve multiple applications. A DBMS (Data Base Management System)
refers to a software that is responsible for storing, maintaining and utilizing
databases. A database along with a DBMS is called a database system.
Examples of some common RDBMS are: Oracle database, Microsoft SQL
server, MYSQL, IBM DB2, IBM Informix, SAP Sybase IQ, Teradata, and
PostgreSQL etc. Out of these, MySQL, PostgreSQL, and SQLite are opensource
implementations.
MySQL is a relational DBMS that can run on virtually all platforms, including
Linux, UNIX and Windows. MySQL is a part of open-source enterprise stack
LAMP (Linux, Apache, MySQL, PHP).

System Development Life Cycle (SDLC)

The systems development life cycle (SDLC) is the process of planning,
developing, testing, and deploying your software. SDLC divides complex
projects into smaller,

more easily managed segments or phases and each phase takes the outcome
from the previous phase to proceed further. Segmenting projects allows
managers to verify the successful completion of project phases before
allocating resources to subsequent phases.
Software development projects typically include initiation, planning, design,
development, testing, implementation, and maintenance phases. However,
the phases may be divided differently depending on the organization
involved.

For example, initial project activities might be designated as request,

requirements-definition, and planning phases, or initiation, concept-
development, and planning phases. End users of the system under
development should be involved in reviewing the output of each phase to
ensure the system is being built to deliver the needed functionality.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 8 of 35

Steps in SDLC
SDLC can be made up of multiple steps. There is no concrete set number of
steps involved. Around seven or eight steps appear commonly; however,
there can be anywhere from five upwards to 12. Typically, the more steps
defined in an SDLC model, the more granular the stages are.
In general, an SDLC methodology follows these following steps:

Analysis: The existing system is evaluated. Deficiencies are identified. This

can be done by interviewing users of the system and consulting with support
personnel.

Plan and requirements: The new system requirements are defined. In

particular, the deficiencies in the existing system must be addressed with
specific proposals for improvement. Other factors defined include needed
features, functions and capabilities.

Design: The proposed system is designed. Plans are laid out concerning the
physical construction, hardware, operating systems, programming,
communications and security issues.

Development: The new system is developed. The new components and

programs must be obtained and installed. Users of the system must be
trained in its use.

Testing: All aspects of performance must be tested. If necessary,

adjustments must be made at this stage. Tests performed by quality
assurance (QA) teams may include systems integration and system testing.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 9 of 35

Deployment: The system is incorporated in a production environment. This

can be done in various ways. The new system can be phased in, according to
application or location, and the old system gradually replaced. In some cases,
it may be more cost-effective to shut down the old system and implement the
new system all at once.

Upkeep and maintenance: This step involves changing and updating the
system once it is in place. Hardware or software may need to be upgraded,
replaced or changed in some way to better fit the needs of the end-users
continuously. Users of the system should be kept up-to-date concerning the
latest modifications and procedures.

Feasibility Study

Our present modern information system makes use of computers for

execution, each of them connected through an optimized network. Healthcare
is the most critical aspect of our society, and many health care providers face
challenges to offer practical and active services to patients.

And in a pandemic situation, where countless people enter and exit the
hospital in a day and maintaining their records accurately and safely is
tedious. To reduce this type of burdens and to manage the financial, hospital
administration and clinical aspects, Covid Management System is the only
solution.

A Covid Management System can address to the most critical area which
includes enhanced diagnosis and care, smooth facility operation, data
availability at the fingertips, cost savings, and real-time data access, among
others. Some of the most significant utilities of C-19MS are:

1. Improved Patient Care

The patient’s health report and medical history from the past to the present,
as well as the illness he is suffering from and the care he received, can all be
added to and accessed via C-19MS. Using this knowledge, doctors can better
assess patients’ health problems, ultimately empowering them to provide the
best care possible. Also, these data may help to combat the pandemic.

2. Availability of Information / real time data at Fingertips

With C-19MS, you will have all of the real time data & details you need at your
fingertips, including the patient’s medical history, inventory, finance,
workforce, and more. You can use this knowledge to figure out what flaws

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 10 of 35

there are in the system or in which department and how to fix them. The
information also aids you in developing a long-term strategy for your
healthcare facility.

3. Reduces Scope of Error and improves efficiency

A lot of tasks are assigned to the software to perform with utmost accuracy
with minimum human intervention, thus scope of error is reduced
dramatically. Thus, helping them to make precise decisions, improve hospital productivity and
control on pandemic effectively.

4. Increased Data Security & Retrieve-ability

Keeping the data safe with only authorized personnel getting access to it and
retrieving it in the minimum possible time. Retrieve-ability of data stored on a
server or cloud is only a matter of few clicks and the data will appear on the
screen within seconds.

5. Improved clinical decision-making

A Covid Management System makes sure that the operational and clinical
decision-making process is fast, accurate, and efficient. With an easy, single
view availability of data points, doctors and medical support staff gets
facilitated.

6. Reduced Hospital Admissions

It allows doctors to grasp early signs and symptoms of potential diseases and
enables them to provide immediate treatment or prepare the patient for the
next phase of their care.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 11 of 35

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 12 of 35

Analysis

Covid -19 Management system(C-19MS) controls, manages, and provides

easy access to all patient records, right from their entry into health service to
hospital discharge. Thus, ensuring faster, smoother and friction-free care
delivery.

Our project uses Python3.0 as its base programming language and uses the
file handling feature of python programming.

This program needs a database for successful execution, if in case database

file doesn’t exist, we can create our own database by creating a csv file for
storing the records.

Target Audiences of C-19MS

In order to create a versatile, efficient and convenient system, we must fully
comprehend its functions, users and supposed benefits. Only after this step,
we will be able to plan and co-ordinate our efforts, choose the most
appropriate technologies, anticipate potential problems and come up with the
solutions. Our project, is a complex software suite of interconnected program
modules that serve to provide both information and management capabilities
to a large variety of users.
This project’s target audience are the hospital administration who will have
access to all the data which may further be divided into two categories:

● Doctors and other authorized employees

● Patients.

Each category has a separate set of algorithms and functions that creates our
database. A user can either access data regarding its staff or its patients.
Each entry in both the databases have a unique ID which associates the
person with that person’s medical or administrative data in the system.

Key Features of C-19MS

Our C-19MS provides a diverse array of highly specific features and functions,
some of which are not used in other industries.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 13 of 35

Management-Oriented Features:
⮚ Doctor and Other Staff Record Database: Allows users to plan,
search and browse their databases. Also allows sharing some limited
information with patients in order to make appointments.
⮚ Adding Staffs to the Database: A very simple process. It includes
entering their Name, Age, Gender, Mobile, Post and Salary. The
entry automatically gets an ID which can be later used to locate that
particular entry in the database.

⮚ Removing Staffs from the Database: Can be very easily done by

using the ID.

⮚ Accessibility: Fulltime access to the staff database.

⮚ Ward Management: Provides various types of planning, tracking and

performance reports separately for every single ward.

This group of features will be invaluable for any hospital administration, as it

helps to optimize work, coordinate current resources and employees, and
increase profits.

Patient-Oriented Functions:
⮚ Patient Medical Record Database: Allows users to plan, search and
browse their databases. Also allows sharing information with the
doctors in order to execute perfect diagnosis.

⮚ Patient Registration: Allows registering a patient who comes to the

clinic in order to obtain a Personal Health Record. It includes
entering response to basic questions regarding their medical
condition, their Name, Age, Gender, Phone number. Also other
medical data which include Date of RTPCR Test result, Date of
earliest Symptoms, if the patient is diabetic, if has BP and if the
patient is under any continuous medications. The entry
automatically gets an ID which can be later used to locate that
particular entry in the database.

⮚ Accessibility: Fulltime access to the patient’s database.

⮚ Patient Notification: To notify the number of days the patient needs

to be quarantined.

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 14 of 35

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 15 of 35

Design
Pseudo Code:

BEGIN
Import CSV python module
Input 1 for admin
Def patient medical record:
input (‘Enter patient name:’)
input (‘Enter patient age:’)
input (‘Enter patient gender:’)
input (‘Enter patient phone no.:’)
input (‘Enter the date of RTPCR test Result:’)
input (‘Enter the date of earliest symptoms:’)
input (‘Is the patient diabetic:’)
input (‘Does the patient has B.P.:’)
input (‘Is the patient under any continuous medications:’)
Def staff record:
input (‘Enter staff name:’)
input (‘Enter staff age:’)
input (‘Enter staff gender:’)
input (‘Enter staff phone no.:’)
input (‘Enter staff post:’)
input (‘Enter salary:’)

Choice = input (“enter number corresponding to the option: 1. Add

patient
2. Add staff
3. Display Patient database

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 16 of 35

4. Display Staff database

5. Remove patient
6. Remove staff
7. Search patient
8. Update the date of the
RTPCR test
9. Logout”)
While True:
If choice ==1:
patient medical record
enter info to database
return to admin

If choice ==2:
staff record
enter info to database
return to admin

If choice ==3:
print (patient medical record)
return to admin

If choice ==4:
print (staff record)
return to admin

If choice ==5:
ID = input (‘Enter patient ID’)
remove ID from patient database

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 17 of 35

return to admin

If choice ==6:
ID = input (‘Enter staff ID’)
remove ID from staff database
return to admin
If choice ==7:
ID = input (‘Enter patient ID’)
If patient found print (found) and print (record)
Else print (not found)
return to admin
If choice ==8:
Select patient
Update the date
return to admin
If choice==9:
break
END

Algorithm:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 18 of 35

STEP 1. START

STEP 2. Select Admin

STEP 3. Choose one of the options

i. Add patient

ii. Add staff

iii. Display patient database

iv. Display staff database

v. Remove patient

vi. Remove staff

vii. Logout

STEP 4. If Add patient, execute patient medical record function.

STEP 5. Input patient medical record in the patient database

STEP 6. Display registration complete

STEP 7. Another entry?

STEP 8. If Yes GO TO STEP 4 else GO TO STEP 3

STEP 9. If Add staff, execute staff record function.

STEP 10. Input staff record in the staff database

STEP 11. Display registration complete

STEP 12. Another entry?

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 19 of 35

STEP 13. If Yes GO TO STEP 9 else GO TO STEP 3

STEP 14. If Display patients record then display patient database.

STEP 15. Return to STEP 3

STEP 16. If Display staff record then display staff database.

STEP 17. Return to STEP 3

STEP 18. If remove patient, enter patient ID

STEP 19. Remove patient from database

STEP 20. Delete another patient?

STEP 21. If Yes GO TO STEP 18 else GO TO STEP 3

STEP 22. If remove staff, enter staff ID

STEP 23. Remove staff from database

STEP 24. Delete another staff?

STEP 25. If Yes GO TO STEP 22 else GO TO STEP 3

STEP 26. If search patient, enter patient ID

STEP 27. If record found then Display - record else Display - not found

STEP 28. Return to STEP 3

STEP 29. If update date, enter patient ID

STEP 30. Update date GO TO STEP 3

STEP 31. If Logout then, Exit.

STEP 32. STOP

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 20 of 35

Flow Chart:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 21 of 35

Source Code

Program for creating the database:

import csv
# Patient's Medical record
def patient_mr(n):
with open('patient record.csv','w',newline='')as f:
fw=csv.writer(f)
pheader=['ID','Name','Age','Gender','Phone number','RTPCR test result
date',' Date of earliest symptoms','Any comorbidities']
fw.writerow(pheader)
for i in range(n):
p_id=input('Enter patient ID:\n')
p_name=input('Enter patient\'s name:\n')
p_age=input('Enter patient\'s age:\n')
p_gen=input('Enter patient\'s gender:\n')
p_phone=input('Enter patient\'s phone number:\n')
p_rtpcr=input('Enter the date of RTPCR test result:\n')
p_es =input('Enter the date of earliest symptoms shown:\n')
p_med=input('Any comorbidities:\n')

p_record=[p_id,p_name,p_age,p_gen,p_phone,p_rtpcr,p_es,p_med]
fw.writerow(p_record)

# Staff administrative record

def staff_record(n):
with open('staff record.csv','w',newline='')as f:
fw=csv.writer(f)

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 22 of 35

sheader=['ID','Name','Age','Gender','Phonenumber','Address','Post
', 'Salary']
fw.writerow(sheader)
for i in range(n):
s_id=input('Enter staff ID:\n')
s_name=input('Enter staff name:\n')
s_age=input('Enter staff age:\n')
s_gen=input('Enter staff gender:\n')
s_phone=input('Enter staff phone number:\n')
s_add=input('Enter address of the staff:\n')
s_post =input('Enter post:\n')
s_sal=input('Staff salary')
s_record=[s_id,s_name,s_age,s_gen,s_phone,s_add,s_post,s_
sal]
fw.writerow(s_record)

#Creating databases
n=int(input('Enter the no. of patients to be written on the database'))
patient_mr(n)
k=int(input('Enter the no. of staff to be written on the database'))
staff_record(k)

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 23 of 35

Source code for C19MS

import csv
# adding patient record
def addpatient_mr():
with open('patient record.csv','a',newline='')as f:
fw=csv.writer(f)
n=int(input('Enter the no. of patients to be added to the
database'))
for i in range(n):
p_id=input('Enter patient ID:\n')
p_name=input('Enter patient\'s name:\n')
p_age=input('Enter patient\'s age:\n')
p_gen=input('Enter patient\'s gender:\n')
p_phone=input('Enter patient\'s phone number:\n')
p_rtpcr=input('Enter the date of RTPCR test result:\n')
p_es =input('Enter the date of earliest symptoms shown:\n')
p_med=input('Any comorbidities:\n')
p_record=[p_id,p_name,p_age,p_gen,p_phone,p_rtpcr,
p_es,p_med]
fw.writerow(p_record)

#adding staff record

def addstaff_record():
with open('staff record.csv','a',newline='')as f:
fw=csv.writer(f)
n=int(input('Enter the no. of staff to be added to the database'))
for i in range(n):

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 24 of 35

s_id=input('Enter staff ID:\n')

s_name=input('Enter staff name:\n')

s_age=input('Enter staff age:\n')
s_gen=input('Enter staff gender:\n')
s_phone=input('Enter staff phone number:\n')
s_add=input('Enter address of the staff:\n')
s_post =input('Enter post:\n')
s_sal=input('Staff salary')
s_record=[s_id,s_name,s_age,s_gen,s_phone,
s_add,s_post,s_sal]
fw.writerow(s_record)

#display patient database

def displaypmr():
f=open('patient record.csv','r')
fo=csv.reader(f)
for i in fo:
print(i)
f.close()

#display staff database

def displaystaff():
f=open('staff record.csv','r')
fo=csv.reader(f)
for i in fo:
print(i)
f.close()

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 25 of 35

#remove patient data

def removepmr():
f=open('patient record.csv','r')
fo=csv.reader(f)
l=[]
for i in fo:
l.append(i)
f.close()
with open('patient record.csv','w',newline='')as f:
n=input('Enter patient ID to be removed:\n')
fw=csv.writer(f)
for i in l:
if i[0]==n:
l.remove(i)
fw.writerows(l)
#remove staff data
def removestf():
f=open('staff record.csv','r')
fo=csv.reader(f)
l=[]
for i in fo:
l.append(i)
f.close()
with open('staff record.csv','w',newline='')as f:
n=input('Enter staff ID to be removed:\n')
fw=csv.writer(f)
for i in l:
if i[0]==n:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 26 of 35

l.remove(i)
fw.writerows(l)
# search patient data
def search_pat():
n=input('Enter patient id to be searched:\n')
f=open('patient record.csv','r')
fo=csv.reader(f)
for i in fo:
if i[0]==n:
print('Record Found')
print(i)
break
else:
print("Record not Found")
f.close()

# update date of RTPCR test

def update_date():
f=open('patient record.csv','r')
fo=csv.reader(f)
l=[]
for i in fo:
l.append(i)
f.close()
with open('patient record.csv','w',newline='')as f:
n=input('Enter patient id whose RTPCR is to be updated:\n')
fw=csv.writer(f)
for i in l:
if i[0]==n:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 27 of 35

new_dt=input('Enter new date:')

i[5]=new_dt
fw.writerows(l)

#__MAIN__
s=input('''_______THE COVID MANAGEMENT SYSTEM_______

press enter to continue:''')

print()
def play():
while True:
choice=input(r'''MENU (select the number corresponding the
choice to select the choice)

1.Add Patient\'s record to the database

2.Add Staff\'s record to the database
3.Display patient database
4.Display staff database
5.Remove patient from the database
6.Remove staff from the database
7.Search Patient
8.Update the Date of RTPCR test
9.logout
''')
if choice=='1':
addpatient_mr()
elif choice=='2':
addstaff_record()
elif choice=='3':
displaypmr()

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 28 of 35

elif choice=='4':
displaystaff()

elif choice=='5':
removepmr()
elif choice=='6':
removestf()
elif choice=='7':
search_pat()
elif choice=='8':
update_date()
elif choice=='9':
print("Logout Successful")
break
play()

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 29 of 35

Output

1. Database created successfully

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 30 of 35

2. Addition of patient record:

3. Addition of staff record:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 31 of 35

4. Display Patient/Staff database:

5. Remove Patient/Staff from database:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 32 of 35

6. Updated Records:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 33 of 35

7. Exit:

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 34 of 35

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23

 Page 35 of 35

References / Bibliography

● NCERT Text books for class XI (Computer Science)

● Computer Science with Python Class XI, By Sumitra Arora

● Wikipedia

● Internet Sites.

*****

Krishna Priyadarshan Behara, XI (Science) CS Project File, 2022-23