Logical Model - Relation Use Existing Attribute Rather Than Create New Attribute

littlecat

When using logical model if I already FK attribute in entity, can I use this as FK attribute when create relation to parent entity rather than Data Modeler creating new attribute. For example I already have dept_no in employee entity and create 1:M relation from dept to employee, this will create additional attribute of dept_no1 in employee table. I wish to use existing dept_no attribute to employee entity. Or is this philosophy about where FK attributes should only be created by creating relation and entities should only contain attribute about the entity?

I know can achieve similar with relational model where get to select pre-existing column and new generated column will be removed.

Max Allen Smith

As far as I know you cannot do this in the logical model, you need to delete/rename your original column, then create/rename your new column generated by the relation with the foreign key.