managing lots of tables in DDL

[Juan Pablo]

hello.

i have a DDL with lost of tables. If i need print that, i have to use 6 papers. I need some suggestions about a better  way to organize (grouping or whatever) regarding relations between tables.

ie. If i have two tables which have a relation between them, then i could separate each one in a diferent diagram, and in a third one, add  both diagrams as a reference.
the problem here is that diagram have lost relation.

any suggestions?

thanks in advance

[Paolo F Cantoni]

Hi Juan Pablo,

You can create a diagram - place one table on it and then select the table and using <context menu>|Add...>Related elements to get EA to add the related tables.

Does that suit your needs?

HTH,
Paolo

[Juan Pablo]

hi Paolo, thanks for the fast reply.

My problem is that i have lots of tables, so i want to make an abstraction. for example, in place of show a caotic set of tables, order them in a kind of package.


Pack1 = 20 tables
pack2 = 30 tables
pack3 = 30 tables.



but in pack1 there is a table that have a relation whit a table in pack2, but it's not show in that way.

i think  a line from pack1 to pack2 should indicate relations.

[Paolo F Cantoni]

Hi Juan Pablo,

There may be something I'm not getting...  Where did you get the set of table in EA from?  Reverse Engineering a database using EA or some other mechanism?

If using EA then if Table1 in Package1 has a FK Constraint with Table2 in Package2 then there will be FK Constraint visible between them if both tables are put on the same diagram.  Is this not what you are seeing?

I can understand your desire to abstract things a bit, but first we need to establish where the problem actually is.

HTH,
Paolo