On Tue 18 May 2004 23:07, ilug-request at linux.ie wrote:
> On Tue, May 18, 2004 at 05:49:00PM +0100 or so it is rumoured hereabouts,
>> John Gay thought:
> > I've been trying to get my head around data normalization. The references
> > I have are:
> > MySQL Tutorial by Welling and Thomson
> > Managing & Using MySQL 2nd Edition from O'Reilly
> > Of the two, the O'Reilly book is slightly more helpful in explaining
> > normalization.
> Um, why not have the lot in a single table? Something like:
>Because I'm trying to get my head around data normalization, as I mentioned?
> ID | artist | song | cd | track |
>> You just have to generate multiple indexes if the table gets too big and
> you can do pretty much any query on that table. Note ID which is unique
> to each row.
>Yes, that's the easy way, but I'm trying to figure out how to 'normalize' data
and work with 'enterprise-type' database queries rather than the
'super-spreadsheet' acess stuff from the ECDL.
This is just my first play with MySQL and my first attempt to normalize data.
My next project is to try to create a database of Linux software that is
cross-referenced to pre-req's from the LFS/BLFS references. Once I figure out
how to list the requirements and suggests properly.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!