I am trying to create a self-reference relationship in the ER diagrammer.
The table has ID and ParentID columns plus some other columns.
ParentID column should point to the ID column on the same table.
It looks like ER diagrammer doesn’t support such feature yet.
Please advise.
You can’t create a self reference in ER and already add the attribute parent_ID as well
You have to delete child attribute (parent_ID) and create the relationship.
you have to set min and max cardinality many to one or many to zero depend if the child attribute is mandatory or not.
in this case you can create the self-reference
and when you will generate the RS (relation schema) a column or more (depend from how many primary keys are on your table)will be added and it will be related with corresponding column.