A Trip belongs to a Region in the schema however a Trip (in real-world terms) can easily cross over several regions (e.g. Upper and Lower SE in SA).
Suggested resolution: This would be better as a many to many relationship with Regions shown as a delimited list in the Trip table.
Work around: Segment a real-world trip into multiple sections for each Region.
A Trip belongs to a Region in the schema however a Trip (in real-world terms) can easily cross over several regions (e.g. Upper and Lower SE in SA).
Suggested resolution: This would be better as a many to many relationship with Regions shown as a delimited list in the Trip table.
Work around: Segment a real-world trip into multiple sections for each Region.