Airports

idnamelocationIATA_CodeICAO_Codeairport_services
1New York JFKQueens, New YorkJFKNYJFLost Property
2Los Angeles LAXLos Angeles, CaliforniaLAXKLAXLost Property

Services

idservice_name
1Lost Property
2Customer Complaints

ServiceOfferings

idairport_idservice_iddate
(→ Airports.id)(→ Services.id)
1112023-12-01
2222023-12-01
3112024-01-05
4222024-01-06

CustomerComplaints

complaint_idairport_service_offering_idcustomer_complaint
(→ ServiceOfferings.id)
11Delayed baggage claim
22Unclean restrooms
33Poor wifi connection
44Lack of seating