Diagnostic_Centers
| CenterID | Name | Address |
| 1 | Center A | 123 Main St |
| 2 | Center B | 456 Elm St |
| 3 | Center C | 789 Oak St |
| 4 | Center D | 01 Second Ave |
| 5 | Center E | Last St 23 |
Tests
| TestTypeID | TestName |
| 1 | Blood_Test |
| 2 | X-Ray |
| 3 | Ultrasound |
| 4 | MRI |
| 5 | CT Scan |
Patients
| PatientID | FirstName | LastName | DateOfBirth | PhoneNumber |
| 1 | John | Doe | 2000-01-01 | 555-123-4567 |
| 2 | Jane | Smith | 1999-02-02 | 555-987-6543 |
| 3 | Alice | Brown | 2001-03-03 | 555-000-0000 |
| 4 | Bob | White | 1998-04-04 | 555-111-2222 |
| 5 | Emma | Green | 2002-05-05 | 555-333-4444 |
Appointments
| AppointmentID | CenterID | PatientID | AppointmentDate |
| (→ Diagnostic_Centers.CenterID) | (→ Patients.PatientID) | |
| 1 | 1 | 1 | 2022-06-01 |
| 2 | 2 | 2 | 2022-06-02 |
| 3 | 3 | 3 | 2022-06-03 |
| 4 | 4 | 4 | 2022-06-04 |
| 5 | 5 | 5 | 2022-06-05 |
Results
| ResultID | AppointmentID | TestResultText | ResultDate |
| (→ Appointments.AppointmentID) | | |
| 1 | 1 | Normal | 2022-06-01 |
| 2 | 2 | Abnormal | 2022-06-02 |
| 3 | 3 | Positive | 2022-06-03 |
| 4 | 4 | Negative | 2022-06-04 |
| 5 | 5 | Inconclusive | 2022-06-05 |
Diagnostic_Centers_Tests
| DiagnosticCenterID | TestTypeID |
| (→ Diagnostic_Centers.CenterID) | (→ Tests.TestTypeID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |