Hospitals
| id | name | location |
| 1 | St. Marys Hospital | 123 Main St |
| 2 | New York General | 456 Broadway St |
| 3 | Metro Medical Center | 789 Central Ave |
| 4 | Cedars Sinai | 1011 Ocean Blvd |
| 5 | John Hopkins | 2020 University Pl |
Departments
| id | departmentName |
| 1 | Cardiology |
| 2 | Neurology |
| 3 | Gastroenterology |
| 4 | Orthopedics |
| 5 | Pulmonary Medicine |
Doctors
| id | name | specialtyId | hospitalId |
| | (→ Departments.id) | (→ Hospitals.id) |
| 1 | Dr. Smith | 1 | 1 |
| 2 | Dr. Johnson | 2 | 1 |
| 3 | Dr. Brown | 3 | 2 |
| 4 | Dr. Davis | 4 | 2 |
| 5 | Dr. Miller | 5 | 3 |
Patients
| id | firstName | lastName | age | illnessText |
| 1 | Jane | Doe | 35 | Flu |
| 2 | Michael | Smith | 45 | Broken Arm |
| 3 | Emily | Johnson | 25 | Anxiety |
| 4 | David | Brown | 65 | Diabetes |
| 5 | Karen | Miller | 55 | Asthma |
Appointments
| id | patientId | doctorId | date | time | reasonForVisit |
| (→ Patients.id) | (→ Doctors.id) | | | |
| 1 | 1 | 1 | 2022-01-01 10:00:00 | 10:00 AM | Influenza A |
| 2 | 2 | 2 | 2022-01-02 02:00:00 PM | 02:00 PM | Fractured wrist |
| 3 | 3 | 3 | 2022-01-03 03:00:00 PM | 03:00 PM | Panic attack |
| 4 | 4 | 4 | 2022-01-04 04:00:00 PM | 04:00 PM | Shortness of breath |
| 5 | 5 | 5 | 2022-01-05 05:00:00 PM | 05:00 PM | Allergies |
Hospitals_Departments
| hospitalId | departmentId |
| (→ Hospitals.id) | (→ Departments.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
| 3 | 4 |
| 3 | 5 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |