check out this article and try a google search for database normalization.
http://www.phpbuilder.com/columns/barry20000731.php3 when you have a better idea - try the list with your questions. These 4-5 page articles will definitely help you out. olinux --- David T-G <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, all -- > > I'm finally jumping into playing with mysql, and > talking to it with perl, > and I find that even though I did well in classes > years ago in school > I really have no idea what I'm doing :-) > > I've been working up the script to simply parse my > data (unique path > names to tracks containing items like artist, album, > and so on) and am > currently storing it in a hash just to do something > with it. I'll write > that subroutine later once I have an idea of where > I'm going -- which > I hardly do at this point! > > I think I have the idea of table relations down, but > I could probably > use some more help. > > I've read most of the tutorial at mysql.com (gonna > finish tomorrow!) and > get how to create a database and create a table and > such but don't really > see anything that will help me figure out *how* to > lay out the database. > I realize that there are doubtless as many ways to > design a particular > database as there are to do anything else, but > certainly there must be > some "best practice" theory out there, preferably on > the 'net somewhere > where I can get to it instead of only in a > bookstore. > > This particular case is storage of MP3 data for my > collection. I have > a number of parameters regarding each file and I > think I've sorted them > out into three or four tables, but don't have the > design fleshed out yet, > and certainly don't know if I might want to add more > to it later. > > One certainly has to draw a line in the sand > somewhere, so only so > much planning can be done before it's time to get > moving and implement. > Once you have a database, though, can you add to or > modify the structure, > including the relations, or are you stuck with what > you have until you > export the data somehow and import it into a new > structure? > > I could go on and on :-) about this particular > project, but I don't want > to bore folks with what are probably very basic > questions. I should go > off and do my homework first, but I need to know > where to find the > material. > > > TIA & HAND > > :-D > - -- > David T-G * It's easier to > fight for one's principles > (play) [EMAIL PROTECTED] * than to live up to > them. -- fortune cookie > (work) [EMAIL PROTECTED] > http://www.justpickone.org/davidtg/ Shpx gur > Pbzzhavpngvbaf Qrprapl Npg! > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.7 (GNU/Linux) > > iD8DBQE9B5VbGb7uCXufRwARAmeJAKCW6KxmEuGfFllJlXnuOk5SI0maZACfXD7+ > IEDdSPyv5RnKBiq3Gjxgf/U= > =//Fr > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
