Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 27 Jul 2004 15:25:44 -0700
Message-ID: <4b45d3ad.0407271425.35cf885c@posting.google.com>

> I looked at your example and I have only seen three pictures that means
> nothing. I have not seen the script you used to create the database.

Below is the actual script to create a db (with only one string 'brown') that represents a person named brown who lives on brown street, drives a brown car, has brown hair, wears a brown suit, and has one brown and one blue eye. (if someone would like to suggest a more appropriate syntax, I am all ears).

create *live cls relator.  // '*x' => create new thing, name it 'x'
create *drive cls relator.
create *wear cls relator.

create *color cls thing.

create *brown cls color.
create *blue cls color.

create *street cls thing.
create *brown cls street.

create *car cls thing.
create *car1 cls car.
create car1 color brown.

create *hair cls thing.
create *hair1 cls hair.
create hair1 color brown.

create *suit cls thing.
create *suit1 cls suit.
create suit1 color brown.

create *eye cls thing.
create *eye1 cls eye.
create eye1 color brown.
create *eye2 cls eye.
create eye2 color blue.

create *person cls thing.

create *.                // Create new thing
create * cls person.     // Single * refers to last new thing
create * name 'brown'.
create * live (street)brown.
create * drive car1.
create * part hair1.
create * wear suit1.

create * part eye1.
create * part eye2.

For more info, see www.xdb2.com/Example/ThingsNamedBrown.asp Received on Tue Jul 27 2004 - 17:25:44 CDT