Re: Kinda OT: Book database question

2006-02-01 Thread mysql

I think you will find a book ISBN is a reference 
to a particular publisher's version of a particular book.

So in answer to your question, if several different 
publishers, or even the same publisher have published 
several different books all entitled 'Huckleberry Finn' then 
to avoid ambiguity in identifying one particular book from 
that group of books, each book should have a unique 
identifier, which AFAIK is what the ISBN is all about.

The usual way to reference a book is by:

Title:
Author:
Publisher:
ISBN:
Date Published:
Edition:
Price:

plus any other attributes, such as hardback or paperback.

HTH

Keith


In theory, theory and practice are the same;
In practice they are not. 

On Wed, 1 Feb 2006, John Meyer wrote:

> To: mysql@lists.mysql.com
> From: John Meyer <[EMAIL PROTECTED]>
> Subject: Kinda OT: Book database question
> 
> Hi, I'm trying to develop my own book database, and I have a question
> about ISBN: Is that number linked to a book or to a title?  That is, can
> one title (say, Huckleberry Finn) have several ISBNs associated with it
> through several book releases?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Kinda OT: Book database question

2006-02-01 Thread Peter Brawley

John,

An ISBN is linked to a published book, sometimes just to a particular 
edition.


PB

John Meyer wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi, I'm trying to develop my own book database, and I have a question
about ISBN: Is that number linked to a book or to a title?  That is, can
one title (say, Huckleberry Finn) have several ISBNs associated with it
through several book releases?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFD4Sodj60GAoLuoDkRAmciAJ9NENzEBwW5vKNscbbKxIrYrGBLYQCdF4PN
n1hv7E1N51UJPLhVtxY+TOY=
=BNae
-END PGP SIGNATURE-

  



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.0/248 - Release Date: 2/1/2006


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Kinda OT: Book database question

2006-02-01 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi, I'm trying to develop my own book database, and I have a question
about ISBN: Is that number linked to a book or to a title?  That is, can
one title (say, Huckleberry Finn) have several ISBNs associated with it
through several book releases?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFD4Sodj60GAoLuoDkRAmciAJ9NENzEBwW5vKNscbbKxIrYrGBLYQCdF4PN
n1hv7E1N51UJPLhVtxY+TOY=
=BNae
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]