Medical_Center

IDNameLocation
1St. Johns HospitalNew York
2Mercy General HospitalChicago
3Mount Sinai HospitalLos Angeles
4Memorial Hermann HospitalHouston
5Mayo ClinicRochester

Specialty

IDType
1Emergency Medicine
2Cardiology
3Gastroenterology
4Neurology
5Orthopedics

Medical_Center_Specialty

Medical_Center_IDSpecialty_ID
(→ Medical_Center.ID)(→ Specialty.ID)
11
21
31
41
51
52

Doctor

IDFirstNameLastNameLicenseNumber
1JohnDoeMD123456789
2JaneSmithMD987654321
3MichaelJohnsonMD345678901
4EmilyWilliamsMD789012345
5DavidBrownMD234567890

Patient

IDFirstNameLastNameDateOfBirthPhoneNumber
1AliceWilson1990-01-01555-123-4567
2BobThompson1985-02-02555-987-6543
3CarolJackson1975-03-03555-432-1234
4DanielMartin1992-04-04555-654-3210
5ElizabethTaylor1988-05-05555-132-4568

Appointment

IDPatient_IDDoctor_IDStartTimeEndTime
(→ Patient.ID)(→ Doctor.ID)
1112022-01-01 09:00:002022-01-01 10:00:00
2222022-01-02 09:00:002022-01-02 10:00:00
3332022-01-03 09:00:002022-01-03 10:00:00
4442022-01-04 09:00:002022-01-04 10:00:00
5552022-01-05 09:00:002022-01-05 10:00:00