Re: Shall I apply normalization in the following case? - Mailing list pgsql-general

On Wed, 2010-02-03 at 23:56 -0200, Jorge Godoy wrote:
> You can always normalize and not use an artificial key.
>
> You'd end up with:
>
>
> measurement (normalization)
> ===========
> id | value | measurement_unit_id | measurement_type_id
> ------------------------------------------------------
>         1   0.23     mm                    width
>         2   0.38     mm                    width
>         2   0.72     mm                    width

How is this different? It looks like you just added some FKs, which
don't change the normal form.

Regards,
    Jeff Davis