I personally think Paul Dubois's book "MySQL" does a good job not only covering all aspects of MySQL installation, setup, and maintenance, but I think it also gives a very good introduction on table design right in Chapter 1 (I have the 1st "MySQL" - I see on Paul's homepage http://www.dubois.ws/people/paul/ that the 2nd edition of this book was published in January, 2003) - where there are sections titled A MySQL Tutorial * Creating the Database * Creating Tables - describes a "Historical League" project, which has a "president" table, and a "member" table, and it describes the fields of each table. - describes a "Grade Keeping" project...
Following the examples of creating the tables and then querying the tables, I think you get a pretty good feel for table design. Just my 2c. -- Hardy Merrill Red Hat, Inc. Michael Ragsdale [EMAIL PROTECTED] wrote: > > >>>Thanks again for all the good feedback. If anyone can recommend > >>>a good book that could help me out on this I would be most > >>>appreciative. I have some MySQL reference books, but nothing that > >really >>goes into database design. I am planning on taking some > >database courses at a local > > I didn't catch this whole thread, but may have something to offer. Also, I > can't seem to find the OP's email address in the header, so please forgive > the off DBI topic reply to the list.... > > It's not MySQL specific but I recommend "An Introduction to Database > Systems" by C.J. Date. I learned database design with his Fourth Edition > 16 or so years ago and thought it a most excellent database design > primer. I think the Eighth Edition is about to come out - search for it on > Amazon. > > -Mike
