Hospitals

IDName
1Western Medical Center
2Eastern General Hospital

Radiologists

IDNameDepartmentHospitalName
(→ Departments.ID)(→ Hospitals.Name)
1John Doe1Western Medical Center
2Jane Smith1Eastern General Hospital
3Alice Johnson2Western Medical Center
4Bob Brown3Eastern General Hospital
5Charlie Davis4Western Medical Center
6Diana Miller5Eastern General Hospital

UltraSoundTechs

IDNameDepartmentHospitalName
(→ Departments.ID)(→ Hospitals.Name)
1Mike White1Western Medical Center
2Emily Green2Eastern General Hospital
3Paul Black3Western Medical Center
4Kelly Red4Eastern General Hospital
5Robert Blue5Western Medical Center
6Nancy Silver6Eastern General Hospital

Departments

IDType
1Diagnostic Imaging
2Cardiac Care Unit
3Neurology
4Orthopedics
5Pediatrics

JobPostings

JobIdTitleDescriptionStartDateEndDateRequirementsSalaryDepartmentID
(→ Departments.ID)
1Radiology TechnicianAssist radiologists in performing medical imaging examinations.2022-09-012023-08-31Bachelor's degree in Radiologic Technology required.750001
2UltrasonographerOperate ultrasound equipment to visualize internal organs and structures.2022-09-012023-08-31Associates degree in Diagnostic Medical Sonography required.600002
3Cardiovascular PerfusionistPerform cardiopulmonary bypass procedures during open heart surgery.2022-09-012023-08-31Certified Clinical Perfusionist credential required.850003
4NeurosonographerUse ultrasound technology to assess neurological conditions.2022-09-012023-08-31Bachelors Degree in Neurodiagnostics required.700004
5Physical TherapistDesign and implement treatment plans for patients recovering from injuries.2022-09-012023-08-31Doctor of Physical Therapy degree required.800005
6Occupational TherapistHelp patients develop, recover, and improve skills needed for daily living activities.2022-09-012023-08-31Master's degree in Occupational Therapy required.750006

Applicants

ApplicantIdFullnameEmailPhoneNumberApplication
1Alexander Andersonalex@email.com+1 555-123-4567Attached CV
2Grace Kimgrace@email.com+1 555-987-6543Attached CV
3William Leewilliam@email.com+1 555-555-5555Attached CV
4Samantha Martinezsamantha@email.com+1 555-123-4567Attached CV
5Daniel Wilsondaniel@email.com+1 555-987-6543Attached CV
6David Harrisdavid@email.com+1 555-555-5555Attached CV