How to Add Foreign-key Relationship Between Entities


Uploaded by schemabank on 23.02.2010

Transcript:
To create a foreign-key relationship between entities
You need the two entities ready in ERD pane:
a so-called parent entity and a child entity
Choose the relationship type you want
Click on the parent table and then the child table
A foreign key will be added to child entity
You can place the relationship line the way like it
Likewise for the relationship name
Right click on the relationship and select edit relationship
You can change the properties of the relationship
You can also double click the relationship to edit the properties
To delete the relationship, select the relationship and press the Delete button