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.
>
> They aren't really attributes of the tables, and each row of a table may
> or may not have any notes associated with it. Some tables might have more
> than one note per row (perhaps not today, but as a likely enhancement in
> the future, or already "under the table" by having multiple entries in
> each single item of free form text). Each note could have many attributes
> associated with it such as the date/format/language/editor/revision of the
> text (again, perhaps not today but as likely mods later). Furthermore,
> all the notes will share these common attributes. So why would you say
> it's not normal to have the notes in their own table?
>
> As for disk space, perhaps the thinking was that you might wish to be able
> to handle the free form text in a different area of the database,
> seperately from the rest of the data which probably has more fixed
> predictable requirements.
>
> $0.04
>
> --
>
> This space not for rent.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Apr 20 2005 - 10:20:33 CDT
