Re: A Normalization Question

> > What in a db is not a fact?
>
> Nothing, of course.

That is correct, everything in a db is a fact. The string 'brown' is a fact. Representing it three times is redundant. Below is approximately how XDb2 normalizes the three strings and updating it from 'brown' to 'nworb' or 'brownt' does not create an update anomaly.

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

Person Name
2 ->5

Color Name
3 ->5

Street Name
4 ->5

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

Symbol

6      b
7      r
8      o
9      w
10     n