Re: Database design

From: Mark Johnson <102334.12_at_compuserve.com>
Date: Tue, 21 Feb 2006 16:04:20 -0800
Message-ID: <nk9nv19uai54g9hsnsm15kq9pbdso67u9c_at_4ax.com>


mAsterdam <mAsterdam_at_vrijdag.org> wrote:

>> A relation is NOT a table
>> An attribute is NOT a column
>> A row is simply NOT a tuple, to the latter of course, I'd agree.

>Not to the first two?

Only because:

>> A relation is a set, which need not be written as a table, to be sure.
>> But in a world of constraints, situation and conditions - in a world a
>> databases and a ng devoted to an aspect of same - I also agree it
>> would be reasonable to speak of relations as tables, attributes as
>> columns, and rows as not . . . entities.

>>>Yet, neither tables nor relations map to entity types.

>> The single row is then called - what?

>In the context of tables, just that: a row.
>In the context of relations: a tuple.

But, okay

>>>One relation may have attributese from several entitiy types,

>> Then an entity type is seen as some unique attribute domain?

>No. Why?

And because a single table may have columns, each of which have different - types? What your definition of - entity? and "entity type"?

>>>and one entity may have data spread across several relations

>> Then an entity type is not some unique attribute domain?

>Indeed not. Why should it?

It appears definitional. Received on Wed Feb 22 2006 - 01:04:20 CET

Original text of this message