Data Modeling Notations

Enterprise Architect supports numerous settings related to data modeling that can influence how database objects are represented on diagrams. These settings, and how they can affect the representation of database objects, are described here.

Settings

Setting	Detail	See also
Stereotype Icons	Access: 'Design > Diagram > Edit > Properties > Elements : Use Stereotype Icons' Default Value: True Enterprise Architect provides a diagram-level setting for the display of stereotyped objects. When the checkbox is selected, database objects on the diagram are displayed with an icon representing their stereotype instead of the stereotype name.	Stereotype Visibility
Show Data Model Owner	Access: 'Design > Diagram > Edit > Properties > Elements : Show Data Model Owner' Default Value: True The system provides a diagram-level setting for the display of Owners. When the checkbox is selected, database objects on the current diagram will be displayed with their full name '{Owner.}ObjectName'.	Define Element Characteristics
Show Column Details	Access: 'Design > Diagram > Edit > Properties > Features : Show Attribute Detail' Default Value: Name Only The system provides a diagram-level setting for the display of Table column names and datatypes. The available options are: 'Name Only' or 'Name and Type'.	Features Tab
Show Involved Column Details	Access: 'Design > Diagram > Edit > Properties > Features \| Show Parameter Detail' Default Value: Type Only The system provides a diagram-level setting for the display of columns involved in a Table constraint. The available options are: 'None', 'Type Only', 'Name Only' and 'Full Details'. In these examples, the Primary Key (PK) constraint 'PK_account' involves the column 'accountID'.	Features Tab
Show Column Stereotype	Access: Start > View > Preferences > Objects: Show <<column>> stereotype Default Value: True Enterprise Architect provides a global-level setting that controls whether or not the <<column>> stereotype is displayed above each Table's columns. You can therefore hide the stereotype if you prefer, considering that attributes with a stereotype of <<column>> are the only valid option for Tables.	Object Display Options
Connector Notation	Access: 'Design > Diagram > Edit > Properties > Connectors : Connector Notation' Default Value: UML 2.1 Enterprise Architect supports three diagram notations for data modeling: UML 2.1 - the standard UML 2.1 notation for connectors Information Engineering - the Information Engineering (IE) connection style IDEF1X - the Integrated Definition Methods IDEF1X connection style (These are the same three connectors using the different notations.) The default notation for the Data Modeling diagram is 'Information Engineering', whilst the default notation for models created from Database Engineering Patterns is 'IDEF1X'.	Connectors Tab Entity Relationship Diagrams (ERDs)