Re: Shall I apply normalization in the following case?

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Shall I apply normalization in the following case?
Дата
Msg-id 1265323047.4934.160.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на Shall I apply normalization in the following case?  (Yan Cheng Cheok <yccheok@yahoo.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Owen Hartnett
Дата:
Сообщение: Re: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Shall I apply normalization in the following case?