## Hospitals

id | name
--- | ---
1 | Western Medical Center
2 | Eastern General Hospital
3 | Northern Healthcare
4 | Central Care Clinic
5 | City Urgent Care

## Jobs

id | title | description | location | salary | hospital_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Hospitals.id)
1 | CT Scan Technician | Perform CT scans on patients. | New York City | 90000 | 1
2 | MRI Tech | Operate MRI machines. | New York City | 85000 | 1
3 | ER Physician | Treat emergency cases. | New York City | 200000 | 1
4 | Anesthesia Nurse | Monitor patient during surgeries. | New York City | 100000 | 1
5 | Pharmacist | Dispense medications. | New York City | 95000 | 1
6 | Family Medicine Doctor | Diagnose and treat illnesses. | Chicago | 160000 | 2
7 | Dietitian | Create diet plans for patients. | Chicago | 70000 | 2

## Doctors

id | name | specialist_doctor | hospital_id
--- | --- | --- | ---
|  |  | (→ Hospitals.id)
1 | Dr. Jane Smith | Radiologist | 1
2 | Dr. John Brown | Radiologist | 2
3 | Ms. Mary Johnson | Ultrasound Technician | 1
4 | Mr. Mike Davis | Ultrasound Technician | 2
5 | Dr. Sarah Wilson | Cardiologist | 3
6 | Dr. James White | Gastroenterologist | 4
7 | Dr. Jennifer Green | Neurologist | 1
8 | Dr. David Black | Orthopedic Surgeon | 2