## Hospitals

HospitalID | Name | Location
--- | --- | ---
1 | St. Mary's General | New York
2 | Memorial Health System | Chicago
3 | University Hospital | Los Angeles
4 | Mount Sinai Medical Center | Miami
5 | Mercy Regional Medical Center | Phoenix

## MedicalRoles

RoleID | RoleName | Salary
--- | --- | ---
1 | Registered Nurse | 70000.0
2 | Physician | 130000.0
3 | Pharmacist | 90000.0
4 | Radiologist | 110000.0
5 | Lab Technician | 65000.0

## Hospitals_Medical_Roles

HospitalID | RoleID
--- | ---
(→ Hospitals.HospitalID) | (→ MedicalRoles.RoleID)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4