Re: dbdebunk 'Quote of Week' comment

From: x <x_at_not-exists.org>
Date: Mon, 29 Aug 2005 12:39:49 +0300
Message-ID: <deul5c$l39$1_at_domitilla.aioe.org>

"dawn" <dawnwolthuis_at_gmail.com> wrote in message news:1125079806.115887.87770_at_g47g2000cwa.googlegroups.com...

> When talking about data that serve as references to other data at the
> logical level, there is nothing in the relational model that prohibits
> or even discourages such.

Then let's :

1) introduce for every domain D a relation DR(val_id, value)
2) replace every distinct occurence of a value with occurence_id
3) introduce the relation OV(occurence_id, val_id) such as the value

referenced by occurence_id is the same with the one referenced by val_id 4) normalize the relations resulted from the transformation at 2)

:-) Received on Mon Aug 29 2005 - 11:39:49 CEST