Re: A Normalization Question

> Let's consider a small example. We take a relation R(A,B,C) with a
> functional dependency A->B. Now consider the following instance:
>
> A B C
> ---------
> 1 2 3
> 1 2 4

What I am saying is assuming tuple1 only and no FD A->B; that 1 isa person, 2 is a color and 3 isa street all named by the same string 'brown' thus    

R2(1, 'brown')
R2(2, 'brown')
R2(3, 'brown')

which further normalizes to

R2(1, 10)
R2(2, 10)
R2(3, 10)

AND R3(10, 'b', 'r', 'o', 'w', 'n')

and can be carried out one step further to each symbol. Received on Mon Jul 12 2004 - 15:28:42 CDT