-
Title
Supertype-Subtype Relationship between two Parent supertype Entities pointing to the same the sub -
Description
Supertype-Subtype Relationship between two Parent supertype Entities pointing to the same the subtype Entity -
Resolution
Description:
Supertype Relationships between two supertype Entities connecting to the same subtype Entity should not be allowed, but erwin allows that. How can I prevent an Entity from being a subtype to more than one supertype Entity?
Solution:
erwin Data Modeler DM now gives you better control over the creation of a supertype-subtype Relationship between two different subtype entities belonging to same or different supertype group. An option to enable/disable such relationships has been provided on the Model Editor.
If the check box ‘Enforce Relationship Rule’ is enabled (selected), you will not be able to add a second supertype-subtype Relationship from another supertype Entity to an existing subtype Entity. It will now give you the following error which will pop up when creating a supertype-subtype Relationship between the Entities ‘Supertype2’ and ‘Subtype2’:
With erwin DM 2018 R1, it is now enabled by default and a supertype-subtype Relationship between two different subtype Entities belonging to same or different supertype group is not allowed. However, if you have a model created in an older version of erwin DM with such a supertype-subtype relationship, the relationship is preserved even when you open the model into the newer version of erwin DM.
However, if you want to keep modeling the older way, you can disable (deselect) the check box in Model Properties and can draw a supertype-subtype Relationship as in the screen shot below.
Please note that it is now possible to have both kinds of rules in the same model as checking or un-checking enables and disables for any action taken after the box is checked or unchecked and does not impact the existing Relationships.
