Re: Entity vs. Table
Date: Mon, 14 Jun 2004 17:19:31 GMT
On Mon, 14 Jun 2004 11:15:22 -0400, "Alan" <alan_at_erols.com> wrote:
>Those are your words, not mine. There should be no redundancy in a properly
>implemeted 3NF design
All the books I readed say the contrary.
> And wrong. If it was true, the ERD would
>have been scrapped years ago.
ERD was scrapped decades ago by many people, but many poor practices survive for a very long time.
>> For instance this very simple rule: the stock of an article is the
>> initial stock plus the inputs minus the outputs.
>That is an aggregation and fits on an ERD with no problem.
> The underlying
>calculation does not belong on an ERD- it is an implementation detail.
My example is a logical integrity rule. The implementation is irrelevant in this context. We are talking about the logical model.
That rule is very easy to declare with a relational language.
Another example: No supplier with status less than 20 supplies any
part in a product with quality extra.
>> with a very limited sketch.
>So can I, and I often do, but I've also been burnt by not creating an ERD.
>Relationships among data that you may not otherwise anticipate often reveal
>themselves in an ERD, especially with specialization/generalization.
Relationships among data are database relations also known as tables.
The relational model is the best way to represent relationships among data, and it does not have the problems of ERD, like the arbitrary and artificial distinction among entities and relationships (there are only relationships), and it has a lot greater expresive power.
Alfredo Received on Mon Jun 14 2004 - 19:19:31 CEST