----- Original Message -----
From: "Maurice van Peursem" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
10.3, which was easy. I've installed Perl support for MySQL, which was
suprisingly difficult. I've installed CocoaMySQL
(http://cocoamysql.sourceforge.net/) to create, inspect and backup
databases. And now I'm building my first database, and that is not as easy
as I had hoped. I know that use of the 'JOIN' keyword can save me pages of
Perl code, but how it works exactly is not yet clear to me.
Therefore I'm looking for a book, or maybe other documentation (on the
web?), that can point me in the right direction. More specifically, I'm
looking for a book that explains how to design and build databases, with
examples of the queries in MySQL. Most books describe how you install
MySQL, and list the SQL commands, but this information I already have. Can
any of you suggest to me some helpful learning material?
For the most part, _any_ good database design book for _any_ decent
relational database should do the job for you. That's because all (?) of the
professional grade databases use the same SQL and the same normalization
techniques to decide what columns belong in what tables and what primary and
foreign keys should be used. Therefore, a good design book for DB2 or Oracle
or Sybase would probably tell you almost exactly the same things as a good
design book specifically intended for MySQL. You will still need to use the
MySQL reference to help you with places where the MySQL syntax is slightly
different than the syntax used by the other database but this really
shouldn't happen too often.
However, if you want a design book specifically written for MySQL, you may
want to look at http://www.informit.com/articles/article.asp?p=30885&rl=1. I
should stress that I don't have this book, nor have I read it cover to
cover. But the sample chapter on database design is pretty good, so, if the
rest of the book is as good, you should come out okay. In fact, you may find
that the sample chapter alone, which you can read online for free, may tell
you everything you really want to know and save you the cost of the book. No
guarantees on that but it's a starting point anyway.
By the way, I have not seen any other MySQL Design books so there may be
others that are better. The URL I've given you actually mentions some other
books specifically for MySQL that may suit your personal learning style
better.
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]