Re: Shall I apply normalization in the following case?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Jorge Godoy <jgodoy(at)gmail(dot)com>
Cc: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Shall I apply normalization in the following case?
Date: 2010-02-04 22:40:23
Message-ID: 1265323223.4934.162.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 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Kempter 2010-02-04 23:19:19 playr (or similar tool)?
Previous Message Jeff Davis 2010-02-04 22:37:27 Re: Shall I apply normalization in the following case?