Hospitals

idname
1Western Medical Center
2Eastern General Hospital
3Northern Healthcare
4Central Care Clinic
5City Urgent Care

Jobs

idtitledescriptionlocationsalaryhospital_id
(→ Hospitals.id)
1CT Scan TechnicianPerform CT scans on patients.New York City900001
2MRI TechOperate MRI machines.New York City850001
3ER PhysicianTreat emergency cases.New York City2000001
4Anesthesia NurseMonitor patient during surgeries.New York City1000001
5PharmacistDispense medications.New York City950001
6Family Medicine DoctorDiagnose and treat illnesses.Chicago1600002
7DietitianCreate diet plans for patients.Chicago700002

Doctors

idnamespecialist_doctorhospital_id
(→ Hospitals.id)
1Dr. Jane SmithRadiologist1
2Dr. John BrownRadiologist2
3Ms. Mary JohnsonUltrasound Technician1
4Mr. Mike DavisUltrasound Technician2
5Dr. Sarah WilsonCardiologist3
6Dr. James WhiteGastroenterologist4
7Dr. Jennifer GreenNeurologist1
8Dr. David BlackOrthopedic Surgeon2