Re: Theory adrift: creative use of databases

On Wed, 18 Feb 2015 15:34:44 +0100, Nicola <nvitacolonna_at_gmail.com> wrote:

>May I start a lighthearted thread? I'm sure you have funny accounts (or
>sad, depending on your sense of humor or your current mood) of "creative
>databases" to share!
>
>From a real system:
>
>create table Agent (id int primary key, name varchar(50) not null);
>
>Instance (name is made up):
>
>id name
>--------
>123 Phyllis Sophical
>...
>345 Phyllis Sophical

[snip]

>- Oh well, let's leave those '(null)'s aside for a moment: what does it
>mean that there are at least two Phyllis Sophical?
>
>- Uhm... I don't know. Possibly, they are two different people with the
>same name: you should check in the Address table whether there are two
>different addresses associated with id's 123 and 345, respectively...

     Or two different people with the same name and address: Mom and daughter have the same name and live together. This causes confusion with mail sometimes, but about that, they are philosophical.

Sincerely,

Gene Wirchenko Received on Fri Feb 20 2015 - 18:34:27 CET