Re: A Normalization Question

• Post for FREE via your newsreader at post.usenet.com ****

"Neo" <neo55592_at_hotmail.com> wrote in message news:4b45d3ad.0407221614.657d484c_at_posting.google.com...
> > You should give an example with multiple occurences of quantities.
> > Like "this box is 1 cm thick, 1 kg heavy and cost only 1$"

> The example at www.xdb2.com/Example/BoxProperties.asp represents a box
> whose thickness is 1 cm, weighs 1 kg and costs 1 $. Each property
> references the same quantity 1 (ID 2356). The quantity 1 is named by
> the symbol 1 (ID 1231). In the third image, parentheses indicate the
> number of references to orginal symbol or string.

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. I wonder what actions are necessary to add 100 boxes to the database. I wonder if you can do math with those quantities. For example could one ask for the total weight of all boxes ? Or for total cost ?
I wonder how the Xdb solution compare with an SQL solution.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=