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 |