Hospitals

HospitalIDNameAddress
1St. Mary's General123 Medical Avenue
2King's College Hospital456 Medical Road
3Queen Elizabeth II Hospital789 Medical Street
4City General Hospital1011 Medical Lane
5University Hospital1213 Medical Circle

Procedures

ProcedureIDProcedureNameDescription
1MRI ScanMagnetic Resonance Imaging scan for diagnostic purposes.
2CT ScanComputed Tomography scan for diagnostic purposes.
3UltrasoundHigh-frequency sound waves used to visualize internal body structures.
4X-rayUse of ionizing radiation to produce images of the inside of a patient's body.
5Blood TestAnalysis of blood samples for various medical conditions.

Hospitals_Procedures

HospitalIDProcedureID
(→ Hospitals.HospitalID)(→ Procedures.ProcedureID)
11
22
33
44
55
21
31
41
51