Book a Demo

Author Topic: Database modeling - Foreign Key problem  (Read 2852 times)

pvodicka

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Database modeling - Foreign Key problem
« on: January 10, 2008, 03:30:24 am »
Hello,
I am new to EA and I am investigation possibilities of this product.
For the first view it looks very well - there is overwhelming amount
of features, ossibilities etc. But I have one problem.
I am trying to repeat steps according to EA manual (for version 7.0),
specifically Data Modeling - creating a Foreign key.  

There is a procedure listed in EA manual - see:
http://www.sparxsystems.com/EAUserGuide/
menu:
Data Modeling - Foreign Key

To create a Foreign Key, follow the steps below:
1.
Locate the required Tables in either a diagram or the Project Browser window.
2.
Select an Associate link in the Class Relationships page of the Enterprise
   Architect UML Toolbox.
3.
Click on the Table to contain the Foreign Key (source) and draw
   a connector to the other Table (target).
4.
Use the link context menu to display the Foreign Key dialog.

But in my version of EA 7.0 I get dialog that is typical for association
of classes - but not for relation between tables - no 'Source - Target' column
lists, no checkboxes for referential integrity (Delete Cascade + Update Cascade).

If I use reverse engineering I also see only typical 'class' associantions between
tables.
My question is obvious - do I do something wrong OR is the feature listed in help
only a suggestion for next EA versions?

Thanks for your info.
Peter
 

peter.zrnko

  • EA User
  • **
  • Posts: 253
  • Karma: +0/-0
    • View Profile
Re: Database modeling - Foreign Key problem
« Reply #1 on: January 10, 2008, 04:00:55 am »
step 4.
Right click the link and select "Foreign keys" (4. item in the context menu).
Peter

pvodicka

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Database modeling - Foreign Key problem
« Reply #2 on: January 10, 2008, 04:27:30 am »
SOLVED
Sorry to all for this question - I am totally blind - I discoverd that I must right click an association and there is a foreign key aoption - I kept finding this option on Association Properties dialog box - shame on me!

Regards,
Peter