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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Notes fields

Re: Notes fields

From: GWood <sorry_at_nothere.com>
Date: Thu, 21 Apr 2005 22:46:52 GMT
Message-ID: <w3W9e.33$jt6.125@news-west.eli.net>


OK, I'll play sacrificial lamb. I suspect you're right, Daniel, but don't know why. How would a single notes table be a bad solution for this need? I'm assuming the table would have attributes to differentiate note types, allow for multiples, etc.
Regards

Gary

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1114010281.340565_at_yasure...
> Malcolm Dew-Jones wrote:
>
> > Ed Prochak (ed.prochak_at_magicinterface.com) wrote:
> > : what does your lack of disc space have to do with this NOTES table?
> > : (I suspect nothing).
> >
> > : If looking to Normalize the tables (you could creat views of the
> > : denormalized ones later, if you are careful), then you might save some
> > : space.
> >
> > I don't see how the notes are not normal.
>
> I do.
>
> > They aren't really attributes of the tables, and each row of a table may
> > or may not have any notes associated with it.
>
> Correct but that is not the reason I have a problem with it. Rather a
> single "notes" table is the wrong solution if that is the issue.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Thu Apr 21 2005 - 17:46:52 CDT

Original text of this message

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