Re: A Normalization Question

> You have to show that in the tuple ("brown", "brown", "brown") the
> string "brown" each time represents the same fact.
 

A clearification. While the 1st, 2nd and 3rd "brown" in the above tuple do represent different things (ie fact), the name of each of those things is the same (ie string "brown") and it is the name of those things that can be normalized.

Below is approximately how XDb1 normalizes the above tuple.

Thing Person Color Street
1 ->2 ->3 ->4

Person Name
2 ->5

Color Name
3 ->5

Street Name
4 ->5

Name Sym1 Sym2 Sym3 Sym4 Sym5 ....
5 ->6, ->7, ->8, ->9, ->10

Symbol

6      b
7      r
8      o
9      w
10     n

For more info, see www.xdb1.com/GUI/Labels.asp Received on Wed Jul 07 2004 - 19:29:23 CEST