DB Design

[JKSQL]

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

[operaman]

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.

[Elham]

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.