Relationships describe how the entities relate to one another. A new relationship may be needed to reflect the addition of a join to a database structure.
After creating relationships in a model, modify them by:
To add relationships, use the Create Relationships or Add Relationship commands, click Create Relationships on the Entity/New Entity dialog box, drag entities to the Canvas pane, or click Suggest Relationships in the Model Test window.