| 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 |
| 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 |
| HospitalID | RoleID |
|---|---|
| (→ Hospitals.HospitalID) | (→ MedicalRoles.RoleID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |