Please show RM's script to model the equivalent things without NULLs
or redundancy (I won't ask you to normalize down to symbols as it
would make RM's solution impractical). Then I can decide whether or
not to rename it Db for Dummies.

One will never know without attempting to accomplish the equivalent
with RM, that is model the equivalent things without NULLs or
redundancy (I won't ask you to normalize down to symbols as it would
make RM's solution impractical).

While the XDb2 scripts appears simple enough for dummies, it creates
the equivalent of the following RM schema (actually it further
normalizes the name column of various tables, and then normalizes the
symbols across all names). I have used "->" notation instead of ID
values to make it easier to follow:

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
---- ------
->black ->black
->white,smooth ->white

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,blue ->red
->red,blue ->blue
->red,silky,smooth ->red

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


That XDb2's simple script creates a schema similar to above can be
corroborated by looking at the same things in the tree view at
www.xdb2.com/example/ex005.asp

When one compares RM's script/queries to XDb2's, it is easy to see why
it is for Dummies, and RM is not.

Oh, please.


Dark brown. Ask the Department of Motor Vehicles.

Can we talk about databases again now?


Marshall

To demo that XDb2 is for Dummies. While the XDb2 scripts appears
simple enough for dummies, it creates the equivalent of the following
RM schema (actually it further normalizes the strings in the name
columns of various tables, and then normalizes the symbols across all
strings). I have used "->" notation instead of ID values to make it
easier to follow. Not that RM can't, but if you're unable to post RM's
equivalent (normalized/NULL-less) script/queries, then XDb2 might be
for you

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
---- ------
->black ->black
->white,smooth ->white

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,blue ->red
->red,blue ->blue
->red,silky,smooth ->red

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
script/queries for the example post in thread titled "Demo: John, Mary
and R2D2" or at www.xdb2.com/example/ex113.asp

While the XDb2 scripts appears simple enough for dummies, it creates
the equivalent of the following RM schema (actually it further
normalizes the strings in the name columns of various tables, and then
normalizes the symbols across all strings). I have used "->" notation
instead of ID values to make it easier to follow. Not that RM can't,
but if you're unable to post RM's equivalent (normalized/NULL-less)
script/queries, then IDb may be appropriate.

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
---- ------
->black ->black
->white,smooth ->white

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,blue ->red
->red,blue ->blue
->red,silky,smooth ->red

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
script/queries for the example post in thread titled "Demo: John, Mary
and R2D2" (or at www.xdb2.com/example/ex113.asp)

To demo that XDb2 is for Dummies. While the XDb2 scripts appears
simple enough for dummies, it creates the equivalent of the following
RM schema (actually it further normalizes the strings in the name
columns of various tables, and then normalizes the symbols across all
strings). I have used "->" notation instead of ID values to make it
easier to follow. Not that RM can't, but your original solution fell
quite short. Could you post RM's equivalent (normalized/NULL-less)
script/queries?

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
---- ------
->black ->black
->white,smooth ->white

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,blue ->red
->red,blue ->blue
->red,silky,smooth ->red

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

"Neo" <neo55592 (AT) hotmail (DOT) com> wrote

Can those of us who are not dummies have a break???