Covid-19 Hospital Management System Project Report

1. PROFILE OF THE PROBLEM

STAS, Pathanamthitta Page | 1

Covid-19 Hospital Management System Project Report

1.1ABOUT THE PROJECT

Covid-19 Hospital patient management, system will full and advanced features. Hospital
Management System is a web application for the hospital which manages doctors and
patients. In this project, we use Python Django and SQLite database. A responsive web-app
with aesthetic and accessible UI for managing COVID patients of a certain hospital built
using Django and Bootstrap framework. Clean aesthetic User Interface, which changes
dynamically as per the status of patient changes. In bed availability grid the red color
indicates that bed is occupied else available. It is one of the two pages available for public to
view. Here you can add patient for storing it to the db. Patient's relative contact details are
also taken to check if the relative has contacted COVID virus. Bed numbers which are
available are only shown. Information filled here, will make changes in dashboard
dynamically. Since there are relatively more COVID patients than any other viruses/diseases,
a checklist for COVID symptoms only is present. Here you can search patients wrt to name,
bed no. doctor assigned and status. You Capacity concerns emerged as hospitals anticipated
being overwhelmed if they experienced a surge of patients, who may require special beds and
rooms to treat and contain infection. Many hospitals reported that post-acute-care facilities
were requiring negative COVID-19 tests before accepting patients discharged from hospitals,
meaning that some patients who no longer required acute care were taking up valuable bed
space while waiting to be discharged. Also find update button to update the patient details.
This is where the actual updates for individual patients are done Seat Management.
Equipment Management. Oxygen Management. Doctor Management. Daily Patient Routine
Checkup .Hospital capacity, including information on ICU capacity and available ventilators.
Staffing levels, including any shortages. How many patients are coming into the hospital with
confirmed or suspected COVID-19 cases, many other relevant details that public health
officials need to properly coordinate COVID responses.

Covid-19 Hospital Management System is a computerized management system. This system

also keeps the records of hardware assets besides software of this organization. The proposed
system will keep a track of Doctors, Patients & Receptionist. This project software that will
help in storing, updating and retrieving the information through various user-friendly menu-
driven modules. Goals of proposed system: The system should be easy to operate. ii. The

STAS, Pathanamthitta Page | 2

Covid-19 Hospital Management System Project Report

working in the organization will be well planned and organized. The level of accuracy in the
proposed system will be higher.

2. SYSTEM STUDY

STAS, Pathanamthitta Page | 3

Covid-19 Hospital Management System Project Report

2.1 INTRODUCTION

System Study is a general term that refers to an orderly, structured

process for identifying and solving problems. We call system Study process lifecycle
methodology, since it relates to four significant phases in the lifecycle of all business
information system. The system is studied to the minute details and analyzed. Analysis
implies the process of breaking something into parts so that the whole may be understood.
The definition of the system analysis includes not only the process of analysis but also that of
synthesis, which implies the process of putting together to form a new whole.

All activities associated with each life cycle phase must be performed, managed and
documented. Hence, we define system analysis as the performance, management,
documentation of the activities related to the life cycle phases of a computer-based business
system. In the study phase a detailed study of the project is made and clear picture of the
project is in mind. In the design phase the designing of the input, output and table designs are
made. Development phase is where the physical designing of the input-output screens and
coding of the system is done. System implementation actually implements the system by
making necessary testing.

2.2 EXISTING SYSTEM

Hospitals currently use a manual system for the management and maintenance of critical
information. The current system requires numerous paper forms, with the data stores spread
throughout the hospital management infrastructure. Often information (on forms) is
incomplete, or does not follow management standards. Forms are often lost in transit between
department requiring a comprehensive auditing process to ensure that no vital information is
lost multiple copies of the same information exist in the hospital and may lead to
inconsistencies in data various data stores.

STAS, Pathanamthitta Page | 4

Covid-19 Hospital Management System Project Report

2.3 PROPOSED SYSTEM

Covid -19 hospital management system is designed for any hospital to replace their existing
manual, paper based system. The new system is control the following information room
availability, staff and operating room schedules, and patient invoices. The service are to be
provided in an efficient, cost effective manner, with the goal of reducing the time and
resources currently required for such tasks.

STAS, Pathanamthitta Page | 5

Covid-19 Hospital Management System Project Report

3. PROBLEM ANALYSIS

STAS, Pathanamthitta Page | 6

Covid-19 Hospital Management System Project Report

3.1 SYSTEM DEFENITION

The project Covid-19 Hospital Management System is developed
using LANGUAGE NAME. The new user can register and only the registered user can go
further. The administrator can control all the operations in the website. He can also modify
and upload data to the website. The registered user can see all information about the products,
searching and viewing product details. The website is designed in such a way that the future
plans of expansion can be implementing easily without affecting the existing features. The
website and its operations should be safe and unauthorized access should not be allowed. The
user is able to view the product details only if he is logged in and active user.

3.2 FEASIBILITY ANALYSIS

A feasibility study is a test of system proposal according to its

workability, impact on the organization, ability to meet user needs, and effective use of
resources. The objective of feasibility study is acquiring a sense of the scope of the system.

The feasibility of a project can be ascertained in terms of technical

factors, economic factors, or both. A feasibility study is documented with a report showing
all the ramifications of the project. It is very important to evaluate the feasibility study and
risk analysis is related in many ways. If the project study is great, the feasibility of producing
quality software is reduced.

The key factors considered during the feasibility study are:

1. Economic Feasibility
2. Behavioral Feasibility
3. Technical Feasibility
4. Operational Feasibility
5. Legal Feasibility

STAS, Pathanamthitta Page | 7

Covid-19 Hospital Management System Project Report

3.2.1 ECONOMIC FEASIBILITY

Economic analysis is the most commonly used method for evaluating

effectiveness of a system. Cost-benefit analysis is the most important assessment of economic
justification of the project. Cost –benefit analysis delineates the cost for project development
and weighs them against tangible and intangible benefits of a system. This type of analysis
varies with the characteristics of the system to be developed, the relative site of the project,
and the expected return on investment. Benefits of a new system are always determined
relative to the existing mode of operation.

Economic feasibility deals about the economic impact faced by the

organization to implement the new system. Not only cost of hardware, software etc. is
considered but also the form of reduced costs. The project, installed certainly be beneficial
since there will be a reduction in manual wok, increase in speed of work. The analysis raises
financial and economic questions during the preliminary investigation to estimate the
following:

 The cost to conduct a full systems investigation.

 The cost of hardware and software for the class of application of the project being
considered.

To be judged feasible, a proposal for the specific project must pass all these tests, otherwise it
is not considered as a feasible project. I gathered the details regarding the financial aspects
incorporated in the system to make it cost efficient.

3.2.2 BEHAVIORAL FEASIBILITY

Proposed projects are beneficial only if they can be turned into

information systems that will meet the operating requirements of the organization. This test
of feasibility asks if the system will work when it is developed satisfies all the operational
conditions. It was the most difficult task for me, but met efficiently.

As this package is found to be feasible technically, economically and

functionally, the system is judged feasible. Viewing the collected information,

STAS, Pathanamthitta Page | 8

Covid-19 Hospital Management System Project Report

recommendation and justification, conclusions is made of the proposed system. Hence

decision is taken to go on with the project.

3.2.3 TECHNICAL FEASIBILITY

There are a number of technical issues, which are generally raised during
the feasibility stage of the investigation. A study of function, performance and constraints
gave me the ability to achieve acceptable system. The software required for this system is:

 PYTHON
 SQLite

3.2.4 OPERATIONAL FEASIBILITY

Suppose for a moment that technical and economic resources are both
judged adequate. The systems analyst must still consider the operational feasibility of the
requested project. Operational feasibility is dependent on human resources available for the
project and involves projecting whether the system will operate and be used once it is
installed. If users are virtually wed to the present system, see no problems with it, and
generally are not involved in requesting a new system, resistance to implementing the new
system will be strong. Chances for it ever becoming operational are low.

3.2.5 LEGAL FEASIBILITY

A determination of any infringement, violation, or liability that could

result from development of the system. Legal feasibility encompasses a broad range of
concerns that include contracts, liability, infringement, and myriad other traps frequently
unknown to technical staff.

STAS, Pathanamthitta Page | 9

Covid-19 Hospital Management System Project Report

3.3 PROJECT PLAN

Planning is very important in every aspect of development work. Good

managers carefully monitor developments at various phases. Improper planning leads to
failure of the project. Software project pan can be viewed as the following:

1. within the organization: How the project is to be implemented? What are various
constraints? What is market strategy?

2. With respect to the customer: Weekly or timely meetings with the customer with
presentations on status reports. Customer feedback is also taken and further modifications
and developments are done. Project milestones and deliverables are also presented to the
customer. For a successful project the following steps can be followed:

Selection of project: Includes identifying project’s aims and objectives, understanding

requirements and specification, methods of analysis, design and implementation, testing
techniques and documentation.

 Project milestones and deliverables.

 Project estimates: including cost, time, size of code and duration.
 Resource allocation: including hardware, software, previous relevant project
information and digital library.
 Risk management: including risk avoidance, risk detection, risk control and risk
recovery.
 Scheduling techniques: including work breakdown structure, activity graph, critical
path method, Gantt chart and Program Evaluation Review Technique.
 People: including staff recruitment, team management and customer interaction.
 Quality control and standard.

STAS, Pathanamthitta Page | 10

Covid-19 Hospital Management System Project Report

Fig: Gantt chart

STAS, Pathanamthitta Page | 11

Covid-19 Hospital Management System Project Report

4. REQUIREMENT ENGINEERING

STAS, Pathanamthitta Page | 12

Covid-19 Hospital Management System Project Report

4.1 INTRODUCTION
Requirement analysis involves studying the current system to find out how
it works and where improvements could be made. A clear idea about the existing system is a
must for making improvements where it is required. Proper planning and collection of data
serves the purpose. The popularity of this document is to describe all the requirements for the
popularity of the website for Covid-19 Hospital Management System. This website gives all
the information for a person. In our busy life, we cannot go to each department or offices.
This problem will manage this site. It will help to avoid in correction and missing data.

4.2 SPECIFIC REQUIREMENTS

HARDWARE REQUIREMENTS:
CPU - 1.8 GHz or faster processor
HARD DISK SPACE - Minimum 160GB
RAM - 2GB or more

WEB SERVER - IIS 5.0

INTERNET TOOLS - HTML, JAVASCRIPT
CODING LANGUAGE - PYTHON
FRONT END - DJANGO
BACK END - SQLite
OPERATING SYSTEM - Windows (Any Version)
SOFTWARE REQUIREMENTS:

4.3 INTRODUCTION TO PYTHON

STAS, Pathanamthitta Page | 13

Covid-19 Hospital Management System Project Report

Python is a widely used general-purpose, high level programming language. It was created by
Guido van Rossum in 1991 and further developed by the Python Software Foundation. It was
designed with an emphasis on code readability, and its syntax allows programmers to express
their concepts in fewer lines of code.
Python is a programming language that lets you work quickly and integrate systems more
efficiently.

There are two major Python versions: Python 2 and Python 3. Both are quite different.
Python is not that complex! It is a high-level dynamic programming language and is quite
easy to learn. Python code has a very ‘natural’ style to it, which makes it easy to read and
understand. The Python programming language is freely available and makes solving a
computer problem almost as easy as writing out your thoughts about the solution. The code
can be written once and run on almost any computer without needing to change the program.

Python is a general-purpose programming language that can be used on any modern

computer operating system. It can be used for processing text, numbers, images, and
scientific data and just about anything else you might save on a computer. It is used daily in
the operations of the Google search engine, the video-sharing website YouTube, NASA and
the New York Stock Exchange. These are but a few of the places where Python plays
important roles in the success of the business, government, and non-profit organizations;
there are many others.

Python is an interpreted language. This means that it is not converted to computer-readable

code before the program is run but at runtime. In the past, this type of language was called a
scripting language, intimating its use was for trivial tasks. However, programming languages
such as Python have forced a change in that nomenclature. Increasingly, large applications
are written almost exclusively in Python. Some ways that you can apply Python include:

 Programming CGI for Web Applications

 Building an RSS Reader
 Reading from and Writing to MySQL
 Reading from and Writing to PostgreSQL

STAS, Pathanamthitta Page | 14

Covid-19 Hospital Management System Project Report

 Creating Calendars in HTML

 Working With Files

What can Python do?

 Python can be used on a server to create web applications.

 Python can be used alongside software to create workflows.
 Python can connect to database systems. It can also read and modify files.
 Python can be used to handle big data and perform complex mathematics.
 Python can be used for rapid prototyping, or for production-ready software
development

Why Python?
 Python works on different platforms (Windows, Mac, Linux, Raspberry Pi, etc).
 Python has a simple syntax similar to the English language.
 Python has syntax that allows developers to write programs with fewer lines than
some other programming languages.
 Python runs on an interpreter system, meaning that code can be executed as soon as it
is written. This means that prototyping can be very quick.
 Python can be treated in a procedural way, an object-orientated way or a functional
way.

Good to know
 The most recent major version of Python is Python 3, which we shall be using in this
tutorial. However, Python 2, although not being updated with anything other than
security updates, is still quite popular.
 In this tutorial Python will be written in a text editor. It is possible to write Python in
an Integrated Development Environment, such as Thonny, Pycharm, Netbeans or
Eclipse which are particularly useful when managing larger collections of Python
files.

STAS, Pathanamthitta Page | 15

Covid-19 Hospital Management System Project Report

Python Syntax compared to other programming languages

 Python was designed for readability, and has some similarities to the English
language with influence from mathematics.
 Python uses new lines to complete a command, as opposed to other programming
languages which often use semicolons or parentheses.
 Python relies on indentation, using whitespace, to define scope; such as the scope of
loops, functions and classes. Other programming languages often use curly-brackets
for this purpose.

Django
Django is a high-level Python Web framework that encourages rapid development and clean,
pragmatic design. Built by experienced developers, it takes care of much of the hassle of Web
development, so you can focus on writing your app without needing to reinvent the wheel.
It’s
free and open source.

Ridiculously fast
Django was designed to help developers take applications from concept to completion
as quickly as possible.

Reassuringly secure
Django takes security seriously and helps developers avoid many common security
mistakes.

Exceedingly scalable
Some of the busiest sites on the Web leverage Django’s ability to quickly and flexibly
scale.

So, what is the Django Framework?

Django is an open-source framework for backend web applications based on Python — one
of the top web development languages. Its main goals are simplicity, flexibility, reliability,
and scalability.

STAS, Pathanamthitta Page | 16

Covid-19 Hospital Management System Project Report

Django has its own naming system for all functions and components (e.g., HTTP responses
are called “views”). It also has an admin panel, which is deemed easier to work with than in
Lavarel or Yii, and other technical features, including:

 Simple syntax;
 Its own web server;
 MVC (Model-View-Controller) core architecture;
 “Batteries included” (comes with all the essentials needed to solve solving common
cases);
 An ORM (Object Relational Mapper);
 HTTP libraries;
 Middleware support; and
 A Python unit test framework.

Additionally, Django provides a dynamic CRUD (create, read, update and delete) interface,
configured with admin models and generated via introspection. CRUD is used to describe the
basic database commands, which means the interface facilitates viewing, changing, and
searching for information.

HTML Relationship
When used to output HTML content, PYTHON is embedded inside HTML in code islands,
where HTML code is embedded inside the Python script.

Why we use the Django framework

It’s fast and simple
One of Django’s main goals is to simplify work for developers. To do that, the Django
framework uses:
 The principles of rapid development, which means developers can do more than one
iteration at a time without starting the whole schedule from scratch;
 DRY philosophy — Don’t Repeat Yourself — which means developers can reuse
existing code and focus on the unique one.

STAS, Pathanamthitta Page | 17

Covid-19 Hospital Management System Project Report

As a result, it takes a lot less time to get the project to market.

It’s secure Security is also a high priority for Django. It has one of the best out-of-the-
box security systems out there, and it helps developers avoid common security issues,
including
o Clickjacking,
o Cross-site scripting, and
o SQL injection.

Django promptly releases new security patches. It’s usually the first one to respond to
vulnerabilities and alert other frameworks.

It suits any web application project

With Django, you can tackle projects of any size and capacity, whether it’s a simple
website or a high-load web application. Why use Django for your project? Because:

 It’s fully loaded with extras and scalable, so you can make applications that handle
heavy traffic and large volumes of information;
 It is cross-platform, meaning that your project can be based on Mac, Linux or PC;
 It works with most major databases and allows using a database that is more suitable
in a particular project, or even multiple databases at the same time.
 It’s well-established

Django is time- and crowd-tested. It has a big, supportive community accessed through
numerous forums, channels, and dedicated websites. It’s easy to find help when there’s a
problematic function in the code, and to find developers if your company is looking to base
the next project on Django.

Django started off with great documentation, the best of any other open-source framework.
And it’s still maintained on a high level, updated along with the new functions and fixes, so
you can easily adapt to changes.You can trust that any issues with the framework will be
solved as soon as they arise. The software is constantly updated and new packages are
released to make working with Django more convenient than it already is.

STAS, Pathanamthitta Page | 18

Covid-19 Hospital Management System Project Report

DB Browser SQLite
The only surest and seamless way to handle SQLite databases on computers is by means of
DB
Browser for SQLite. Db Browser For SQLite is an open-source tool which is completely free
to use.
Db Browser for SQLite creates databases which are compatible with SQLite. The “.db”
database extension created by this software is completely compatible with SQLite. You
should never change the .db extension, use it as it is for all your SQLite database
manipulations.

Advantages of Using Db Browser for SQLite

There so many advantages of using Db Browser for SQLite, I will, however, provide a list of
the main advantages.
1. Db Browser For SQLite is Completely Free
2. It’s a very Light Weight Software, ready to be handled by all types of machines
3. It can be used, by both Developers and End Users. You don’t need to be a developer
to use Db Browser for SQLite, everything concerning SQLite Management is done
fully by this software.
4. Everything is done on a Graphical User Interface. No SQL code required in tables or
records manipulations.
5. Imports/Exports your databases and tables from/to CSV file
6. Import and export databases from/to SQL dump files
7. Import and export records as text
8. It’s almost impossible to finish all its advantages.

How to Create and Connect Database on Db Browser for SQLite

Creating a new database on the Db Browser for SQLite involves nothing more complex than
just clicking File > New Database. Provide a relevant name for your database and boom, you
are done.

STAS, Pathanamthitta Page | 19

Covid-19 Hospital Management System Project Report

What it is DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to
create, design, and edit database files compatible with SQLite.

DB4S is for users and developers who want to create, search, and edit databases. DB4S uses
a familiar spreadsheet-like interface, and complicated SQL commands do not have to be
learned.

Controls and wizards are available for users to:

 Create and compact database files
 Create, define, modify and delete tables
 Create, define, and delete indexes
 Browse, edit, add, and delete records
 Search records
 Import and export records as text
 Import and export tables from/to CSV files
 Import and export databases from/to SQL dump files
 Issue SQL queries and inspect the results
 Examine a log of all SQL commands issued by the application
 Plot simple graphs based on table or query data

STAS, Pathanamthitta Page | 20

Covid-19 Hospital Management System Project Report

5. MODELING

STAS, Pathanamthitta Page | 21

Covid-19 Hospital Management System Project Report

5.1 INTRODUCTION
We create models to obtain a better understanding of the actual entity to be
built. The model focuses on what the system must do and not on how it does it. The second
and third operational analysis principles require that we build modules of function and
behavior. The written word is a wonderful vehicle for communication, but it isn't
necessarily the best way to represent the requirements for computer software. Analysis
modeling uses a combination of text and diagrammatic forms to depict requirements for
data, function, and behavior in a way that is relatively easy to understand, and more
important, straightforward to review for correctness, completeness and consistency. This
section presents resources for conventional and object-oriented analysis (OOA) methods as
well as resources for UML. Analysis modeling is an extremely robust subject.

5.2 GENERAL DESCRIPTION

Requirement Modelling approaches are
1. Scenario-Based modeling
o Use Case Diagram
2. Data modeling
o ER Diagram
3. Class based modeling
o Class diagrams
4. Behavioral modeling
o State Diagram

5.2.1 Scenario-Based modeling

STAS, Pathanamthitta Page | 22

Covid-19 Hospital Management System Project Report

Scenario based modeling represents requirements from the point of

view of various system ‘actors’. Requirement modeling begins with the creation of
scenarios in the form of use case diagrams.

o Use Case Diagram

Use cases help to determine the functionality and features of the
software from user’s perspective. A use case describes how a user interacts with the system
by defining the steps required to accomplish a specific goal. Variations in the sequence of
steps describe various scenarios. In the diagram the stick figure represents an actor that is
associated with one category of user. In the use-case diagram the use cases are displayed as
ovals.

The actors are connected by lines to the use cases that they carry out. The use
cases are placed in a rectangle but the actors are not .This rectangle is a visual remainder of
the system boundaries and that the actors are outside the system.

Register

Manage Patients

Manage Beds

View Patients
Admin Doctor

View Doctors

STAS, Pathanamthitta Page | 23

Covid-19 Hospital Management System Project Report

Add Doctors

Fig: Use Case Diagram

5.2.3 Data Modeling

If software requirements include the need to create, extend, or

interface with a database, the software team may choose to create a data model as part of
overall requirements modeling. It defines all data objects that are processed within the
system, the relationship between the data objects, and other information that is pertinent to
the relationships. The entity –relationship diagram (ERD) addresses these issues and
represents all data objects that are entered, stored, transformed, and produced within an
application. Data modeling tools provide a software engineer with the ability to represent data
object, their characteristics, and their relationships. Used primarily for large database
applications and other information systems projects, data modeling tools provide an
automated means for creating comprehensive entity relation diagrams, data object
dictionaries, and related models.

An E-R diagram may also indicate the cardinality of a

relationship. Cardinality is the number of instances of one entity that can, or must, be
associated with each instance of another entity. In general, we may speak of one-to-one, one-
to-many, or many-to-many relationships.

Rectangle which represents entity sets.

Diamond which represents relationship sets.

STAS, Pathanamthitta Page | 24

Covid-19 Hospital Management System Project Report

Ellipse which represents attributes.

Lines which link attributes to entity sets and entity sets to

relationship sets.

Phone_Nu
Doctor_I
m
D
Name Doctor_N
otes
Password P_ID
Username
Status

View Pat_Det
Admin_D
et Address
Symptoms
Pat_rel_c Bed_Num
Last_Name First_Name ontact

Has

B_ID
Specializati Name
on

Bed_Det
Phone_Nu Doc_Det
m

Address Occupied
D_ID
Fig: ER Diagram

STAS, Pathanamthitta Page | 25

Covid-19 Hospital Management System Project Report

6. DESIGN

STAS, Pathanamthitta Page | 26

Covid-19 Hospital Management System Project Report

6.1 INTRODUCTION
Design for Web apps encompasses technical and non-technical activities
that include: establishing the look and feel of the Web app, creating the aesthetic layout of the
user interface, defining the overall architectural structure, developing the content and
functionality that reside within the architecture, and planning the navigation that occurs
within the Web app.
Design allows you to create a model that can be assessed for quality and
improved before content and code are generated, tests are conducted, and end users become
involved in large numbers. Design is the place where Web app quality is established.
In general, the following design objectives must be kept in mind;

 Practicality of the System

 Efficiency of the System
 Minimized cost of the System
 Flexibility of the System
 Security of the System
The system design involves first logical design and then physical
construction of the system. The logical design describes structure and characteristics of
features, like the outputs, inputs, databases and procedures. The physical construction which
follows the logical design produces actual program software files and the working system.

System design sits at the technical kernel of the software engineering and is applied

regardless of the software process model that is used. Beginning once software requirements

have been analyzed and specified, software design is the first technical activity that is used to

STAS, Pathanamthitta Page | 27

Covid-19 Hospital Management System Project Report

build and verify the software. Each activity (designing, coding and testing) transforms

information in a manner that ultimately results in validated computer software.

6.2 USER INTERFACE DESIGN

The interface describes how the software communicates with itself. The

user interface is the link between the users and the employers. A well-designed user interface

makes it very easy for users to learn software. The user interface portion of software is

responsible for all interaction with the user. Development of good user interface usually takes a

significant portion of the total system development effort. GUI can be defined as a program

interface that takes advantages of the computer’s graphic capabilities to make the program

easier to use.

The Covid-19 Hospital Management System is a web based one. Web

application use client/server architecture. The web application resides on a server and responds to

request from multiple clients over the Internet on the client side, a browser, such as Internet

Explorer, Netscape Navigator, hosts the Web application. The application’s user interface takes

the form of HTML pages that are interpreted and displayed by the client’s browser. On the server

side, the Web application runs under Microsoft Internet Information Services (IIS). IIS manages

the application, passes requests from clients to the application, and returns the application’s

response to the client.

6.3 CONTENT DESIGN

STAS, Pathanamthitta Page | 28

Covid-19 Hospital Management System Project Report

Content design focuses on two different design tasks, each addressed by

individuals with different skill test sets. First, a design representation for content objects and
the mechanisms required to establish their relationship to one another is developed. In
addition, the information within a specific content object is created. The latter task may be
conducted by copywriters, graphic designers, and others who generate the content to be used
within a Web app.
In the Covid-19 Hospital Management System admin has the total
control to the website. Admin will manage all registration and report generation. Admin can
control every student who has attend the examination. Students can select different subject.
Each subject has multiple examinations.

6.4 ARCHITECTURAL DESIGN

It is tied to the goals established for a web App, the content to be
presented, the user who will visit and the navigation philosophy that has been established. As
an architectural designer, you must identify content architecture and WebApp Architecture.
Content architecture focuses on the manner in which content objects are structured for
presentation and navigation. WebApp Architecture addresses the manner in which the
application is structured to manage user interaction, handle internal processing tasks, effect
navigation and present content. Architectural design - creates a blueprint for the design with
the necessary specifications for the hardware, software, people and data resources. In this
project n-Tier architecture is used for development. It can use objects for handling business
rules and data access. It has multiple servers handling business services.

6.5 NAVIGATION DESIGN

Once the WebApp Architecture has been established and the component of
the architecture has been identified, you must define navigation path way that enable users to
access WebApp content and functions. To accomplish this, you should
(1) Identify the semantics of navigation for different users of the site.

STAS, Pathanamthitta Page | 29

Covid-19 Hospital Management System Project Report

(2) Define the mechanics of achieving the navigation.

The main pages used in the system are,

7.6 COMPONENT LEVEL DESIGN

Modern Webapp deliver increasingly sophisticated processing functions
that,
(1) Perform localized processing to generate content and navigation capability in a dynamic
fashion,
(2) Provide computation or data processing capability that is appropriate for the Webapp’s
business domain,
(3) Provide sophisticated database query and access,
(4) Establish data interface with external cooperate system.

6.7 DATABASE DESIGN

The most important aspect of building an application is the
design of database. The data they store must be organized according to the user requirement.
A well-designed database is essential for the good performance of the system. A database
table known as a relation provides information related to specific entity.
The basic functions involved in a database system related to the information required by the
user are:
 Defining the data
 Input the data
 Locating the data
 Communicating the data

Database Name: C19HMS

* Primary Key
Table Name: Admin_Det
FIELD NAME DATATYPE SIZE KEY DESCRIPTION
username VARCHAR 40 Primary Username
key

STAS, Pathanamthitta Page | 30

Covid-19 Hospital Management System Project Report

password VARCHAR 60 Password

last_name VARCHAR 15 First Name
first_name VARCHAR 40 Last Name

Table Name: Pat_Det

FIELD NAME DATATYPE SIZE KEY DESCRIPTION
p_id INT Primary Patient ID
key
doctor_id INT Doctor ID
name VARCHAR 30 Name
phone_no VARCHAR 12 Phone Number
doctor_notes VARCHAR 500 Doctor Notes
status VARCHAR 10 Statuus
address VARCHAR 100 Address
bed_num INT Bed Number
pat_rel_contact VARCHAR 50 Patient Relative
Contact Number
& Name
symptoms VARCHAR 50 Symptoms

Table Name: Doc_Det

FIELD NAME DATATYPE SIZE KEY DESCRIPTION
name VARCHAR 40 Name
specialization VARCHAR 60 Specialization
phone_num VARCHAR 12 Phone Number

STAS, Pathanamthitta Page | 31

Covid-19 Hospital Management System Project Report

d_id INT Primary Doctor ID

key
address VARCHAR 40 Address

Table Name: Bed_Det

FIELD NAME DATATYPE SIZE KEY DESCRIPTION
b_id INT Primary Bed ID
key
Occupied VARCHAR 60 Occupied

6.8. DIAGRAMS

6.8.1 Data flow Diagram (DFD)

The data flow diagram (DFD) is one of the most important tools used
by system analysts. Data flow diagrams are made up of a number of symbols, which
represent system components. Most data flow modeling methods use four kinds of symbols.
These symbols are used to represent four kinds of system components. Possesses, data stores,
data flows and external entities are the components. Circles in DFD represent a process. Data
flow is represented by a thin line in DFD and square or rectangle represents external entities.

Unlike detailed flow chart, data flow diagrams do not

supply detailed description of the modules but graphically describes a system’s data and how
the data interact with the system.

Symbols used in DFD are:

Square, this defines source or destination of data

Arrow, which shows data flow

Circle, which represents a process that transforms

STAS, Pathanamthitta Page | 32

Covid-19 Hospital Management System Project Report

incoming data into outgoing flow

Open rectangle, which shows a data store

Level-0

Request
USER

COVID-19 Response
Hospital
Management
System

USER

Level-1

User Register User

Login

STAS, Pathanamthitta Page | 33

Covid-19 Hospital Management System Project Report

Manage
Manage Beds Manage
Patients
Doctors

Patients Beds
Doctors

7. CODING

STAS, Pathanamthitta Page | 34

Covid-19 Hospital Management System Project Report

7.1 INTRODUCTION
The coding step is a process that transforms design into a programming
language. It translates a detail design representation of software into a programming language
realization. The translation process continues when a compiler accepts source code as input
and produces machine-dependent object code as output. Quality is an important goal during
coding. The quality of source code can be improved by the use of structured coding
techniques; good coding style and readable, consistent code format. During coding, some
coding standards are to be followed. This has two purposes; reducing the chance of making it
easier for some time to modify the code later on. Coding phase affects both testing and
maintenance profoundly. The Covid-19 Hospital Management System uses PHP as the
programming language for coding.

STAS, Pathanamthitta Page | 35

Covid-19 Hospital Management System Project Report

8. TESTING

STAS, Pathanamthitta Page | 36

Covid-19 Hospital Management System Project Report

8.1 INTRODUCTION
The purpose of system testing is to identify and correct errors in the candidate
system. Testing is an important element of the software quality assurance and represents the
ultimate review of specification, design and coding. The increasing visibility of the software
as a system element and the costs associated with a software failure are motivated forces for
well planned, through testing.

Software testing is a critical element of software quality assurance and

represents the ultimate quality review of specifications, design and code generation. Once the
source code has been generated, the program should be executed before the customer gets it
with the specific intend of fining and removing all errors, test must be designed using
disciplined techniques. Testing techniques provides the systematic guidance for designing
tests. To uncover the errors in the program behavior function and performance the following
steps to be done:
 Execute the integral logic of the software components.
 Execute the input and output domains of the program to uncover errors

During testing the system is used experimentally to ensure that the software
does not fail, i.e., it will run according to the specification and in the way the user expects.
Preparation of test data plays n vital role in the system testing. Different set of test data are
generated and the system under study is tested using that data. While testing using test data
errors are again uncovered and corrected using different testing techniques.

STAS, Pathanamthitta Page | 37

Covid-19 Hospital Management System Project Report

System testing was conducted in order to detect errors and for comparing then
the final system with the requirement specification report. That is, whether the system meets
requirements. During testing the software was executed with a set of test cases and the output
of the program for the test cases was evaluated to determine if the program is performing as it
was expected to.

Testing presents, an interesting challenge for the software engineer attends to

hold software from an abstract concept to an acceptable implementation. In testing engineer
creates a series of test cases that o c c u r s w h e n e r r o r s a r e uncovered. Testing is the
process of executing a program for finding errors. A good test is one that has high probability
of finding an uncovered error

The turn error is used to refer the difference between the actual output of the
software and the correct output. Fault is a condition that causes the software to fail to perform
its required function. Software reliability is defined as the required function.

Software reliability is defined as the probability that the software will not
undergo failure for a specified time under specified condition. Failure is the inability of a
system or a component to perform a required function according to its specification.
Different levels of testing were employed for software to make an error free, fault free and
reliable. Basically, in software testing four type of testing methods are adopted.

8.2 CONTENT TESTING

Content testing checks that users can easily understand all items that appear on
a site and, importantly, that they are able to correctly interpret the information they read.
Accordingly, it identifies any problem areas that may require simplification or rewriting. The
overall purpose of testing a content concept is to figure out what content strategy you should
follow throughout the project. This system was tested for successful acceptance and was
found to be working properly.
Content should be logical and easy to understand. Check for spelling errors.
Use of dark colors annoys users and should not be used in site theme. Covid-19 Hospital
Management System follows some standards that are used for web page and content building.

STAS, Pathanamthitta Page | 38

Covid-19 Hospital Management System Project Report

These are common accepted standards like mentioned above about annoying colors, fonts,
frames, etc. Content should be meaningful. All the anchor text links should be working
properly. Images should be placed properly with proper sizes. These are some basic standards
that are followed in Covid-19 Hospital Management System

8.3 USER INTERFACE TESTING

This tests the whole end to end scenario (which simulates

exactly what the user would be doing). This (for the most part) goes through all the mouse
clicks and keyboard presses the user goes through to get an action done. If we extend the
previous example this would be invoking the same action except that this time instead of
using any test hooks it would be using the keyboard shortcut and instead verify the actual
displayed results on the application. User Interface testing is a process to test Covid-19
Hospital Management System user interface and to detect if application is functionally
correct. User Interface testing involves carrying set of tasks and comparing the result of same
with the expected output and ability to repeat same set of tasks multiple times with different
data input and same level of accuracy. User Interface Testing includes how the Covid-19
Hospital Management System handles keyboard and mouse events, how different GUI
components like menu bars, toolbars, dialogs, buttons, edit fields, list controls, images etc.
reacts to user input and whether or not it performs in the desired manner. Implementing User
Interface testing for your application early in the software development cycle speeds up
development, improves quality and reduces risks towards the end of the cycle. User Interface
Testing can be performed both manually with a human tester or could be performed
automatically with use of a software program.

8.4 COMPONENT LEVEL TESTING

Component level testing similar to unit testing but with a higher level of
integration. The big difference here is that the testing is done in the context of the application

STAS, Pathanamthitta Page | 39

Covid-19 Hospital Management System Project Report

instead of just directly testing the method in question. While testing at the component level
you would have the application open and the document displayed but you would be testing
the method and evaluating its result.(without taking into account the shortcut or what get
displayed on the application afterwards). In Covid-19 Hospital Management System, the
system consists of several modules. All modules are tested and were found to be working
properly.

8.5 NAVIGATION TESTING

Navigation testing confirms that all internal and external links of Covid-19
Hospital Management System are working properly. There is no any broken link or orphan
page in application. Once the first layers of the Software have been examined, it is time to
perform simple tests to probe the quality of the global Software navigation. Good Software
will provide consistent, well-executed navigation and should provide alternative navigation
schemes, such as Software maps, indexes, and search engines. First, look to make sure that
placement of navigation is consistent from page to page. Subtle shifting may occur, so try
browsing the site extremely fast and notice whether the menu items bounce or jump position
slightly from page to page. Even this minor variation can break the perceived stability of a
site. Next, look to see how robust the navigation is and whether multiple forms of Software
navigation are supported. Numerous navigation execution questions should be asked during
this phase. The current location clearly indicated with labels or link path indicators. The
Software has text links at the bottoms of pages. Alternative text used for graphical navigation
buttons. The Software requires excessive scrolling.

8.6 CONFIGURATION TESTING

The process of testing a system with each of the configuration of software and
hardware that are supported. Configuration testing is another variation on traditional

STAS, Pathanamthitta Page | 40

Covid-19 Hospital Management System Project Report

performance testing. Rather than testing for performance from the perspective of load you are
testing the effects of configuration changes in the application landscape on application
performance and behavior. Covid-19 Hospital Management System was tested for
successful acceptance and was found to be working properly.

8.7 SECUTITY TESTING

Security testing is the process to determine that an information system protects
data and maintain functionality as intended. During security testing, the tester plays roles of
the individual who desires to penetrate the system. The tester may attempt to acquire
passwords through external clerical means; may attack the system with custom software
designed to breakdown any defenses that have been constructed; may overwhelm the system,
thereby denying service to others; may cause system errors, hoping to find the key to system
entry.
Covid-19 Hospital Management System was tested for successful acceptance
i.e., she/he have to enter username or password to enter to the system. If the username and
password is not correct the message invalid username or password is displayed. So
unauthorized user cannot access the system.

8.8 PERFORMANCE TESTING

Performance testing is designed to test the run time performance of software
within the context of an integrated system. Performance testing occurs throughout all steps in
the testing process. Even at the unit level, performance of individual module may be assessed
as white box tests are conducted, it is not until all system elements are fully integrated that

STAS, Pathanamthitta Page | 41

Covid-19 Hospital Management System Project Report

true performance of a system can be ascertained. This system was tested for successful
acceptance and was found to be working properly.

8.9 TEST CASES

A test case is a document that describes an input, action or event and an
expected response, to determine if a feature of an application is working correctly. A test case
should contain particulars such as test case identifier, test case name, test conditions, input
data requirements steps, and expected results.

Test cases
Project Title : Covid-19 Hospital Management System
Software Tool :
Test objective : To check whether the entered User name and Password are valid or invalid.
Test data : User name = admin and password = admin
Step Steps Data Expected results Actual
no: results
1 Enter User name and User name = Should display warning Login
press LOGIN Button admin message box "Please Enter failed
Password"
2 Enter Password and Password = Should display warning Login
press LOGIN Button admin message box "Please Enter failed
User name “
3 Enter User name and User = admin Should display warning Login
Password and press and Password = message box "Invalid User failed
LOGIN Button XYZ name or Password"

4 Enter User name and User = XYZ and Should display warning Login
Password and press Password = message box "Invalid User failed
LOGIN Button admin name or Password"

STAS, Pathanamthitta Page | 42

Covid-19 Hospital Management System Project Report

5 Enter User name and User = xyz and Should display warning Login
Password and press Password = xyz message box "Invalid User failed
LOGIN Button name or Password"
6 Enter User name and User = “ ” and Should display warning Login
Password and press Password = “ ” message box "Please Enter failed
LOGIN Button User name and Password“
7 Enter User name and User = admin Should navigate to admin Login
Password and press and password home page made
LOGIN Button =admin

9. IMPLEMENTATION

STAS, Pathanamthitta Page | 43

Covid-19 Hospital Management System Project Report

9.1 IMPLEMENTATION OF THE PROJECT

The implementation is the final stage and it is an important phase. It
involves the individual programming; system testing, user training and the operational
running of developed proposed system that constitutes the application subsystems. One major
task of preparing for implementation is education of users, which should really have been
taken place much earlier in the project when they were being involved in the investigation
and the design.

The implementation phase of the software development is concerned with

translating design specifications into source code. The user tests the developed system and
changes are made according to their needs. Our system has been successfully implemented.
Before implementation several tests have been conducted to ensure that no errors are
encounter during the operation. The implementation phase ends with an evaluation of the
system after placing it into operation for a period of time. Implementation is the third phase
of the system process. In order to achieve the objectives and the expected performance the
system has been developed in a highly interactive and user-friendly manner.

9.2 POST-IMPLEMENTATION AND SOFTWARE MAINTENANCE

Maintenance involves the software industry captive, typing up system
resources. It means restoring something to its original condition. Maintenance involves a
wide range of activities including correcting, coding, and design errors, updating
documentation and test data, and upgrading user support. Maintenance was done after the

STAS, Pathanamthitta Page | 44

Covid-19 Hospital Management System Project Report

success implementation. Maintenance is continued till the product is reengineered or

deployed to another platform. Maintenance is also done based on fixing the problems
reported, changing the interface with other software or hardware enhancing the software.

10. PROJECT LEGACY

STAS, Pathanamthitta Page | 45

Covid-19 Hospital Management System Project Report

10.1 CURRENT STATUS OF THE PROJECT

The project Covid-19 Hospital Management System computerizes all
the manual activities in the existing site. As the technology grows, we must adopt the
advantages of the technologies to our organization.
The project titled Covid-19 Hospital Management System has been
done successfully and satisfies all the requirements specified. This system helps in providing
live data to the authorities and help in decision making without wastage of time.
This website provides a user-friendly approach towards the system. This
system has been well developed and when implemented, is bound to satisfy all of the
requirements. Painstaking efforts have been taken to make the system impeccable and
upgradeable. There is a hope that this website will be utilized to its maximum and will do a
good job in the long run. With blessings of God, the exertions are hoped to bear fruit.
The program for carrying out various activities have been run and
successfully tested to ensure that the website developed meets the needs satisfactorily. Any
users can process this system without any experience in any software products. The newly
developed system consumes less processing time and all the details are updated and
processed immediately. Modules are designed to be highly flexible so that any failure
requirements can be easily added to the modules without facing many problems.

10.2 REMAINING AREAS OF CONCERN

The existing system is a manual one. Though the proposed system tries to
overcome the limitations of the existing system, we cannot say that the proposed system is
fully developed. So, the proposed system is developed with an insight that further
modifications can be applied. 

STAS, Pathanamthitta Page | 46

Covid-19 Hospital Management System Project Report

Evolution in technology will give the customer more sophisticated

service. The Covid-19 Hospital Management System system will give a small part of its
actual working. Introducing the distributed database concept can make further extension to
this system. Module related to the functions of Product Dealers will add in future. Trial test
may conduct in future.

11. SOURCE CODE

STAS, Pathanamthitta Page | 47

Covid-19 Hospital Management System Project Report

Manage.py
#!/usr/bin/env python
"""Django's command-line utility for administrative tasks."""
import os
import sys

def main():
"""Run administrative tasks."""
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'core.settings')
try:
from django.core.management import execute_from_command_line
except ImportError as exc:
raise ImportError(
"Couldn't import Django. Are you sure it's installed and "
"available on your PYTHONPATH environment variable? Did you "
"forget to activate a virtual environment?"
) from exc
execute_from_command_line(sys.argv)

if __name__ == '__main__':
main()

Admin.py

STAS, Pathanamthitta Page | 48

Covid-19 Hospital Management System Project Report

from django.contrib import admin

from .models import *
# Register your models here.
admin.site.register(Patient)
admin.site.register(Bed)
admin.site.register(Doctor)

Views.py
from django.shortcuts import render, redirect
from django.http import HttpResponse, JsonResponse
from .models import *
from .filters import PatientFilter
from django.contrib.auth.models import User, auth
from django.contrib import messages
from django.contrib.auth.decorators import login_required
# PatientFilter = OrderFilter

# Create your vie

def login(request):
if request.user.is_authenticated:
return redirect('/')
else:
if request.method == 'POST':
username = request.POST['username']
password = request.POST['password']
user = auth.authenticate(username=username, password=password)
if user is not None:
auth.login(request, user)
return redirect('/')
else:
messages.error(request, 'Invalid username or password')

STAS, Pathanamthitta Page | 49

Covid-19 Hospital Management System Project Report

return redirect('login')
else:
return render(request, 'main/login.html')

@login_required(login_url='login')
def logout(request):
auth.logout(request)
return redirect('/')

def dashboard(request):
patients = Patient.objects.all()
patient_count = patients.count()
patients_recovered = Patient.objects.filter(status="Recovered")
patients_deceased = Patient.objects.filter(status="Deceased")
deceased_count = patients_deceased.count()
recovered_count = patients_recovered.count()
beds = Bed.objects.all()
beds_available = Bed.objects.filter(occupied=False).count()
context = {
'patient_count': patient_count,
'recovered_count': recovered_count,
'beds_available': beds_available,
'deceased_count':deceased_count,
'beds':beds
}
print(patient_count)
return render(request, 'main/dashboard.html', context)

STAS, Pathanamthitta Page | 50

Covid-19 Hospital Management System Project Report

def add_patient(request):
beds = Bed.objects.filter(occupied=False)
doctors = Doctor.objects.all()
if request.method == "POST":
name = request.POST['name']
phone_num = request.POST['phone_num']
patient_relative_name = request.POST['patient_relative_name']
patient_relative_contact = request.POST['patient_relative_contact']
address = request.POST['address']
symptoms = request.POST['symptoms']
prior_ailments = request.POST['prior_ailments']
bed_num_sent = request.POST['bed_num']
bed_num = Bed.objects.get(bed_number=bed_num_sent)
dob = request.POST['dob']
status = request.POST['status']
doctor = request.POST['doctor']
doctor = Doctor.objects.get(name=doctor)
print(request.POST)
patient = Patient.objects.create(
name = name,
phone_num = phone_num,
patient_relative_name = patient_relative_name,
patient_relative_contact = patient_relative_contact,
address = address,
symptoms = symptoms,
prior_ailments = prior_ailments,
bed_num = bed_num,
dob = dob,
doctor=doctor,
status = status
)
patient.save()

STAS, Pathanamthitta Page | 51

Covid-19 Hospital Management System Project Report

bed = Bed.objects.get(bed_number=bed_num_sent)
bed.occupied = True
bed.save()
id = patient.id
return redirect(f"/patient/{id}")

context = {
'beds': beds,
'doctors': doctors
}
return render(request, 'main/add_patient.html', context)

def patient(request, pk):

patient = Patient.objects.get(id=pk)
if request.method == "POST":
doctor = request.POST['doctor']
doctor_time = request.POST['doctor_time']
doctor_notes = request.POST['doctor_notes']
mobile = request.POST['mobile']
mobile2 = request.POST['mobile2']
relativeName = request.POST['relativeName']
address = request.POST['location']
print(doctor_time)
print(doctor_notes)
status = request.POST['status']
doctor = Doctor.objects.get(name=doctor)
print(doctor)
patient.phone_num = mobile
patient.patient_relative_contact = mobile2
patient.patient_relative_name = relativeName
patient.address = address

STAS, Pathanamthitta Page | 52

Covid-19 Hospital Management System Project Report

patient.doctor = doctor
patient.doctors_visiting_time = doctor_time
patient.doctors_notes = doctor_notes
print(patient.doctors_visiting_time)
print(patient.doctors_notes)
patient.status = status
patient.save()
context = {
'patient': patient
}
return render(request, 'main/patient.html', context)

def patient_list(request):
patients = Patient.objects.all()

# filtering
myFilter = PatientFilter(request.GET, queryset=patients)

patients = myFilter.qs
context = {
'patients': patients,
'myFilter': myFilter
}

return render(request, 'main/patient_list.html', context)

'''
def autocomplete(request):
if patient in request.GET:
name = Patient.objects.filter(name__icontains=request.GET.get(patient))
name = ['js', 'python']

STAS, Pathanamthitta Page | 53

Covid-19 Hospital Management System Project Report

names = list()
names.append('Shyren')
print(names)
for patient_name in name:
names.append(patient_name.name)
return JsonResponse(names, safe=False)
return render (request, 'main/patient_list.html')
'''

def autosuggest(request):
query_original = request.GET.get('term')
queryset = Patient.objects.filter(name__icontains=query_original)
mylist = []
mylist += [x.name for x in queryset]
return JsonResponse(mylist, safe=False)

def autodoctor(request):
query_original = request.GET.get('term')
queryset = Doctor.objects.filter(name__icontains=query_original)
mylist = []
mylist += [x.name for x in queryset]
return JsonResponse(mylist, safe=False)

def info(request):
return render(request, "main/info.html")

Models.py
from django.db import models
from multiselectfield import MultiSelectField
# Create your models here.

STAS, Pathanamthitta Page | 54

Covid-19 Hospital Management System Project Report

class Patient(models.Model):
name = models.CharField(max_length=50)
phone_num = models.CharField(max_length=15)
patient_relative_name = models.CharField(max_length=50, null=True)
patient_relative_contact = models.CharField(max_length=15, null=True)
address = models.TextField()
SYMPTOMS = (
('Fever', 'Fever'),
('Dry cough', 'Dry cough'),
('Tiredness', 'Tiredness'),
('Aches and pains', 'Aches and pains'),
('Sore throat', 'Sore throat'),
('Diarrhoea', 'Diarrhoea'),
('Loss of taste or smell', 'Loss of taste or smell'),
('Difficulty in breathing or shortness of breath', 'Difficulty in breathing or shortness of
breath'),
('Chest pain or pressure', 'Chest pain or pressure'),
('Loss of speech or movement', 'Loss of speech or movement'),
)

symptoms = MultiSelectField(choices=SYMPTOMS, null=True)

prior_ailments = models.TextField()
bed_num = models.ForeignKey("Bed", on_delete=models.CASCADE)
dob = models.DateField(null=True)
doctor = models.ForeignKey("Doctor", on_delete=models.CASCADE, null=True)
doctors_notes = models.TextField(null=True, blank=True)
doctors_visiting_time = models.CharField(null=True, max_length=50, blank=True)
status = models.CharField(max_length=50)

def __str__(self):
return self.name

STAS, Pathanamthitta Page | 55

Covid-19 Hospital Management System Project Report

class Bed(models.Model):
bed_number = models.CharField(max_length=50)
occupied = models.BooleanField()
def __str__(self):
return self.bed_number

class Doctor(models.Model):
name = models.CharField(max_length=100)
def __str__(self):
return self.name

Add_patient.html
{% extends 'main/base.html' %}
{% load static %}

{% block contentTitle %}
Add Patients
{% endblock contentTitle %}

{% block content %}

<form action="" method="post">

{% csrf_token %}

<div class="container">
<div class="patient-form ">
<div class="row">
<div class="form-field col-md-6">

STAS, Pathanamthitta Page | 56

Covid-19 Hospital Management System Project Report

<input type="text" id="name" class="input-text" type="text" name="name"

placeholder="Name">
</div>

<div class="form-field col-md-6">

<input type="text" id="phone_num" class="input-text" type="text"
name="phone_num" placeholder="Phone no.">
</div>

<div class="form-field col-md-6">

<input type="text" id="patient_relative_name" class="input-text" type="text"
name="patient_relative_name" placeholder="Relative's name">
</div>

<div class="form-field col-md-6">

<input type="text" id="patient_relative_contact" class="input-text"
type="text" name="patient_relative_contact" placeholder="Relative's contact">
</div>

<div class="form-field col-md-12">

<input type="text" id="patient_relative_contact" class="input-text"
type="text" name="address" placeholder="Address">
</div>

<div class="form-field col-md-6" style="padding-bottom: 4px;">

<input type="text" id="prior_ailments" class="form-control input-text mb-0 p-
0 " style="outline:none" type="text" name="prior_ailments" placeholder="Prior ailments if
any, eg: Diabetes, Thyroid">
</div>

<div class="form-field col-md-4 offset-md-2 mb-4 mx-auto">

<select name="bed_num" class="btn btn-bed" id="bed_num">

STAS, Pathanamthitta Page | 57

Covid-19 Hospital Management System Project Report

{% for bed in beds %}

<option value={{ bed }}>{{ bed }}</option>
{% endfor %}
</div>
</div>

</div>
<div class="row">
<div class="form-field col-md-6">
<input type="date" id="dob" class="input-text" type="date" name="dob">
</div>

<div class="form-field col-md-6">

<select class="input-text" name="status" id="status">
<option class="bg-danger text-white" value="Critical">Critical</option>
<option class="bg-warning text-white"
value="Recovering">Recovering</option>
<option class="bg-success text-white"
value="Recovered">Recovered</option>
<option class="bg-secondary text-white"
value="Deceased">Deceased</option>
</select>
</div>

<div class="form-field col-md-6">

<select class="input-text" name="doctor" id="doctor">
{% for doctor in doctors %}
<option class="" value="{{doctor}}">{{doctor}}</option>
{% endfor %}
</select>
</div>

STAS, Pathanamthitta Page | 58

Covid-19 Hospital Management System Project Report

</div>

{{doctor}}
<!-- symptons field -->
<div class="patient-form row d-flex">
<div class="symptoms row">
<div class="symptoms-label col-12 text-center mt-0">Symptoms</div><br>

<!-- <div class="row"> -->

<div class="common-symptoms col-md-4">
<label for="" class="symptom-type">Common</label><br>

<div class="symptom">
<input type="checkbox" name="symptoms" id="fever" value="Fever"
class="checkbox">
<label for="fever">Fever</label><br>
</div>
<div class="symptom">
<input type="checkbox" name="symptoms" value="Dry Cough"
id="dry_cough">
<label for="">Dry cough</label><br>
</div>
<div class="symptom">
<input type="checkbox" name="symptoms" value="Tiredness"
id="tiredness">
<label for="">Tiredness</label><br>
</div>
</div>

<div class="less-common-symptoms col-md-4">

<div>

STAS, Pathanamthitta Page | 59

Covid-19 Hospital Management System Project Report

<label for="" class="symptom-type">Less Common</label><br>

<div class="symptom">
<input type="checkbox" name="symptoms" value="Aches and pains"
id="aches_and_pain">
<label for="">Aches and pains</label><br>
</div>

<div class="symptom">
<input type="checkbox" name="symptoms" value="Sore Throat"
id="sore_throat">
<label for="">Sore throat</label><br>
</div>

<div class="symptom">
<input type="checkbox" name="symptoms" valu="Diarrhoea"
id="diarrhoea">
<label for="">Diarrhoea</label><br>
</div>

<div class="symptom">
<input type="checkbox" name="symptoms" value="Loss of taste or smell"
id="loss_of_taste_or_smell">
<label for="">Loss of taste or smell</label><br>
</div>
</div>
</div>

<div class="serious-symptoms col-md-4">

<label for="" class="symptom-type">Serious</label><br>

<div class="symptom">

STAS, Pathanamthitta Page | 60

Covid-19 Hospital Management System Project Report

<input type="checkbox" name="symptoms" value="Difficulty in breathing or

shortness of breath" id="difficulty_in_breathing_or_shortness_of_breath">
<label for="">Difficulty in breathing or shortness of breath</label><br>
</div>
<div class="symptom">
<input type="checkbox" name="symptoms" value="Chest pain or pressure"
id="chest_pain_or_pressure">
<label for="">Chest pain or pressure</label><br>
</div>
<div class="symptom">
<input type="checkbox" name="symptoms" value="Loss Of Speech Or
Movement" id="loss_of_speech_or_movement">
<label for="">Loss of speech or movement</label><br>
</div>
</div>

<!-- </div> -->

</div>
</div>

</div>

</div>
</div>
</div>
<button class="btn col-lg-4 btn-block mx-auto btn-info mb-4" >Add Patient</button>
</form>
{% endblock content %}

Login.html
{% load static %}

STAS, Pathanamthitta Page | 61

Covid-19 Hospital Management System Project Report

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta
name="viewport"
content="width=device-width, initial-scale=1.0, shrink-to-fit=no"
/>

<!-- jquery -->

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.5.0/jquery.min.js"
integrity="sha256-xNzN2a4ltkB44Mc/Jz3pT4iU1cmeR0FkXs4pru/JxaQ="
crossorigin="anonymous"></script>

<!-- bootstrap -->

<link
rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
integrity="sha384-
Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm"
crossorigin="anonymous"
/>

<!-- font-awesome -->

<link
rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.14.0/css/all.min.css"
integrity="sha512-
1PKOgIY59xJ8Co8+NE6FZ+LOAZKjy+KY8iq0G4B3CyeY6wYHN3yt9PW0XpSriVlkMX
e40PTKnXrLnZ9+fkDaog=="

STAS, Pathanamthitta Page | 62

Covid-19 Hospital Management System Project Report

crossorigin="anonymous"
/>

<!-- google api font -->

<link href="https://fonts.googleapis.com/css?
family=Lato:300,400,700,300italic,400italic,700italic" rel="stylesheet" type="text/css">

<link rel="stylesheet" href="{% static 'styles/login.css' %}">

<title>Login</title>
</head>

<body id="bootstrap-overrides">

{% if messages %}
{% for message in messages %}
<div class="alert alert-{{message.tags}} alert-dismissible fade show" role="alert">
<strong>Message: </strong> {{message}}
<button type="button" class="close" data-dismiss="alert" aria-label="close" >
<span aria-hidden="true">&times;</span>
</button>
</div>

{% endfor %}
{% endif %}

<div class="container">

<h3 class="heading">Login for Staff</h3>

<div class="login-form">
<form action="" method="post">
{% csrf_token %}

STAS, Pathanamthitta Page | 63

Covid-19 Hospital Management System Project Report

<div class="username">
<div class="name row">
<i class="fas fa-user-shield col-2"></i>
<input id="name" class="input-text col-9" type="text" name="username"
placeholder="Username">
</div>
</div>

<div class="password">
<div class="pass row">
<i class="fas fa-key col-2"></i>
<input id="password" class="input-text col-9" type="password"
name="password" placeholder="Password">
</div>
</div>

<div class="submit-button row">

<div class="form-field col-lg">
<button type="submit" class="submit-btn btn btn-block">Submit</button>
</div>
</div>
</form>
</div>
</div>
</body>

<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"
integrity="sha384-
9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN"
crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.min.js"
integrity="sha384-

STAS, Pathanamthitta Page | 64

Covid-19 Hospital Management System Project Report

w1Q4orYjBQndcko6MimVbzY0tgp4pWB4lZ7lr30WKz0vr/aWKhXdBNmNb5D92v7s"
crossorigin="anonymous"></script>

</html>

12. CONCLUSION

STAS, Pathanamthitta Page | 65

Covid-19 Hospital Management System Project Report

Conclusion

Performance intelligence plays an essential role as part of a broader public health strategy in
guiding the decisions of health system actors on the implementation of contextualized
measures to tackle COVID-19 or any future epidemic as well as their effect on the health
system at large. This should be based on commonly agreed-upon standardized data and fit-
for-purpose indicators, making optimal use of existing health information infrastructures. The
Health Pros Network can make a meaningful contribution.

STAS, Pathanamthitta Page | 66

Covid-19 Hospital Management System Project Report

13. APPENDIX

STAS, Pathanamthitta Page | 67

Covid-19 Hospital Management System Project Report

SCREEN LAYOUT
Login Page

STAS, Pathanamthitta Page | 68

Covid-19 Hospital Management System Project Report

Dash Board Public and Private

STAS, Pathanamthitta Page | 69

Covid-19 Hospital Management System Project Report

Add Patients

STAS, Pathanamthitta Page | 70

Covid-19 Hospital Management System Project Report

Update Patients

STAS, Pathanamthitta Page | 71

Covid-19 Hospital Management System Project Report

View Patient List

STAS, Pathanamthitta Page | 72

Covid-19 Hospital Management System Project Report

14. BIBILOGRAPHY

Books References:

STAS, Pathanamthitta Page | 73

Covid-19 Hospital Management System Project Report

 Learning Python, 5th Edition

 Learning with Python: How to Think Like a Computer Scientist
 Learn Python the Hard Way (3rd Edition)

Web References:

 https://www.scribd.com/document/371478938/medical_shop_management
 https://www.geeksforgeeks.org/django-tutorial/
 https://w3points.com/django-tutorial/

STAS, Pathanamthitta Page | 74