Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: JKSQL on December 17, 2008, 09:59:57 am
-
I am coming from using SQL database designer within Management studio. I have started to use EA 7.0 and I am finding it difficult at best to do the things that were easy within management studio. I am not asking for much here so maybe someone could help me figure out the following
1) When I create a diagram off of existing SQL tables and they have PK,FK set up is there a way to display those references automatically.
2) Is there a way to display the names of the FK's on the diagram without using labels. In Management studio I just right click and say show descriptions.
3) Are there some good links on how to do specifically DB data diagrams. Videos would work great
I can see this looks to be a great product and i am only using a small amount of it. I will take any advise I can get
JK
-
I have a similar question. I am just trying the data modeling features for the first time in EA today. I have used many other modeling tools such as ERwin - but EA seems a far cry. Ideally, I would like to be able to do my data modeling in my EA model so that I can get that 'traceability' going for me that everyone raves about. But I am reminded of the old expression: "When all you have is a hammer, everything starts to look like a nail!"
I would love to do something very simple such as modeling 3 tables. Two independent tables that have a 1:n association to a join table between them. I want the PKs from the 'independent' tables to migrate automatically to the join table as FKs (as a new composite primary key on the Join table). I am having a heck of a time trying to figure out how to do this.
-
But it's simple.
Craete association between 2 tables.Right click on association link and choose Foreign Key. And set it.
For labels, Right click on Association link asd choose Set visibility=>Set Lable Visibility and customize it.