Friends If we consider flight from Amsterdam - Sydney, lets assume that it consists of 2 segments Amsterdam- Dubai Dubai - Sydney
With each segment is a unique flight no lets say A111 & B222 On a given day there can be more than one flight from Amsterdam to Dubai. If yes then how can we have 1:1 relationship between segment and flight ?
I have spent two weeks thinking in this issue and, in the end, I decide to change the relationship. You can do whatever you think it is correct, just justify you design. If you search at the forum you will realize that there are a lot of people who had passed changing and not changing the relationship. But I couldn�t find a way of using the given relationships and I decided to change it.
If you search at the forum, you will find a lot of posts trying to explain what is a Flight, a Segment, Leg, etc�
Joined: Dec 15, 2004
I guess you are right. Its best to make an assumption and move forward.No trying to break your head over something you have no control. Thanks.