Hospital

idname
1Western Medical Center
2Eastern General Hospital
3Northern Healthcare System
4Central Valley Clinic

Radiologist

idhospital_idfirst_namelast_name
(→ Hospital.id)
11JohnDoe
22JaneSmith
33AliceBrown
44MichaelJohnson

Ultrasound_Tech

idhospital_idfirst_namelast_name
(→ Hospital.id)
11EmmaJones
22DavidWilliams
33LisaMartin
44RobertThomas

JobPosting

idtitledescriptionsalarypost_date
1RadiologistPerform diagnostic imaging procedures.80000.02022-01-01
2Ultrasound TechnicianOperate ultrasound equipment for medical imaging.60000.02022-01-02
3RadiographerProduce X-ray images and other diagnostic images.70000.02022-01-03
4Diagnostic Medical SonographerConduct ultrasound examinations on patients.65000.02022-01-04
5Healthcare AdministratorManage healthcare facility operations and staff.55000.02022-01-05

RadiologistJob

radiologist_idjob_posting_idstart_dateend_date
(→ Radiologist.id)(→ JobPosting.id)
112022-01-152023-01-15
222022-01-202023-01-20
332022-01-252023-01-25
442022-01-302023-01-30

TechJob

tech_idjob_posting_idstart_dateend_date
(→ Ultrasound_Tech.id)(→ JobPosting.id)
112022-01-162023-01-16
222022-01-212023-01-21
332022-01-262023-01-26
442022-01-312023-01-31