The following script models members of a baseball team. The final
data, which is normalized to atomic symbols, can be seen in tables and
trees at www.xdb2.com/Example/Ex102.asp

create *address cls thing.
create *street cls thing.
create *city cls thing.
create *state cls thing.
create *zip cls thing.

create *.
create * cls address.
create * street "123 main st".
create * city houston.
create * state texas.
create * zip 73038.

create *.
create * cls address.
create * street "456 walnut ave".
create * city dallas.
create * state texas.
create * zip 70223.

create *.
create * cls address.
create * street "789 pecan dr".
create * city "el paso".
create * state texas.
create * zip 75050.

create *.
create * cls address.
create * street "213 hemlock ct".
create * city austin.
create * state texas.
create * zip 77979.

create *.
create * cls address.
create * street "617 murdock rd".
create * city lubbock.
create * state texas.
create * zip 79212.

create *.
create * cls address.
create * street "212 kirkwood st".
create * city amarillo.
create * state texas.
create * zip 78124.

create *.
create * cls address.
create * street "418 dove ln".
create * city austin.
create * state texas.
create * zip 77979.

create *.
create * cls address.
create * street "912 blackwood rd".
create * city dallas.
create * state texas.
create * zip 70223.

create *.
create * cls address.
create * street "690 birchwood ct".
create * city houston.
create * state texas.
create * zip 73038.


create *phone cls thing.
create *fax cls thing.
create *email cls thing.

create *position cls thing.
create *player# cls thing.
create *'bat avg' cls thing.
create *birthdate cls thing.

create *person cls thing.
create *manager cls thing.
create *coach cls thing.
create *player cls thing.

create *.
create * cls person.
create * name 'johnny smith'.
create * cls player.
create * position pitcher.
create * player# 34.
create * "bat avg" 0.36.
create * birthdate 7/12/89.
create * address (address)((street)'123 main st').
create * phone 234-4554.
create * email johnny (AT) disney (DOT) com.

create *.
create * cls person.
create * name 'john smith'.
create * cls manager.
create * address (address)((street)'123 main st').
create * phone 234-4554.
create * phone 387-2222.
create * fax 333-4444.
create * email john (AT) ibm (DOT) com.

create *.
create * cls person.
create * name 'richard davis'.
create * cls coach.
create * address (address)((street)'456 walnut ave').
create * phone 876-3767.
create * fax 666-7777.
create * email rdavis (AT) gm (DOT) com.

create *.
create * cls person.
create * name 'ricky davis'.
create * cls player.
create * position catcher.
create * player# 15.
create * "bat avg" 0.23.
create * birthdate 3/26/88.
create * address (address)((street)'456 walnut ave').
create * phone 876-3767.
create * email ricky (AT) disney (DOT) com.

create *.
create * cls person.
create * name 'jimmy lee'.
create * cls player.
create * position "first base".
create * player# 63.
create * "bat avg" 0.15.
create * birthdate 8/14/87.
create * address (address)((street)'789 pecan dr').
create * phone 867-3793.

create *.
create * cls person.
create * name 'timmy locke'.
create * cls player.
create * position "second base".
create * player# 76.
create * "bat avg" 0.32.
create * birthdate 5/23/88.
create * address (address)((street)'213 hemlock ct').
create * phone 808-3387.
create * email timmy (AT) disney (DOT) com.

create *.
create * cls person.
create * name 'jenny clark'.
create * cls player.
create * position "third base".
create * player# 88.
create * "bat avg" 0.34.
create * birthdate 1/19/88.
create * address (address)((street)'617 murdock rd').
create * phone 867-9873.

create *.
create * cls person.
create * name 'jackie berg'.
create * cls player.
create * position "short stop".
create * player# 12.
create * "bat avg" 0.26.
create * birthdate 3/27/89.
create * address (address)((street)'212 kirkwood st').

create *.
create * cls person.
create * name 'billy ledman'.
create * cls player.
create * position "left field".
create * player# 47.
create * "bat avg" 0.17.
create * birthdate 9/12/88.
create * address (address)((street)'418 dove ln').
create * phone 280-3998.
create * email billy (AT) disney (DOT) com.

create *.
create * cls person.
create * name 'bobby brown'.
create * cls player.
create * position "right field".
create * player# 54.
create * "bat avg" 0.29.
create * birthdate 4/15/87.
create * address (address)((street)'912 blackwood rd').

create *.
create * cls person.
create * name 'suzie harper'.
create * cls player.
create * position "center field".
create * player# 95.
create * "bat avg" 0.30.
create * birthdate 7/22/88.
create * address (address)((street)'690 birchwood ct').
create * phone 880-3796.
create * email "suzie (AT) barbie (DOT) com".

create *group cls relator.
create * relType kr.
create *member cls relator.
create * relType cr.
create group opposite member.

create *team cls thing.

create *astros cls team.
create astros member "johnny smith".
create astros member "ricky davis".
create astros member "jimmy lee".
create astros member "timmy locke".
create astros member "billy ledman".
create astros member "bobby brown".

create *rangers cls team.
create rangers member "johnny smith".
create rangers member "jenny clark".
create rangers member "jackie berg".
create rangers member "suzie harper".

neo55592 (AT) hotmail (DOT) com (Neo) wrote:

YA Return of the $1000 Man.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

"Neo" <neo55592 (AT) hotmail (DOT) com> skrev i en meddelelse
news:4b45d3ad.0408261638.4f15c20e (AT) posting (DOT) google.com...
Please define "normalized".

Please see thread titled "A Normalization Question" in comp.databases.theory

"Ja Lar" <jalar (AT) nomail (DOT) com> wrote

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO! NOT AGAIN!!!!!!!!!!!!!!!!!!!!

"Alan" <not.me (AT) uhuh (DOT) rcn.com> wrote


<snip>

Are you the guy who stole "The Scream" ???

- Tony

tonyisyourpal (AT) netscape (DOT) net (Tony Douglas) wrote:

"No, he's already got one, you see." -- Monty Python

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

"Tony Douglas" <tonyisyourpal (AT) netscape (DOT) net> wrote

No, that's a print in my trunk.