Forum Stats

  • 3,826,663 Users
  • 2,260,687 Discussions


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

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.