Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 27 Jul 2004 18:54:33 -0700
Message-ID: <4b45d3ad.0407271754.2a332bf0_at_posting.google.com>

> > www.xdb2.com/Example/BoxProperties.asp shows a box whose thickness is 1 cm,
> > weighs 1 kg and costs 1 $. Each property references the same quantity 1.
>
> 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 script to create the db:

create *quantity cls thing. // *x => create a new thing and name it x. create *1 cls quantity.

create *unit cls thing.
create *cm cls unit.
create *kg cls unit.
create *$ cls unit.

create *distance cls thing.
create *.                    // Create a new thing.
create * cls distance.       // ' * ' refers last new thing created by '*.'

create * quantity 1.
create * unit cm.

create *mass cls thing.
create *.
create * cls mass.
create * quantity 1.
create * unit kg.

create *money cls thing.
create *.
create * cls money.

create * quantity 1.
create * unit $.

create *thickness cls relator.
create *weight cls relator.
create *cost cls relator.

create *box cls thing.
create *box1 cls box.
create box1 thickness (distance)((quantity)1)((unit)cm). // Rel expression create box1 weight (mass)(1)(kg). // Simplified relational expression create box1 cost (money)(1)($).

If someone could suggest a clearer syntax, I am open to suggestions. Received on Wed Jul 28 2004 - 03:54:33 CEST