Hospitals

HospitalIDNameLocation
1St. Mary's HospitalNew York
2Mount Sinai HospitalChicago
3Rush University Medical CenterChicago
4Yale New Haven HealthConnecticut
5John Hopkins MedicineBaltimore

Departments

DepartmentIDDepartmentNameHospitalID
(→ Hospitals.HospitalID)
1Cardiac Surgery1
2Neurosurgery2
3Orthopedics3
4Pediatrics4
5Emergency Medicine5

Employees

EmployeeIDFirstNameLastNameEmailPhoneNumberMedicalProfessionPatient
1JaneDoejane.doe@example.com555-1234NurseAnne Buche
2MikeSmithmike.smith@example.com555-5678NurseAlice Johnson
3LindaWilliamslinda.williams@example.com555-9012Physician's AssistantAnne Buche
4TomBrowntom.brown@example.com555-1234Physician's AssistantDavid Lee
5KarenGreenkaren.green@example.com555-9876DoctorNone

JobPostings

JobPostIDPositionTitleDescriptionRequirementsStartDateEndDateSalaryVacancyDepartmentID
(→ Departments.DepartmentID)
1Cardiovascular NurseExperience in cardiac care.BLS certification required.2023-01-012023-12-316500031
2Neurology NurseNeurosurgical experience necessary.ACLS certification required.2023-02-012023-12-316000022
3Orthopaedic PAAssisting with orthopaedic surgeries.Certified PAs only.2023-03-012023-12-316500013
4Pediatric NursePediatric nursing experience required.CPR certified.2023-04-012023-12-316000044
5EM ResidentER experience essential.MD degree required.2023-05-012023-12-315500055