Relation Between Normalizations say we have a fixed table T. Is there a unique normalized version of T,
i.e., does the/a correct normalization, say up to 3NF produce a unique table up to
some equivalence? Basically, I am trying to find out how many different correct ways of normalizing a table there are.
Thanks.
There are often more then one ways to normalize a relation. An example:

Relation R (ABCD) with functional dependencies:

A -&gt; BCD
B -&gt; CD
C -&gt; BD


Can be normalized to 3NF either:

R1 (AB)     A -&gt; B

R2 (BCD)    B -&gt; CD
            C -&gt; BD


or:

R1 (AC)     A -&gt; C

R2 (BCD)    B -&gt; CD
            C -&gt; BD


or:

R1 (AB)     A -&gt; B

R2 (BC)     B -&gt; C
            C -&gt; B

R3 (BD)     B -&gt; D


or: lots of other ways ...