On Wed, Jul 09, 2003 at 04:20:52AM -0700, David Thompson wrote: > > Looking for a book to help me develop a philosophy for building > databases (particularly on MySQL). And then taking them from concept to > construction. > > Something like.... Start by asking which queries you will be performing, > then define all data needed for each of those queries, then progress to > normalize this data, etc.
I too have a favourite. :-) Relational Database Design Clearly Explained, by Jan L. Harrington. ISBN 0-12-326425-1 (Academic Press). It goes through the basics (normalized forms, ER diagrams, CASE tools, Codd's Rules, yadda), explains *why* you'd use them, and (refreshingly) doesn't assume you'll take the author's word as gospel. It has examples which it builds on throughout the book, and seems to advocate simplicity of design over showing off gadgetry. I recommend it. -- Paul Chvostek <[EMAIL PROTECTED]> Operations / Abuse / Whatever it.canada, hosting and development http://www.it.ca/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
