## Hospitals

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

## Departments

DepartmentID | DepartmentName | HospitalID
--- | --- | ---
|  | (→ Hospitals.HospitalID)
1 | Cardiac Surgery | 1
2 | Neurosurgery | 2
3 | Orthopedics | 3
4 | Pediatrics | 4
5 | Emergency Medicine | 5

## Employees

EmployeeID | FirstName | LastName | Email | 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

## JobPostings

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