COVID-19 Database and Tuples
Tags: datascience, database, beginners
Published: 2020-09-06 20:39:22

Hello!

As you have probably heard a thousand times in the past few months, these are uncertain times we are living in. The COVID-19 pandemic has had monstrous impacts on people all over the world, forcing many college students including myself to do their education virtually while also putting many people out of work, and causing the death and loss of nearly 900 thousand people around the world. 

There are many risks and factors that play into the likelihood of an individual person or patient contracting the COVID-19, as well as whether they fully recover from the illness. Because of the many nuanced levels that these factors can take, I have created a Diagram included below that shows many of the entities, relationships and attributes that contribute to risk factors for COVID-19.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/3u66fb56yeb8wykc9suw.png)

The first entity is a patient, which I outlined with five attributes (Age, Gender, Patient ID, Physical Activity Level, and an Underlying Condition). I see these attributes as potential factors for the patient’s risk of contracting COVID-19, and the Patient ID as a primary key to identify the patient at their Occupation as well as in the Hospital.

The second entity is a Geographic Location with the relationship that a Patient lives in a specific Geographic Location. I outlined five attributes for a Geographic Location (Country, Climate, Population Density, Culture, and Government Healthcare Standards) as I see these as markers for a specific Geographic Location to be more likely to have a high quantity of COVID-19 cases.

The third entity is Occupation with the relationship that a Patient has a specific Occupation. I outlined five attributes for an Occupation (Close Contact with Others, Mask Wearing is Feasible, Physically Active, At-Risk Groups, Health Insurance Provided) as I see these as markers for a specific Occupation to be likely to contract COVID-19.

The fourth entity is a Hospital, with the relationships that each Geographic Location has Hospitals and Patients go to Hospitals for treatment/testing. I outlined five attributes for Hospitals (Beds Available, Staff Available, ICU Max Capacity, Treatment or Quarantine Options, and Health Insurance Accepted) as I see these as markers for if a specific Hospital can handle the COVID-19 cases in their area.

The fifth entity is Behavior, with the relationship that a patient displays specific behavior. I outlined five attributes for Behavior (Partying, Wearing Mask, Eating Out, Washing Hands, and Traveling) as I see these specific activities as ways to either increase or decrease a patient’s likelihood of contracting COVID-19.

Finally, the last entity is Testing, with the relationship that Hospitals provide Testing. I outlined five attributes for Testing (Tests Available, Result Speed, Accuracy, Cost, and Locations) as I see these attributes as important markers as to which type of COVID-19 test a patient should get and hospitals should be administering.

Some example tuples for each of these entities is shown below:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dukqta3mg17c9pm4t81m.png)

While this diagram that I have created is in no way a comprehensive description of the risks and factors associated with COVID-19, I do think it can help give an idea of the nuance that is associated with the pandemic and the many different ways one can come into contact and be at risk for the virus. 

You can watch where I walk through this diagram for COVID-19 risks below:

{% youtube ydwcnaSQZs4 %}