Problem with duplicated attributes in oracle when transforming logical model to phisical model

I create the entity relationship diagrammer, after i use the database design transformer, but some entities have duplicated the attributes because the relationships are transferable. I have two attributes with the same meaning but each one belongs to a different relation. Example

Entity1

   Keys Entity1Id
Entity2 : Relation 1 to N with Entity A transferable Primary Key

   Keys Entity1Id,Entity2Attribute
Entity3 : Relation1 with Entity1 1 to N transferable (not primary key)

          Relation2 with Entity2 1 to N transferable (not primary key)    Keys Entity3Id
   Attributes Entity1Id(Relation 1),Entity1Id(relation 2),Entity2Attribute

As we can see in entity3 we have Entity1Id duplicated one for each relation, and they are the same.

There is a way to do this in the Entity Relationship diagrammer, instead of generated an script(PL/SQL) dropping the attributes duplicated and creating the relation?

Thanks in advance and excuse my English.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 11:58:58 CET