Airports

IdNameLocation
1New York JFKUSA
2London HeathrowUK
3Tokyo HanedaJapan

Medical_Clinics

ClinicIdAirportIdName
(→ Airports.Id)
11JFK Health Center
22Heathrow Medical Services
33Haneda Medical Point

First_Aid_Stations

StationIdAirportIdName
(→ Airports.Id)
11Terminal 1 First Aid
22Terminal 3 First Aid
33International Terminal First Aid

Medical_Supplies

SuppliesIdDescriptionQuantity
1Bandages and Antiseptics100
2Intravenous Fluids75
3Oxygen Masks50
4Defibrillators25
5Emergency Blankets100

Medical_Clinic_Supplies

ClinicSuppliesIdClinicIdSuppliesIdAmount
(→ Medical_Clinics.ClinicId)(→ Medical_Supplies.SuppliesId)
11150
21225
32160
42230
53180
63240

First_Aid_Station_Supplies

AidStationSuppliesIdStationIdSuppliesIdAmount
(→ First_Aid_Stations.StationId)(→ Medical_Supplies.SuppliesId)
11130
21215
32140
42220
53150
63225