Hospitals

HospitalIDNameLocation
1St. Mary's GeneralNew York
2Memorial Health SystemChicago
3University HospitalLos Angeles
4Mount Sinai Medical CenterMiami
5Mercy Regional Medical CenterPhoenix

MedicalRoles

RoleIDRoleNameSalary
1Registered Nurse70000.0
2Physician130000.0
3Pharmacist90000.0
4Radiologist110000.0
5Lab Technician65000.0

Hospitals_Medical_Roles

HospitalIDRoleID
(→ Hospitals.HospitalID)(→ MedicalRoles.RoleID)
11
21
31
41
51
54