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: foundations of relational theory?

Re: foundations of relational theory?

From: Mike Preece <michael_at_preece.net>
Date: 23 Oct 2003 02:38:52 -0700
Message-ID: <1b0b566c.0310230138.5852c09a@posting.google.com>


byrmol <member27348_at_dbforums.com> wrote in message news:<3513894.1066887200_at_dbforums.com>...
> >>Data integrity is simplified, normalisation is greatly simplified and
>
> >>there's no need to optimise anything.
>
>
>
> How can you normalise a non-1NF compliant database? I thought by
> definition that was impossible...

It doesn't *always* make sense to store everything in the same item. It's often best mix and match. If you want to, you can go the whole hog and normalise everything - not use multivalues at all - although if you go to that extreme you seldom end up with a silk purse. Received on Thu Oct 23 2003 - 04:38:52 CDT

Original text of this message

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