[ILUG] Comments from DBA's requested.

[John Gay]

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.

<SNIP>

> 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.

Cheers,

	John Gay