Working with Relationships

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Developing the Logical Model

Relationships help enforce business rules and assertions in a data model. Relationships determine how data are related between two entities and/or views. Notepad blue icon 2.pngNote: The dashed / dotted lines indicating those of a relationship with a View, differs from those indicating a non-identifying relationship.

Relationships are implemented as foreign keys in the physical model. The properties of these foreign keys dictate how referential integrity is enforced between tables through constraints and triggers.

In addition to standard relationships ER/Studio Data Architect lets you create recursive relationships, those where an object is related to itself; duplicate relationships, where multiple relationships relate to the same objects; view relationships that relate entities or tables to views, and subtype clusters that associate multiple homogenous entities (subtypes) to a supertype entity.

For more information on relationships, see the following topics:

See Also