I have a set of users and their itinerary details. I want to figure out who all will be sharing a common flight. I do not want to rely too much on the "Departure time" as people could have entered an approximate time into the system. How can I figure this out with minimal information?
Initially, I thought two people with the same flight number and same departure date would be on the same flight. But the same flight can be used again on the same day. Would the combination of "Flight no + departure date + departure city" be enough to identify a unique flight itinerary?
What would be optimal information to identify this?
I also have to keep in mind that there could be people with multiple flights in their itinerary and if at least one flight is common with another passenger, that has to be shown too.