Epidemiological_Study
| study_id | name | start_date | end_date |
| 1 | COVID-19 Study | 2020-03-01 | 2021-06-01 |
| 2 | Flu Study | 2020-08-01 | 2021-07-01 |
| 3 | Diabetes Study | 2020-04-01 | 2021-09-01 |
| 4 | Heart Disease Study | 2020-05-01 | 2021-10-01 |
| 5 | Obesity Study | 2020-06-01 | 2021-11-01 |
Methods
| method_id | method_name |
| 1 | Survey |
| 2 | Blood Test |
| 3 | Questionnaire |
| 4 | Physical Exam |
| 5 | Imaging |
Study_Participants
| participant_id | epidemiological_study_id | first_name | last_name | age |
| (→ Epidemiological_Study.study_id) | | | |
| 1 | 1 | John | Doe | 30 |
| 2 | 1 | Jane | Smith | 25 |
| 3 | 2 | Bob | Brown | 40 |
| 4 | 2 | Alice | Green | 35 |
| 5 | 3 | Tom | White | 50 |
Diseases
| disease_id | disease_name |
| 1 | Covid-19 |
| 2 | Influenza |
| 3 | Type II Diabetes |
| 4 | Coronary Heart Disease |
| 5 | Obesity |
Diagnoses
| diagnosis_id | participant_id | disease_id | date_of_diagnosis |
| (→ Study_Participants.participant_id) | (→ Diseases.disease_id) | |
| 1 | 1 | 1 | 2020-04-01 |
| 2 | 1 | 2 | 2020-04-15 |
| 3 | 2 | 3 | 2020-05-01 |
| 4 | 2 | 4 | 2020-05-15 |
| 5 | 3 | 5 | 2020-06-01 |
Epidemiological_Study_Methods
| epidemiological_study_id | method_id |
| (→ Epidemiological_Study.study_id) | (→ Methods.method_id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 3 | 5 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |