Support
Following on from your theory, how would the individual systems request, updates?
Would they be 'forced' down the links, or would users need to run some kind of populate/ update request?
For Airlines - could wrong flight ID's v Company names via Airlines table be used?
Is the Airlines table updated automatically?
Also how are the Routes i the table being updated?
Thanks.