Re: A Normalization Question
Date: 27 Jul 2004 15:25:44 -0700
Message-ID: <4b45d3ad.0407271425.35cf885c_at_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 *street cls thing.
create *car cls thing.
create *hair cls thing.
create *suit cls thing.
create *eye cls thing.
create *person cls thing.
For more info, see www.xdb2.com/Example/ThingsNamedBrown.asp
Received on Wed Jul 28 2004 - 00:25:44 CEST
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 *brown cls street.
create *car1 cls car.
create car1 color brown.
create *hair1 cls hair.
create hair1 color brown.
create *suit1 cls suit.
create suit1 color brown.
create *eye1 cls eye.
create eye1 color brown.
create *eye2 cls eye.
create eye2 color blue.
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.