Book a Demo

Author Topic: BUG: FK alters multiplicity unilaterally  (Read 2117 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
BUG: FK alters multiplicity unilaterally
« on: August 23, 2007, 09:00:47 pm »
If you use the <context Menu>|Foreign Keys... it will obliterate ANY multiplicity that is present on the origin end.  This is only allowed if the origin multiplicity is unspecified.

If the ColumnSet of foreign Key constraint is unique, then the maximum multiplicity MUST be 1!

While you are repairing this defect, you will NEED to add the following:
[  ] Optional Checkbox to indicate the minimum multiplicity of the origin.  If marked, then the minimum Multiplicity is 0, else 1.
[  ] Unique Checkbox to indicate the maximum multiplicity of the origin.  If marked, then the maximum Multiplicity is 1, else a separate text box will define the number of instances (>=1 - including *).

While you are at it, if the maximum multiplicity is other than *, then the value should be displayed on the diagram.

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: BUG: FK alters multiplicity unilaterally
« Reply #1 on: August 24, 2007, 12:11:41 am »
It is important! it could be help[full
Recursion definition:
If you don’t understand the definition read "Recursion definition".