| HospitalID | Name | Location |
|---|---|---|
| 1 | St. Mary's Hospital | New York |
| 2 | Mount Sinai Hospital | Chicago |
| 3 | Rush University Medical Center | Chicago |
| 4 | Yale New Haven Health | Connecticut |
| 5 | John Hopkins Medicine | Baltimore |
| DepartmentID | DepartmentName | HospitalID |
|---|---|---|
| (→ Hospitals.HospitalID) | ||
| 1 | Cardiac Surgery | 1 |
| 2 | Neurosurgery | 2 |
| 3 | Orthopedics | 3 |
| 4 | Pediatrics | 4 |
| 5 | Emergency Medicine | 5 |
| EmployeeID | FirstName | LastName | PhoneNumber | MedicalProfession | Patient | |
|---|---|---|---|---|---|---|
| 1 | Jane | Doe | jane.doe@example.com | 555-1234 | Nurse | Anne Buche |
| 2 | Mike | Smith | mike.smith@example.com | 555-5678 | Nurse | Alice Johnson |
| 3 | Linda | Williams | linda.williams@example.com | 555-9012 | Physician's Assistant | Anne Buche |
| 4 | Tom | Brown | tom.brown@example.com | 555-1234 | Physician's Assistant | David Lee |
| 5 | Karen | Green | karen.green@example.com | 555-9876 | Doctor | None |
| JobPostID | PositionTitle | Description | Requirements | StartDate | EndDate | Salary | Vacancy | DepartmentID |
|---|---|---|---|---|---|---|---|---|
| (→ Departments.DepartmentID) | ||||||||
| 1 | Cardiovascular Nurse | Experience in cardiac care. | BLS certification required. | 2023-01-01 | 2023-12-31 | 65000 | 3 | 1 |
| 2 | Neurology Nurse | Neurosurgical experience necessary. | ACLS certification required. | 2023-02-01 | 2023-12-31 | 60000 | 2 | 2 |
| 3 | Orthopaedic PA | Assisting with orthopaedic surgeries. | Certified PAs only. | 2023-03-01 | 2023-12-31 | 65000 | 1 | 3 |
| 4 | Pediatric Nurse | Pediatric nursing experience required. | CPR certified. | 2023-04-01 | 2023-12-31 | 60000 | 4 | 4 |
| 5 | EM Resident | ER experience essential. | MD degree required. | 2023-05-01 | 2023-12-31 | 55000 | 5 | 5 |