Modelling entities across applications

[droutledge]

I wonder if anyone can suggest the best way to model the following in
VEA.

At an enterprise level, I have an entity called Ent1. This entity
appears in multiple databases. In Database1 Ent1 has attributes:

Att1
Att2

In Database2 Ent1 has attributes

Att1 (same as Database1)
Att3

I envisage having an ER Source Model containing Ent1 with all three
attributes. Then I would create separate VEA Projects for the physical
databases, enabling me to generate different physical schemas for the
same source entity.

Do I need to create child entities in the Source Model?

Many thanks

Dave

 

[Chang Oh]

One way to do it is to have the ER source model for Ent1(Att1, Att2) and
create project model for vairous databases. Then, you could build the
database model and edit it directly to suit the needs of each database.

Chang Oh
Visual Studio Team System