• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Flight Equipment relationship doubt

 
Gabriel Belingueres
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

From the BDM I see that Flight and Equipment has a 1-1 relationship.

A Flight is traveled over one and only one aircraft (equipment). OK this is a sound requirement.

an specific Equipment only perform one Flight?

I'm thinking Flight as having both a departure and destination cities, this means that there must be a flight from departure A to destination B, and other flight from B to A (on the same aircraft), which makes this relationship one to many.

Am I missing something?

TIA,
Gabriel
 
Piotr Uryga
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think You should assume some things. For example You can assume that relationship Flight->Equipment becomes unidirectional and for every flight in the system, this flight is services by exactly one plane(equipment).

Or You can try and change BDOM (there are success stories of SCEA's who did that), or You can do anything else... just be sure to document it and be confident about Your assumptions and design.

Good luck
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic