Database Design

[alindan]

I am trying to use EA for some basic database design tasks.
Since EA does not seem to have support for domain, I wanted to try to use inheritance to simulate that. The idea was to have a table T1 that has a number of attributes and mark it as abstract. A table T2 was created and inherited the T1. The diagram correctly shows the inherited attributes. When I run the DDL I do not get the inherited attributes created. Am I doing something wrong?

Alin

PS The current problem occurs in the trial of EA 6.1 (I am evaluating it for a possible upgrade).

[«Midnight»]

From the information you provide I cannot be sure whether you're doing something wrong, not doing something required, or encountering limits of EA. [That's not to say you have not provided enought info, just that my limitations are getting in the way.]

However, there's been considerable discussion about modelling database domains (i.e. user-defined types, etc.) in this forum in the last couple of months. If I remember correctly a couple of well-thought-out approaches have been described in detail.

You should search the forum for these. Try "domain" as a starting point, and continue until you hit the correct threads. The forum search engine sometimes seems to do strange things, so try variations of any searches the don't produce results.

Good hunting,
Davide