Book a Demo

Author Topic: FK association arrows - how to remove them  (Read 5668 times)

Reed

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
FK association arrows - how to remove them
« on: September 25, 2010, 02:03:25 am »
I am using EA 8.0 for data modeling.  When I create a FK according to official EA directions I get an arrow on the target end of the association.  Yet the documentation reference (http://www.sparxsystems.com/enterprise_architect_user_guide/modeling_languages/create_a_foreign_key.html) shows no arrow.  I do not want the arrow but cannot figure out how to remove it. The direction property is grayed out, i.e., not editable. Anyone have a fix for this?

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: FK association arrows - how to remove them
« Reply #1 on: September 27, 2010, 01:49:04 pm »
In the Association Properties change the direction from "Source -> Destination" to "unspecified".

If the property is greyed our check the diagram, source, and target are not locked for change.

I'd be interested to know how you go with maintaining foreign keys, ease of use etc

S
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: FK association arrows - how to remove them
« Reply #2 on: September 27, 2010, 02:20:39 pm »
The direction field is intentionally disabled for FK associations.
The Sparx Team
[email protected]

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13496
  • Karma: +572/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: FK association arrows - how to remove them
« Reply #3 on: September 27, 2010, 03:17:57 pm »
What's wrong with the arrow? Why don't you want it to show?

Geert

Reed

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: FK association arrows - how to remove them
« Reply #4 on: September 28, 2010, 12:34:06 am »
Quote

If the property is greyed our check the diagram, source, and target are not locked for change.

I'd be interested to know how you go with maintaining foreign keys, ease of use etc

S

The elements on either side of the assoc are not locked.

I'm not sure I understand the maintaining foreign keys question.  We are using EA as our data modeling tool so we need to create FKs to indicate the proper relationships among elements in the model.

Reed

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: FK association arrows - how to remove them
« Reply #5 on: September 28, 2010, 12:41:27 am »
Quote
What's wrong with the arrow? Why don't you want it to show?

Well, for one, the official FK documentation makes it appear as though creating FK relationships can be done without arrows.  And, more importantly, arrows are not part of the standard notation in common data modeling tools.  

It seems to me that the cardinality noted on either side of the relationship along with the labels is sufficient to convey the FK relationship using UML notation.  The arrow does not add any additional information IMO, so I'd rather change the direction to "unspecified".

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13496
  • Karma: +572/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: FK association arrows - how to remove them
« Reply #6 on: September 28, 2010, 03:39:12 pm »
Check the diagram type.
I've noticed that the FK associations on table only display the ERD way (without arrows) when used on a data modelling diagram type.
On a regular class diagram they are displayed as regular associations. (with the arrows)

Geert

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: FK association arrows - how to remove them
« Reply #7 on: October 01, 2010, 07:20:25 am »
Quote
I'm not sure I understand the maintaining foreign keys question.  We are using EA as our data modeling tool so we need to create FKs to indicate the proper relationships among elements in the model.

I too do some data modelling in EA.
I have found maintaining FKs clumsy and difficult to maintain, eg try deleting a FK fully from your model, or changing it.
It might just be me, hence the question  :-*
Orthogonality rules
Using EA16.1 (1627) on Windows 11 Enterprise/64 bit. Repositories in SQLServer2019 DB Schema 1558.
WebEA on Pro Cloud Server 4.2.64

ff

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: FK association arrows - how to remove them
« Reply #8 on: October 07, 2010, 10:35:33 pm »
I use a regular class diagram (with arrows) too for data modeling but I have no problem to change the direction as 'unspecified'.
What I experienced before is that if it is greyed out, by simply editing Name for example, Direction isn't greyed out anymore.

I'm glad now (thank you Geert) that by using a datamodeling diagram, you don't get the arrows, but the classical "crow's feet" notation.

You can obtain this notation also in a regular class diagram by editing the properties of the diagram (Connectors, Connector notation, use "Information Enigineering").

kr,
Flip