## Hospitals

ID | Name
--- | ---
1 | Western Medical Center
2 | Eastern General Hospital

## Radiologists

ID | Name | Department | HospitalName
--- | --- | --- | ---
|  | (→ Departments.ID) | (→ Hospitals.Name)
1 | John Doe | 1 | Western Medical Center
2 | Jane Smith | 1 | Eastern General Hospital
3 | Alice Johnson | 2 | Western Medical Center
4 | Bob Brown | 3 | Eastern General Hospital
5 | Charlie Davis | 4 | Western Medical Center
6 | Diana Miller | 5 | Eastern General Hospital

## UltraSoundTechs

ID | Name | Department | HospitalName
--- | --- | --- | ---
|  | (→ Departments.ID) | (→ Hospitals.Name)
1 | Mike White | 1 | Western Medical Center
2 | Emily Green | 2 | Eastern General Hospital
3 | Paul Black | 3 | Western Medical Center
4 | Kelly Red | 4 | Eastern General Hospital
5 | Robert Blue | 5 | Western Medical Center
6 | Nancy Silver | 6 | Eastern General Hospital

## Departments

ID | Type
--- | ---
1 | Diagnostic Imaging
2 | Cardiac Care Unit
3 | Neurology
4 | Orthopedics
5 | Pediatrics

## JobPostings

JobId | Title | Description | StartDate | EndDate | Requirements | Salary | DepartmentID
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Departments.ID)
1 | Radiology Technician | Assist radiologists in performing medical imaging examinations. | 2022-09-01 | 2023-08-31 | Bachelor's degree in Radiologic Technology required. | 75000 | 1
2 | Ultrasonographer | Operate ultrasound equipment to visualize internal organs and structures. | 2022-09-01 | 2023-08-31 | Associates degree in Diagnostic Medical Sonography required. | 60000 | 2
3 | Cardiovascular Perfusionist | Perform cardiopulmonary bypass procedures during open heart surgery. | 2022-09-01 | 2023-08-31 | Certified Clinical Perfusionist credential required. | 85000 | 3
4 | Neurosonographer | Use ultrasound technology to assess neurological conditions. | 2022-09-01 | 2023-08-31 | Bachelors Degree in Neurodiagnostics required. | 70000 | 4
5 | Physical Therapist | Design and implement treatment plans for patients recovering from injuries. | 2022-09-01 | 2023-08-31 | Doctor of Physical Therapy degree required. | 80000 | 5
6 | Occupational Therapist | Help patients develop, recover, and improve skills needed for daily living activities. | 2022-09-01 | 2023-08-31 | Master's degree in Occupational Therapy required. | 75000 | 6

## Applicants

ApplicantId | Fullname | Email | PhoneNumber | Application
--- | --- | --- | --- | ---
1 | Alexander Anderson | alex@email.com | +1 555-123-4567 | Attached CV
2 | Grace Kim | grace@email.com | +1 555-987-6543 | Attached CV
3 | William Lee | william@email.com | +1 555-555-5555 | Attached CV
4 | Samantha Martinez | samantha@email.com | +1 555-123-4567 | Attached CV
5 | Daniel Wilson | daniel@email.com | +1 555-987-6543 | Attached CV
6 | David Harris | david@email.com | +1 555-555-5555 | Attached CV