Want to know something

Reply

Join Date: Sep 2007
Posts: 5
Reputation: kedarkhedkar is an unknown quantity at this point 
Solved Threads: 0
kedarkhedkar kedarkhedkar is offline Offline
Newbie Poster

Want to know something

 
0
  #1
Oct 10th, 2007
I have a query about ISBN. Some books have one ISBN, SOME have two. Is it appropriate to use ISBN AS a primary key for a book table ( as I have seen it in one book).
What is ISBN basically. What can be the appropriate primary key for book & other products like laptops.
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6,145
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 212
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: Want to know something

 
0
  #2
Oct 10th, 2007
ISBN is a unique identifier for a publication.
You could use it as a primary key, but that would only work if you don't intend to ever have more than one copy of any specific edition of any specific title.
It will also not work if you consider different editions of the same title to be identical for the purpose of your application, as those would have different ISBN.

You can have 2 different ISBN per edition as you have seen. The original system which is still in widespread use to date uses a number made up of 10 characters (digits, and in some cases the letter X).
A new, complementary, system is being put into use which uses 13 characters. All books at this moment have an ISBN10. Some may also have an ISBN13.

Apart from that many publishers also use internal codes and numbers which they put on the back of books as well. These are not ISBN, but purely internal codes for the publisher, and aren't guaranteed unique anywhere.

The ISBN is made up of a number of sections, most notably a section indicating the publishing company.
That way each publisher has a block of numbers they can assign to publications.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 5
Reputation: kedarkhedkar is an unknown quantity at this point 
Solved Threads: 0
kedarkhedkar kedarkhedkar is offline Offline
Newbie Poster

Re: Want to know something

 
0
  #3
Oct 10th, 2007
if ISBN is not appropriate as a primary key? then what should be.
is ISBN only applicable to books. What about other products like laptops?
I have seen a database with strange 16 to 32 digit number as a primary key for products like laptops.
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,281
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 243
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: Want to know something

 
0
  #4
Oct 10th, 2007
Make your own number system and print and use barcode stickers.
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Java Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC