Re: Demo: Db For Dummies
Date: 16 Nov 2004 09:09:40 -0800
Message-ID: <4b45d3ad.0411160909.5a2aacf9_at_posting.google.com>
> what is the purpose of these posts?
To demo that XDb2 is for Dummies. While the XDb2 scripts appears
T_Person
name skin hair
---- -------------- ---- john ->black ->red,blue mary ->white,smooth ->red,silky,smooth
T_Skin
ID
black
white,smooth
T_SkinColor (each skin can have any number of colors)
skin color ---- ------->white,smooth ->white
->black ->black
T_SkinTexture (each skin can have any number of textures)
skin texture
------------ --------
->white,smooth ->smooth
T_Hair
ID
red,blue
red,silky,smooth
T_HairColor (each hair can have any number of colors)
hair color ------------------ -------->red,silky,smooth ->red
->red,blue ->red
->red,blue ->blue
T_HairTexture (each hair can have any number of textures)
hair texture ------------------ -----
->red,silky,smooth ->silky
->red,silky,smooth ->smooth
T_Color
name
red
blue
black
white
T_Texture
name
smooth
silky
For something more challenging try posting RM's equivalent normalized and NULL-less script/queries for the example post in thread titled "Demo: John, Mary and R2D2" or at www.xdb2.com/example/ex113.asp Received on Tue Nov 16 2004 - 18:09:40 CET