Ian wrote:
These additional mappings of an entity sound like views. Couldn't you have both?
i.e. Employee references Order in OrderManagement as well as there being a view of Employee in HRM.
Doesn't have to be. Through fk fields, you can persist employee in both. Having it 'automatic', makes things complicated because employee is not in OrderManagement. So the reference from Order to Employee... what should be done with that? Placing employee in OrderManagement? Or ignore the relationship? If you say, 'place it in OrderManagement', what to do with Employee m:1 Department (which is in HRM) ?
So by explicitly defining the entity multiple times, you are in control what to do. It's easy to do though, simply reverse engineer the entity again into the group you want the duplicate in.