| ID | Name |
|---|---|
| 1 | Western Medical Center |
| 2 | Eastern General Hospital |
| 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 |
| 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 |
| ID | Type |
|---|---|
| 1 | Diagnostic Imaging |
| 2 | Cardiac Care Unit |
| 3 | Neurology |
| 4 | Orthopedics |
| 5 | Pediatrics |
| 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 |
| ApplicantId | Fullname | 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 |