Re: Shall I apply normalization in the following case?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Shall I apply normalization in the following case?
Date: 2010-02-04 22:37:27
Message-ID: 1265323047.4934.160.camel@monkey-cat.sm.truviso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2010-02-03 at 17:20 -0800, Yan Cheng Cheok wrote:
> For example, for the following table,
>
>
> measurement (without normalization)
> ===========
> id | value | measurement_unit | measurement_type
> ------------------------------------------------
> 1 0.23 mm width
> 2 0.38 mm width
> 2 0.72 mm width

That looks normalized to me. Can you describe the redundancy that I
don't see? Do units of "mm" always imply "width" (I would think they
might also be used for "length").

Regards,
Jeff Davis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2010-02-04 22:40:23 Re: Shall I apply normalization in the following case?
Previous Message Owen Hartnett 2010-02-04 21:02:47 Re: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487