Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

1:1 relationship between flight & Segment ?

 
Vinay Singh
Ranch Hand
Posts: 174
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Samuel Pessorrusso
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vinays,

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�

Best regards.
 
Vinay Singh
Ranch Hand
Posts: 174
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic