Re: Designing Default Value
Date: Mon, 20 Oct 2003 16:08:13 -0400
Message-ID: <bn1fb0$sibaj$1_at_ID-114862.news.uni-berlin.de>
Values do not belong in an ERD. They belong in the data dictionary document
that is submitted with the rest of your assignment. What you are talking
about *is* an implementation detail, not a design detail. Depending on the
tool you are using, you may be able to build the list and select the default
automatically, but they still don't belong on the ERD.
An ERD shows abstract business relationships among the data- not
implementaion level items.
"Michael Fuchs" <fuze_at_REMOVE.THIS.STUFFgmx.net> wrote in message
news:bn17k5$mjl$1_at_bird.wu-wien.ac.at...
> to *design* a default value? (in an ER diagram)
>
> I do NOT want to know about setting default values for CREATE TABLE
> statements when adding data, the question is how to design this
> information so that it can be read into my application.
>
> example table:
>
> ----------
> |Currency| now i would like to have USD
> |--------| as the default value,
> | EUR | the application should then be
> | USD | able to preselect this value
> | CHF | to make usage easier;
> | CAD |
> ----------
>
> Thank you very much everybody, your help is enormously appreciated!
>
> Michael
>
Received on Mon Oct 20 2003 - 22:08:13 CEST