Re: Understanding relational database setup/construction
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cal -- ...and then Cal Evans said... % % TjL, % % To start with: Thanks for the titles! ... % Work your way through both books in a couple of months and then spend every % waking hour organizing data into tables for a couple of years and you'll be This is what scares me. I want to "get it" *NOW*! :-) % there. (You know you have arrived when start assigning family members % primary keys beause, well everybody knows that SSN's aren't unique!) ;) Or required :-) % % % HTH, % =C= HAND & sql query :-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) iD8DBQE9Fa1uGb7uCXufRwARAgHJAJ9xBmdWFTtm4XL1ENxq/vnoMe1fvgCeKBf8 eTizD4btLRgz+zDRC2hJBQ0= =fX/z -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
Re: Understanding relational database setup/construction
On 22/6/02 at 17:05, [EMAIL PROTECTED] (Timothy J. Luoma) wrote: > I've looked through Google and the MySQL website without luck. > > I'm looking to find a place which discusses the theory of how one > should > create a database, how to organize the information, etc. > > There's got to be a good site out there, but I'm obviously plugging in > the > wrong search terms or something. Try the second edition of O'Reilly books' "Managing and Using MySQL" ISBN:0596002114. That'll get you started. Regards, Phil. - 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
Re: Understanding relational database setup/construction
I haven't tried it, yet, but this looks like an interesting alternative for a "try-before-you-buy" method of selecting books: http://safari.informit.com/mainhom.asp?home You can subscribe to a list of books monthly and have full access to them online. If you take a look at this, I would recommend the New Riders title "MySQL" by Paul DuBois. There's just enough in there to explain how an RDBMS works and it's MySQL specific, so you can use it right away. If you want to get deeper into theory, you can move on from there -- but the basic concepts are pretty simple and can be applied to any relational db system. --jeff - Original Message - From: "Timothy J. Luoma" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 2:05 PM Subject: Understanding relational database setup/construction > > I've looked through Google and the MySQL website without luck. > > I'm looking to find a place which discusses the theory of how one should > create a database, how to organize the information, etc. > > There's got to be a good site out there, but I'm obviously plugging in the > wrong search terms or something. > > Thanks > TjL > > > > > - > 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 > - 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
RE: Understanding relational database setup/construction
TjL, To start with: http://www.amazon.com/exec/obidos/ASIN/0764507370/qid=1024783081/sr=8-1/ref= sr_8_1/104-4398960-1440757 If the title bothers you, take a Sharipe, cross out "Dummies" and write "Managers", no one will ever know. :) This book gives an excellent primer in theory and normalization and some helpful hints. WARNING: The version I read (lo, these many years ago) was very MS-SQL centric. Once you have mastered these concept it presents try: http://www.amazon.com/exec/obidos/ASIN/1558605762/qid=1024783163/sr=1-1/ref= sr_1_1/104-4398960-1440757 This one has a bit more meat on it but boy is it good. Work your way through both books in a couple of months and then spend every waking hour organizing data into tables for a couple of years and you'll be there. (You know you have arrived when start assigning family members primary keys beause, well everybody knows that SSN's aren't unique!) ;) HTH, =C= -Original Message- From: Timothy J. Luoma [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 4:06 PM To: MySQL List Subject: Understanding relational database setup/construction I've looked through Google and the MySQL website without luck. I'm looking to find a place which discusses the theory of how one should create a database, how to organize the information, etc. There's got to be a good site out there, but I'm obviously plugging in the wrong search terms or something. Thanks TjL - 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 - 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
Re: Understanding relational database setup/construction
For theory and history, I found the manual to be an excellent place to start... http://www.mysql.com/manual.php and have a walk through the tutorial starting with: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html At 05:05 PM Saturday, 6/22/2002, Timothy J. Luoma wrote -=> >I've looked through Google and the MySQL website without luck. > >I'm looking to find a place which discusses the theory of how one should >create a database, how to organize the information, etc. > >There's got to be a good site out there, but I'm obviously plugging in the >wrong search terms or something. Ed Kasky Los Angeles, CA . . . . . . . . A closed mind is a beautiful thing to lose. - 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
RE: Understanding relational database setup/construction
Hi Not sure about sites but try searching for 'database normalisation tutorial' I found http://www.codelearn.com/rdb/rdbd_nt1_s.html which looks to be a reasonable start. Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- > -Original Message- > From: Timothy J. Luoma [mailto:[EMAIL PROTECTED]] > Sent: 22 June 2002 22:06 > To: MySQL List > Subject: Understanding relational database setup/construction > > > > I've looked through Google and the MySQL website without luck. > > I'm looking to find a place which discusses the theory of how one should > create a database, how to organize the information, etc. > > There's got to be a good site out there, but I'm obviously plugging in the > wrong search terms or something. > > Thanks > TjL > > > > > - > 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 > - 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
