Diagnostic_Centers

CenterIDNameAddress
1Center A123 Main St
2Center B456 Elm St
3Center C789 Oak St
4Center D01 Second Ave
5Center ELast St 23

Tests

TestTypeIDTestName
1Blood_Test
2X-Ray
3Ultrasound
4MRI
5CT Scan

Patients

PatientIDFirstNameLastNameDateOfBirthPhoneNumber
1JohnDoe2000-01-01555-123-4567
2JaneSmith1999-02-02555-987-6543
3AliceBrown2001-03-03555-000-0000
4BobWhite1998-04-04555-111-2222
5EmmaGreen2002-05-05555-333-4444

Appointments

AppointmentIDCenterIDPatientIDAppointmentDate
(→ Diagnostic_Centers.CenterID)(→ Patients.PatientID)
1112022-06-01
2222022-06-02
3332022-06-03
4442022-06-04
5552022-06-05

Results

ResultIDAppointmentIDTestResultTextResultDate
(→ Appointments.AppointmentID)
11Normal2022-06-01
22Abnormal2022-06-02
33Positive2022-06-03
44Negative2022-06-04
55Inconclusive2022-06-05

Diagnostic_Centers_Tests

DiagnosticCenterIDTestTypeID
(→ Diagnostic_Centers.CenterID)(→ Tests.TestTypeID)
11
21
31
41
51
54