Creating a Relationship

Use one of the Relationship tools in the Toolbox. Click inside the first entity and drag to the second entity:

Tool	Description
	One-Many Relationship - Link one instance of the first entity to multiple instances of the second entity. In this example, each department can contain many employees and each employee can belong to one department:
	Many-Many Relationship - Link multiple instances of the first entity to multiple instances of the second entity. In this example, each employee can work on multiple projects and each project can have multiple employees working on it:
	One-Many Dependent Relationship - Link one instance of the first entity to multiple instances of the second entity and specifies that each of the many second entities is dependent on and is partially identified by the first entity. In this example, each project can contain multiple tasks and each task must belong to one project:

Note You can further refine or change the nature of the relationship in its property sheet.

Select Start of the navigation path Model Next navigation step Relationships End of the navigation path to access the List of Relationships, and click the Add a Row tool.

Right-click the model (or a package) in the Browser, and select Start of the navigation path New Next navigation step Relationship End of the navigation path .