Working with Relationships
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.
Note: 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:
- Creating and Editing Relationships
- Creating and Editing Recursive Relationships
- Creating View Relationships
- Creating Subtype Cluster Relationships
- Resolving Name Duplication in Parent and Child Entities (Unification)