Hi, Sorry to start this conversation again and again but it just so confusing. I am just trying to put some understanding to it.
If we define "Segment" as all travel under a single flight number.
If we take an example of flight on the 30th June 2005 that is scheduled to fly from NY to Dallas through DC and Atlanta without change in flight.
a) Customer A has booked a flight from NY to Dallas and has got "Seat A"
b) Customer B has booked a flight from NY to DC and has got "Seat B"
c) Customer C has booked a flight from DC to Atlanta and has got "Seat B" as customer B will get off at DC so that seat can be again reserved for the same flight
Now in above cases we have multiple customers, each having 1 itinerary and 1 segment and all are assigned to same flight as the flight number didnt change at all, but we have different origin and destination city depending upon the segments of different itineraries of different customer.
Now the intriguing thing is that we should have many to 1 relation between segment and flight, 1 to 1 relation between segment and flight doesnt make sense ..or i am really missing something or i am going out of scope of the requirements.
Is this "flight" need to be described in some other way round, i have read post like it can be though of like a service provider by an airline for the segment and but how to put in real situation.