Redgate Data Modeler

Associations

Association are a special type of relationship. An association is a relationship between two entities, which can have additional attributes. You can implement a many-to-many relationship with attributes or a ternary relationship this way. When you join entities with an association relationship, you'll be able to set association properties which consist of its name and attributes.

Now, we're going to see how to create an example association between these two entities:

Create association

To create the association, click on the Add new association relationship button or press 8 on your keyboard.

Then, drag from one entity to another, and the association will be created between them.

Now it's plain. Let's rename it and add attributes to it. Go to the right panel

Now it looks better. This options work in the same way as for entities, so if you haven't read about them, be sure to check out this article.


Didn't find what you were looking for?