| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A Normalization Question
> There is only redundancy if one of them can be ignored
> without loss of information. You cannot.
Below is approximately how XDb1 ignores the redundant "brown" strings that were in the place of ->2, ->3 and ->4 without loss of information. The person, color and street in tuple1 are not redundant, the string that names them was.
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 nReceived on Thu Jul 08 2004 - 23:20:10 CDT
![]() |
![]() |