Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Notes fields
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