Skip to content

Latest commit

 

History

History
92 lines (42 loc) · 4.57 KB

File metadata and controls

92 lines (42 loc) · 4.57 KB

Covid-19 Database Management System

Project Statement

The outbreak of Coronavirus in the world has big implications for the world. The closure of higher education institutions as well as the broader measures undertaken in many countries to restrict mobility of citizens and increase social distancing hampers the regular implementation of most of the ongoing or planned activities. The Commission and the Agency are acutely aware of the difficulties faced by project beneficiaries in this respect. Our foremost concern, that we know you share, is the safety and protection of all the participants. This note aims to provide clarifications and general recommendations in order to support consortia in managing these exceptional circumstances.

Solution

To manage all the relevant areas and features, we design database schema and implement IMS for COVID’19 outbreak. Some general features against COVID’19 Management System are mentioned below.

Core Features

Some major and core features of COVID’19 Management System are as follows:

1-Isolation wards (and its complete management). (DML Query)

2-Quarantine wards (and its complete management). (DML Query)

3-Symptoms, Preventing Measure and Treatment of Covid'19.

4-Patient Record (add, edit, delete recovered/deaths/active cases). (DML Query)

5-Recommendations of outbreak in your region(s).

6-Percentage of COVID outbreak in your region/country. (DDL Query)

7-Emergency Call numbers/centers available in your city/region. (DDL Query)

Additional Goals

Generating statistical reports on timely basis using Sql queries. Calculation of initial trends as patient symptoms.

Objectives

The point of the organization will be to give individuals the details identified with COVID-19 and educate them with the data from the specialists and other authority assets so they can forestall themselves structure the pandemic circumstance.

Screenshots of project

Here are some screenshots of the working project.

Home Screen

Pakistan Patient Home Page

Pie Chart of pakistani patient

International Patient Home Page

Pie Chart of international patient

Patient Record

Patient Record Home Page

Add New Patient

Edit Patient

Delete Patient

Quarantine Wards

Quarantine Wards Home

Add Patient in Quarantine Wards

Remove Patient From Quarantine Wards

Isolation Wards

Isolation Wards Home

Add Patient in Isolation Wards

Remove Patient From Isolation Wards

Symptoms

Symptoms tab

I hope you enjoy this project and you have learned something new from this project.