Setting the Relationship Notation
Go Up to Customizing the Data Model
ER/Studio Data Architect can represent the relationships in your data models in IDEF1X notation or in one of three varieties of IE notation.
- IDEF1X: Data modeling technique used by many branches of the United States Federal Government.
- IE (James Martin): Information Engineering (IE) as developed by Martin and later revised by Finkelstein.
- IE (Crow's Feet): Uses IE notation and represents relationships with connecting lines between entities, and symbols at the ends of those lines to represent the cardinality of the relationship. This is the notation used in Oracle texts and in other applications such as Visio. Foreign keys are displayed in entity boxes.
- Filtered IE (Hide Foreign Keys): Uses standard IE notation, but foreign keys are not displayed in entity boxes.
IDEF1X versus IE Relationship Notation
IDEF1X is based on the relational data model designed by E. F. Codd and on the entity-relationship model designed by Peter Chen, but IDEF1X models differ from the models on which IDEF1X is based. A model created using Peter Chen's or E.F.Codd's designs will appear different compared to a model created using ER/Studio Data Architect and the IDEF1X notation, and vice versa.
IDEF1X makes it easier to visualize primary and foreign keys. IDEF1X also offers the power (and danger) of using identifying relationships to cascade primary keys through a chain of entities.
- IDEF1X Notation
- IE (James Martin) Notation
- IE (Crow's Feet) Notation
- Filtered ID (Hide Foreign Keys) Notation
Changing the Relationship Notation for all Diagram Models
- Choose View > Diagram and Object Display Options.
- Click the Relationship tab.
- In Display Preferences, choose the desired notation and then click OK.
Changing the Relationship Notation for a Selected Model
- Right-click the target model and then select Model Options.
- In the Notation area, choose the desired notation and then click OK.
Note: When changing the Relationship Notation on a model, you will not see a change in the way the model is structured, only the connectors will change. The difference in the notations is that for optional relationships, IE (Crows Feet ) uses dashed relationship lines, whereas the Martin notation still uses solid lines.