Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Normalising a two-to-one relationship

Re: Normalising a two-to-one relationship

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Fri, 5 Jan 2001 19:04:00 +0100
Message-ID: <m0o56.10110$v46.327859@news1.oke.nextra.no>

Philip Lijnzaad wrote in message ...
>
>
>David> Remember, normalization is a design principle, not an absolute
 golden
>David> rule.
>
>Brief and perhaps off topic note: some hold that normalization is part of
 the
>_analysis_, not the _design_ . I.e., normalization is something that is
>inherent in the part of real world (or 'business logic') that is being
>modeled. The analyst's task is to uncover this web of idealized
>relationships, then map it to some (usually less idealized) form.
>
>

Philip

I agree, normalization should be part of the analysis. However, the need for denormalizing tend to show up in the design phase. Hence, I find it a sound principle that one should complete a normalized model before considering any denormalizations.

--
Roy Brokvam
Received on Fri Jan 05 2001 - 12:04:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US