Re: Entity vs. Table

On Tue, 15 Jun 2004 09:23:35 -0400, "Alan" <alan_at_erols.com> wrote:

>> The Relational Model says nothing about the physical level.
>
>I am talking about taking a completed relational model design and
>implementing it. You know, I've designed all the tables and now I'm typing
>SQL to build them in the RDBMS.

SQL mixes the logical and the physical levels, but the most part of the physical design is created by the SQL DBMS automatically.

It is perfectly valid to have redundancy in the physical tables.

>> But where is the rule?
>>
>> A double oval says that an attribute is derived but it says nothing
>> about the derivation rules.
>>
>> You are losing the business requirements.
>
>No one said that the ERD models ALL business requirements.

But you said that it can represent most of them, what is clearly false.

> For the 50th
>time, it models relationships among the data.

Only a very little part of the requirements, and it does that worse than The Relational Model.

There are not precise definitions for "entity" and "relationship". The distinction is arbitrary. The ERD is a backward step and heavily oversold.

Regards Received on Thu Jun 17 2004 - 11:32:28 CEST