Epidemiological_Study

study_idnamestart_dateend_date
1COVID-19 Study2020-03-012021-06-01
2Flu Study2020-08-012021-07-01
3Diabetes Study2020-04-012021-09-01
4Heart Disease Study2020-05-012021-10-01
5Obesity Study2020-06-012021-11-01

Methods

method_idmethod_name
1Survey
2Blood Test
3Questionnaire
4Physical Exam
5Imaging

Study_Participants

participant_idepidemiological_study_idfirst_namelast_nameage
(→ Epidemiological_Study.study_id)
11JohnDoe30
21JaneSmith25
32BobBrown40
42AliceGreen35
53TomWhite50

Diseases

disease_iddisease_name
1Covid-19
2Influenza
3Type II Diabetes
4Coronary Heart Disease
5Obesity

Diagnoses

diagnosis_idparticipant_iddisease_iddate_of_diagnosis
(→ Study_Participants.participant_id)(→ Diseases.disease_id)
1112020-04-01
2122020-04-15
3232020-05-01
4242020-05-15
5352020-06-01

Epidemiological_Study_Methods

epidemiological_study_idmethod_id
(→ Epidemiological_Study.study_id)(→ Methods.method_id)
11
12
23
24
35
21
31
41
51