| Author |
Message |
|
2006/12/24 18:28
|
|
|
Matic Petek
Joined: 2006/12/24
Messages: 4
Location: Komenda, Slovenia
Offline
|
|
|
|
Hello,
I read the second User's Guide book and I have one question. On picture "Figure 15.18 - Mapping between Data Model and DDL", we can see column "#DepartmentID : int" that present relationship between two diagrams. How can I create this kind of column? A create simple diagram with FK relationship, but their is no additional column.
I also edit properties for detail entity. Entity Specification -> Relations -> Open specification (for selected relation). Probably I should do something via "Foreign key Column Mapping" tab? But their is no action available.
Please help. Thank you.
My environment : Win XP, VP 6.0
Regards,
Matic
|
|
|
|
 |
| |
|
|
2006/12/27 08:11
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hi Matic,
The column #DepartmentID is generated from the PK column of the entity Department. Please try this:
1. Create the Department entity
2. Add an ID PK column
3. Create the Staff entity
4. Link up Department and Staff entity with a 1:M relationship.
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
|
|
2006/12/27 16:07
|
|
|
Matic Petek
Joined: 2006/12/24
Messages: 4
Location: Komenda, Slovenia
Offline
|
|
|
|
Jick,
It is working. Thank you.
Regards,
Matic
|
|
|
|
|
| |
